File Dialog box for Access 2000

[03Explorer]

I tried to follow the thread thread 705-755820 but the last code given does not work for me. What is the reference library? I am trying to have a screen allow the user the ability to 'browse' for a file. The located file with path populates a text field (giving the user one chance to change it before starting a process). The process from there is to import an ascii file using a spec (which is another question on how to import via Coding using a defined spec).

Thanks

 

[PHV]

The Microsoft Office Object Library

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[03Explorer]

I just added the reference to 'Microsoft Office 11.0 Object Library' and I still can not compile on the line with ... Application.FileDialog

FileDialog is not an option. Error = "Method or data member not found"

 

[PHV]

Microsoft Office 11.0 Object Library
So, you should have access 2003 ?
Works for me with this version.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[CautionMP]

03Explorer,
Just in case it can also be done with API's.

MSDN > Display Open and Save As Dialog Boxes in Access with API Functions

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[CaptainD]

Try this line

Application.FileDialog(msoFileDialogOpen).Show