![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
If I do an export from an A2007 database and save the export, it then becomes available under the "Saved Exports" button on the "External Data" tab of the Ribbon. If I use this button to run the export, the "Manage Data Tasks" window appears, I use the "Run" button to do the export and a message box appears to tell me that the export was successful. If however I use code on a command button like: DoCmd.RunCommand acCmdSavedExports all of the above happens except there is no message box confirming to the user that the export was successful. The export happens but there is no feedback to the user. Why is this? |
#3
| |||
| |||
|
|
I speculate this is by design: if you run the command you get no prompts whatsoever and the program can just move on to the next statement, or if you want to do it step by step there is the manual way. Nothing prevents you from checking if the file exists after the export, and if it has the correct file date/time. -Tom. Microsoft Access MVP |
#4
| |||
| |||
|
|
On Apr 24, 11:25*pm, Tom van Stiphout <tom7744.no.s... (AT) cox (DOT) net> wrote: I speculate this is by design: if you run the command you get no prompts whatsoever and the program can just move on to the next statement, or if you want to do it step by step there is the manual way. Nothing prevents you from checking if the file exists after the export, and if it has the correct file date/time. -Tom. Microsoft Access MVP Thanks for the reply Tom. If it is by design, would it have not been better to keep the message box and kill it using SetWarnings if desired? |
#5
| |||
| |||
|
|
This is not a warning, but a success confirmation. |
![]() |
| Thread Tools | |
| Display Modes | |
| |