File Modal Dialog Box

[drkestrel]

What is wrong with the following-

Application.Dialogs(xlOpenDialog).Show

the above results in compilation error complaining that Dialogs is not a member of Application!!!

I literally copy that out from the online F1 example!!

I just want a file open dialog box!
[sig][/sig]

 

[Jonathan]

You have copied the example from the Excel help, and this doesn't work in access. Displaying an open dialogue in access is a bit more involved... but there is an example in the Solutions database that comes with Access. It's part of the code that demonstrates how to relink tables at startup.

If you have any problems with this, let me know and I'll email you some code.

[sig]<p> Jonathan<br><a href=mailto:j.w.george@virginnet.co.uk>j.w.george@virginnet.co.uk</a><br><a href= > </a><br>Working with: Visual Basic 6, Access 97, Visual Interdev 6, VBScript, Active Server Pages, SQL Server 6.5, Oracle 7[/sig]