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 10:43:06


Thank you. Can you tell me how I would then carry that through so I would not
have to prompt the user 43 more times?
 
 
 

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

Post by Van T. Din » Fri, 01 Jul 2005 11:26:14

43 times for 43 files??? (You did write "files" in your original post.)

Are you importing different Objects from a _single_ database files?

--
HTH
Van T. Dinh
MVP (Access)






not

 
 
 

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

Post by Z2luZ2V » Fri, 01 Jul 2005 22:55:02

Thanks. That worked great. But now I need to know how to use that input
parameter for the next 4 filename arguments, since they will be the same?
 
 
 

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

Post by Z2luZ2V » Fri, 01 Jul 2005 23:56:04

I am sorry if I mislead you, 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 Z2luZ2V » Fri, 01 Jul 2005 23:56:13

Let me clarify, 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 John Nuric » Sat, 02 Jul 2005 06:04:34

To do this with a macro you'll need a form with a textbox on it. Let's
call the form frmF and the textbox txtOffice. Put the field office name
in the textbox.

Then, in the macro you repeat the TransferDatabase action six times. To
get the field office name, use
=[Forms]![frmF]![txtOffice]



On Thu, 30 Jun 2005 07:56:13 -0700, ginger





Please respond in the newgroup and not by email.