OpenFile Dialog Box (2000)

Topic

New Reply

I know in MS Word you can use the DIalogs(wdDialogFileOpen) command to launch the File…Open feature. Is there something similar you can do in Access too? Thanks, Steve

Reply | Quote

Replies

Steve,
Here is an example of open dialog box in Access97
Copy the API and the code on the form to suit your needs
Scott

Reply | Quote

OK, never mind – got it. Use this variable to return the file selected: filepicked (the variable) = cdlg.Getname.

Reply | Quote

I pulled a copy of the attachment and it seems to do what I want, except that i want to put the form code into a module procedure, but it dies on the line:

lngFormName = Me.hwnd

As I am not using a form.

I admit I don’t understand the coding (hence my question)

Could you modify the form code for me so that it will run from a module please?

Reply | Quote

You can’t use the keyword Me in a standard module, only in a class module, which includes the code behind a form or report. If you aren’t using a form, you can use the hWnd of the Access application itself like this:

AccessHWnd = hWndAccessApp

Reply | Quote

Thankyou Charlotte!
I have muddled through and got the coding in the right place. I have been after this sort of thing for a while.

Reply | Quote

Scott, thank you very much for your reply. This looks like just what I need. I appreciate your time…!!!

Reply | Quote

Hey Scott (or anyone else), one quick question for you please. How do I return the variable path to the file that the user selected…? E.g., filepicked = “C:DataTestFile.txt”

Reply | Quote