Dialog boxes

How do I make them in MS Access 2000?

Page 1 of 1

0 Replies - 979 Views - Last Post: 31 March 2008 - 06:31 AM Rate Topic: -----

#1 nick.moult  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 15-October 07

Dialog boxes

Posted 31 March 2008 - 06:31 AM

Hi All,
I'd recently put together a database for somebody in MS Access 2003. Part of the front end had a form with a button the user could click to open up a dialog box. I achieved this using code I've shown below....

Dim fDialog As Office.FileDialog
Dim pDialog As Office.FileDialog

Set fDialog = Application.FileDialog(msoFileDialogFilePicker)
etc

It was all pretty easy for me to do and worked fine. I've now realised though, that it doesn't work on Access 2000 and earlier, and the only way to do it is through activex controls.

I've go no idea how to do it, and have looked around online, but just don't know where to start.

Can anyone help? All I really need to be able to do is select files on the user's computer via form based front end witha dialog box.

Cheers
Nick

Is This A Good Question/Topic? 0
  • +

Page 1 of 1