I Need Dialog Boxes!!! 1

[Quintios]

OK, I found this thread: thread705-30483

I couldn't find any examples of dialog boxes for 'FileOpenSaveAs' or anything like that in the 'Solutions' database.

I do have the code from the VBA Developer's Handbook called 'basCommonDialog.bas'. I was wondering if this code is compatible with Access 97 and whether or not anyone has used it?

I'm trying to do the following things:

[ul][li]Pass a path string to a variable so that the end user can import a .CSV file into the database. The spreadsheet will not always be in the same place[/li]
[li]Pass a path string to a variable so I can use it in the code that exports database information to yet another .CSV file so the enduser can use it in another application.[/li][/ul]

Suggestions? Comments? Code? Help?
Onwards,

Q-

 

[petersdaniel]

The following site has an downloadable sample of Common File Dialog that works well. I have used it both in Access 97 and 2000 and have had no problem adapting it to various solutions

http://www.mvps.org/access/api/api0001.htm

petersdaniel@hotmail.com
"If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut." --Albert Einstein

 

[Quintios]

Yeah, this is pretty much the same code. The only problem is, *sigh*, I don't know how to use it.

What I have in my mind is that I call a function that opens the "GetFile" dialog box. When the user navigates to the file to get and clicks 'OK', the function then passes the pathname and filename back to the main subroutine.

The problem is I don't know how to get the dialog box to pop up. I keep seeing "wrapper function", and I don't know what that is either.

I'm going to keep reading this thing and maybe I'll figure it out, but if you can provide more of a hint than what's on the website I sure would appreciate it.

Regardless, thanks for the quick reply and information!
Onwards,

Q-

 

[Quintios]

OK, I got TestIt to work (like that was hard, duuuuhhhh). I just need to go from there.

In an environment where you have roaming profiles with Windows98, is there a way to have the default path to the user's 'Desktop' folder?
Onwards,

Q-