Using Access Dialog Boxes within VB code

[J Killam]

I am trying to write code that will allow a user to click
on a button in a form and call up a dialog box to browse
to a file to be imported. Thus far, I am not finding a
way to do this. Something like this can be easily done
with excel (application.dialogs(xlopen).show) but I have
found nothing to do something similar in Access.

Any suggestions?

 

[Tony Toews]

I am trying to write code that will allow a user to click
on a button in a form and call up a dialog box to browse
to a file to be imported. Thus far, I am not finding a
way to do this. Something like this can be easily done
with excel (application.dialogs(xlopen).show) but I have
found nothing to do something similar in Access.

Call the standard Windows File Open/Save dialog box
http://www.mvps.org/access/api/api0001.htm
"ACC97: How to Use the Common Dialog API in an Access Database"
http://support.microsoft.com/?kbid=303066
While the article is in A97 the same code will work in newer versions
of Access

There is something in A2003 as well. Maybe that's also in A2002
though. I'm not sure.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm