Open/Save Dialog Boxes

[chinny03]

I am having trouble trying to get the Open/Save dialog boxes.

I have pasted the text at http://www.mvps.org/access/api/api0001.htm but
can't get anything to work.

I have a button that the user clicks and will let them browse to a file that
will later be used to read. The other button will do a concatenation of all
the fields in the form and also let the user browse to a path of where to
save the file and lets them save it. Any help would be greatly appreciated.
Thanks.

 

[Klatuu]

"Can't get anything to work" is not much to go on. The code works really
well. I have been using it for several years. In the code you downloaded,
there is a function named GetOpenFile(). If you study it closesly, you will
begin to understand it.

Open your VBA editor. Open the Immediate window. Open the module you have
the code in. Put a break point on this line:
If IsMissing(varDirectory) Then

Now you can step through the code line by line and see how it works.

If you have a more specific question about what is not working for you, post
back and we can go from there.