Open Dialog box

[stevkev]

I have a database using Access 2002 that on startup checks to make sure all linked tables (links to different worksheets on the same .xml spreadsheet file so only one file needs to be found) exists at the current connect location. In the event that they do not exist there it immediately checks in the currentdb directory and updates the link as required. In the event that the file is not present in the currentdb directory I wish to have an Open dialog box come up where the user browses to find the necessary file. It is this dialog box that I have no idea how to create. Thank you in advance.

 

[Cheryl Fischer]

See the following code in The Access Web:

Call the standard Windows File Open/Save dialog box:
http://www.mvps.org/access/api/api0001.htm

and, in case you want to compare code:

Relink Access tables from code:
http://www.mvps.org/access/tables/tbl0009.htm

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I have a database using Access 2002 that on startup checks to make sure

all linked tables (links to different worksheets on the same .xml
spreadsheet file so only one file needs to be found) exists at the current
connect location. In the event that they do not exist there it immediately
checks in the currentdb directory and updates the link as required. In the
event that the file is not present in the currentdb directory I wish to have
an Open dialog box come up where the user browses to find the necessary
file. It is this dialog box that I have no idea how to create. Thank you in
advance.

 

[stevkev]

Ya i've found that example of code before but i've been running into this problem... the sub ahtAddFilterItem is not recognized. Is this in one of the reference libraries included with office that i may not have or do i have to write it manually... and if so how do i do that. thnx again

 

[Stevkev]

Sorry... didn't read the code all the way through... got it working now thank you