How do I prompt for a parameter when I want to import using a

How do I prompt for a parameter when I want to import using a

Post by Z2luZ2V » Fri, 01 Jul 2005 08:02:03


Is there a way I can carry that through for future steps without making them
re-enter it?
 
 
 

How do I prompt for a parameter when I want to import using a

Post by Z2luZ2V » Fri, 01 Jul 2005 08:04:03

Is there a way I can save this so I can use this again and they do not have
to re-enter it? There will be 4 other files that I will need that parameter
for.

 
 
 

How do I prompt for a parameter when I want to import using a

Post by Z2luZ2V » Fri, 01 Jul 2005 23:58:03

Please let me clarify. I am sorry I am not being clear, I am not very
experienced.
I have 43 field offices with 6 databases. Inside each database is 1 table I
want imported. So I want to repeat the field office name 5 times after it is
entered once.
 
 
 

How do I prompt for a parameter when I want to import using a

Post by Steve Scha » Sat, 02 Jul 2005 02:48:56

Ginger,

You could have an unbound textbox on a form where the macro is triggered
from, and the user can enter the name of the file name in there, and
then your Database Name argument can be the equivalent of...
="C:\YourFolder\" & [NameOfTheTextbox] & ".mdb"

On another topic... Do you mean there are 6 databases in each of the 43
offices? Can you say what is the difference between the 6 databases?
What you are doing is very unusual, and leads me to suspect that the
whole thing could be simplified.

--
Steve Schapel, Microsoft Access MVP
 
 
 

How do I prompt for a parameter when I want to import using a

Post by S2Vl » Sun, 14 Sep 2008 04:05:01

Is it possible to use wild card characters in this function when looking for
a files that vary by a few numbers?