File open dialog

  • Thread starter Thread starter Christian Altenhofen
  • Start date Start date
C

Christian Altenhofen

Hello!

I have a small problem. Right now I´m trying to transform a VBA-module from
excel to access. The first problem I encountered was to start the "open
file" dialog! How can I start that dialog from VBA in access.
I hope this is the right group for this question and youcan help me!
Thank you in advance!

cu,
Christian Altenhofen
 
Well, unfortunately I have to use Access 97 running under W2k. Additionaly I
have no way of using the internet right now.
I found a reference in book but on my system there is no "comdlg32.dll"

So if you can help me...

Thanx,
Christian
Allen Browne said:
If you are using Access 2002, you can get to the FileDialog object through
the Office 11 Library (References on Tools menu from any code window).

However, the object is very limited. You are better off using the API call
detailed here:
http://www.mvps.org/access/api/api0001.htm
Click to expand...
[/QUOTE]
 
Be very glad you don't have comdlg32.dll. It's buggy, and prone to broken
references.

The API call in the link I posted is what you need. It may look a little
scary if you are not used to them, but it's actually very simple. Just put
the code into a standard module (one created by clicking New on the Modules
tab of the Database window), and you can call the file open routine from
where ever you like.

It's certainly the best approach with A97.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.


Christian Altenhofen said:
Well, unfortunately I have to use Access 97 running under W2k. Additionaly I
have no way of using the internet right now.
I found a reference in book but on my system there is no "comdlg32.dll"

So if you can help me...

Thanx,
Christian
Click to expand...
[/QUOTE]
 
Hello!

Thank you very much. But could youpleaase send me the code, as I´m not able
to go to the internet right now.
I would be very thankful!

Christian Altenhofen
 
Good news.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.


Christian Altenhofen said:
Hi!

By now I haveit figured out!
Thank you for your help!

cu,
Christian
Click to expand...
 
Back
Top