How can I TURN OFF!!! the Access 2007 "Save Export Steps" ?

L

LSAW

Access 2007 Always asks me if I want to save the Export Steps - as a separate
screen to which I must respond. It's a time waster. Is there a way to turn
that off?
Also, when I HAVE saved export steps, It get 2 or 3 extra screens after I've
utilized the saved export. I don't have time for all those screens.
HELP, how can I turn them off. Thanks
 
A

Albert D. Kallal

For a saved exports, I only get an extra screen, and it less steps then
before.

However, I often hit ctrl-g, and use the command prompt

eg: type the following in the command prompt window:

docmd.RunSavedImportExport "exFax"

When you do the above, you get no prompts at all.

I think if you have to do a lot of these exports, then consider making a
form, or even a custom ribbon, and the whole process can become a one click
affair.

I don't believe the wizard screens etc. can be turned off. However, what is
great about computers is that once any task becomes repetitive and boring is
the very instant the opportunity arises to use some code to automate and
reduce that workload.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic Emails sent to my Contact Groups by Microsoft 1
Access 2007 - "Save Export Steps Wizard" 1
How can I save directly into the same folder every time in Office 365 / Windows 10? 0
Eliminate "Save Export Steps" dialog 0
Access 2007 Stop Asking Me to Save Export Steps 0
Documents from shared model are created with design mode on 1
disable save export steps 0
Export to Excel successful but old data remains 0

Top