Use file dialog in Access 2000

[Francis]

I would like to have a button on an Access form that brings up a file dialog.
Specifically I want to get a new file name and then make a new database with that name.
I use VB a lot, but there is no common dialog in the Access toolbar. Do I need some reference?
Your Help appreciated, thanks.

 

[Rolliee]

Use an unbound textbox with any fancies you want and then do an 'on click' event and open, create or do any other thing you want with the tables in currentdb().

rollie@bwsys.net

 

[Francis]

Sorry that did not help. I know to use on click, but what do I put in there to bring up a standard File New (I do not want to invoke Access's New command, I just want a file dialog that returns a file name.
Thanks

 

[Francis]

Sorry that did not help. I know to use on click, but what do I put in there to bring up a standard File New I do not want to invoke Access's New command, I just want a file dialog that returns a file name.
Thanks

 

[oharab]

Go to

http://www.robotparade.co.uk

& get the FindAndRunFiles.zip file from the download page.
There is a module in that file called mdlOpenSaveDialogs. Copy that into your database and have a look at the examples on how to call and use the open/save dialogs.
If you get stuck, post again & I'll talk you through it.

HTH

Ben ----------------------------------
Ben O'Hara
Home: bpo@RobotParade.co.uk
Work: bo104@westyorkshire.pnn.police.uk
Web:

http://www.RobotParade.co.uk

----------------------------------

 

[Francis]

Just what I needed, thank you.

 

[nberryman]

Look at thread181-307043

Ben sent me the code a couple of weeks ago.

Thanks again Ben

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com