acCmdSavedImports (Parameters?) Access 2007

G

Guest

I found that in Access 2007, at the end of an Import or Export process, it is
possible to save the steps with a 'Name' and I have saved several different
Import operations with different 'Names'.
Within the code I am writing, I would like to use the acCmdSavedImports
command and select the import operation I need by specifying the 'Name' of
the import steps I previously saved. My intention is to avoid opening the
"Managed Data Task" window (where all the Import Names are listed) so that
the user cannot by mistake choose the wrong import 'Name'.

From what I can determine however the:
'DoCmd.RunCommand acCmdSavedImports'
does not seem to accept parametes like the 'Name' of the saved imports. If I
try to force a syntax like
'DoCmd.RunCommand acCmdSavedImports, "my saved import" or variation
thereof I get an error message.

Can somebody please suggest the correct syntax (if available) or suggest a
workaround?
In previous Access versions, it was possible to save import or export steps
for some type of files and then use that name as a parameter in
"TransferText" or similar command.

The help of this expert community is very much appreciated.
 
Joined
Jun 13, 2010
Messages
1
Reaction score
0
=?Utf-8?B?R2lubw==?= said:
I found that in Access 2007, at the end of an Import or Export process, it is
possible to save the steps with a 'Name' and I have saved several different
Import operations with different 'Names'.
Within the code I am writing, I would like to use the acCmdSavedImports
command and select the import operation I need by specifying the 'Name' of
the import steps I previously saved. My intention is to avoid opening the
"Managed Data Task" window (where all the Import Names are listed) so that
the user cannot by mistake choose the wrong import 'Name'.

From what I can determine however the:
'DoCmd.RunCommand acCmdSavedImports'
does not seem to accept parametes like the 'Name' of the saved imports. If I
try to force a syntax like
'DoCmd.RunCommand acCmdSavedImports, "my saved import" or variation
thereof I get an error message.

Can somebody please suggest the correct syntax (if available) or suggest a
workaround?
In previous Access versions, it was possible to save import or export steps
for some type of files and then use that name as a parameter in
"TransferText" or similar command.

The help of this expert community is very much appreciated.


Try

Code:
DoCmd.RunSavedImportExport ("Name_of_your_saved_import_goes_here")
 

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

Top