dbTalk Databases Forums  

Access 2007 Saved Exports Problem

comp.databases.ms-access comp.databases.ms-access


Discuss Access 2007 Saved Exports Problem in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Wayne
 
Posts: n/a

Default Access 2007 Saved Exports Problem - 04-24-2009 , 05:19 AM






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?

Reply With Quote
  #2  
Old   
Tom van Stiphout
 
Posts: n/a

Default Re: Access 2007 Saved Exports Problem - 04-24-2009 , 08:25 AM






On Fri, 24 Apr 2009 03:19:11 -0700 (PDT), Wayne
<cqdigital (AT) volcanomail (DOT) com> 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


Quote:
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?

Reply With Quote
  #3  
Old   
Wayne
 
Posts: n/a

Default Re: Access 2007 Saved Exports Problem - 04-24-2009 , 04:33 PM



On Apr 24, 11:25*pm, Tom van Stiphout <tom7744.no.s... (AT) cox (DOT) net> wrote:

Quote:
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?



Reply With Quote
  #4  
Old   
Tom van Stiphout
 
Posts: n/a

Default Re: Access 2007 Saved Exports Problem - 04-25-2009 , 12:32 AM



On Fri, 24 Apr 2009 14:33:12 -0700 (PDT), Wayne
<cqdigital (AT) volcanomail (DOT) com> wrote:

This is not a warning, but a success confirmation.

-Tom.
Microsoft Access MVP


Quote:
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?

Reply With Quote
  #5  
Old   
Wayne
 
Posts: n/a

Default Re: Access 2007 Saved Exports Problem - 04-25-2009 , 12:47 AM



On Apr 25, 3:32*pm, Tom van Stiphout <tom7744.no.s... (AT) cox (DOT) net> wrote:

Quote:
This is not a warning, but a success confirmation.
You are correct. :-)


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.