Using Access Dialog Boxes within VB code

  • Thread starter Thread starter J Killam
  • Start date Start date
J

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?
 
J Killam said:
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.
Click to expand...

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
 
Back
Top