|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 21st, 2003, 10:30 PM
|
|||
|
|||
|
access 2002 save as dialogue
hi,
I wish to run some code after clicking a button in an access database that displays a file browser type of dialogue. when prompted the user is able to select various locations to backup the current database...ie browsing through network places, my computer, floppy or usb thumb drives etc. just like a normal save as dialogue box. how can i accomplish this using vba code? ...any thoughts or suggestions would be greatly appreciated. Regards, Aaron.
|
|
#2
September 23rd, 2003, 06:43 AM
|
|||
|
|||
|
try
Code:
Dim dlgSaveAs As FileDialog Set dlgSaveAs = Application.FileDialog(msoFileDialogSaveAs) dlgSaveAs.Show You need to include the right libraries for this to work and I don't know which those are. There is also a more complicated way to open a file save/load dialog by calling functions from comdlg32.dll. Pascal
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > access 2002 save as dialogue |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
