Re: open file dialog box in access 2000

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 02/13/05 

Date: Sun, 13 Feb 2005 14:06:47 -0500

The only way you can save the selected value is to store it somewhere:
controls on forms don't have any way to store values themselves.

That usually means binding the textbox to a field in the form's recordset,
although you could conceivably store the value in an INI file, or in the
registry or even in a custom property of the database. 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"MS Access 2000" <miriamnews@fischerinc.biz> wrote in message 
news:Of%23eiyfEFHA.2032@tk2msftngp13.phx.gbl...
> Hi,
> I'm working on a form where I want to be able to open the "open file" 
> dialog
> box, select a file, and save the filename into a textbox on the form.
> I don't have much experience in Access or VB or anything but I figure 
> things
> out as I go, so I'm pretty much working blind.
> I followed instructions here:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;303066 and got it 
> to
> work (dialog box opens, I select a file and click "open", filename and 
> path
> appears in the textbox), but when I close the form it removes the file 
> name
> from the textbox, and when I open the form again the textbox is blank.
> Can somebody help me please?
> Thanks,
> Miriam
>
>

Relevant Pages

  • open file dialog box in access 2000
    ... box, select a file, and save the filename into a textbox on the form. ... I followed instructions here: ... work (dialog box opens, I select a file and click "open", filename and path ...
    (microsoft.public.access.formscoding)
  • Passing Current DB filename to another DB
    ... I've got a thread started in the multiuser section, but I wanted to post this ... Can an open DB pass it's filename to another DB it opens with code? ... I'm guessing I'll need a local table to store that data. ...
    (microsoft.public.access.modulesdaovba)
  • Re: OT- Shopping in hard economic times just got harder
    ... figured walmart took it back from someone else and 'they' sealed it up ... the store and make sure it is what should be inside. ... My friend in China says everyone there *always* opens anything they're ... I'm opening EVERYTHING from here on out.. ...
    (alt.home.repair)
  • Re: OT- Shopping in hard economic times just got harder
    ... just figured walmart took it back from someone else and 'they' ... leave the store and make sure it is what should be inside. ... My friend in China says everyone there *always* opens anything ... I'm opening EVERYTHING from here on out.. ...
    (alt.home.repair)
  • Re: Form "relations"
    ... 3/ Do I want to store anything else with this, user name, ... to contain the calling forms name just after the calling ... opens the new form. ... parent/child relationship, something like ...
    (microsoft.public.access.formscoding)