 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / June 2005How do I prompt for a parameter when I want to import using a macr
I am using the transferdatabase action in a macro. I will be importing several dozen files that only vary by a single name. How can I use a variable in the database name argument that prompts the user for a parameter? If I recall correctly (I haven't touched Macros in years), you can use the InputBox() function in the "Database Name" argument to ask the user to enter the full path of the database file.  SignatureHTH Van T. Dinh MVP (Access) > I am using the transferdatabase action in a macro. I will be importing > several dozen files that only vary by a single name. How can I use a variable > in the database name argument that prompts the user for a parameter? 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? > If I recall correctly (I haven't touched Macros in years), you can use the > InputBox() function in the "Database Name" argument to ask the user to enter [quoted text clipped - 4 lines] > variable > > in the database name argument that prompts the user for a parameter? 43 times for 43 files??? (You did write "files" in your original post.) Are you importing different Objects from a _single_ database files? SignatureHTH Van T. Dinh MVP (Access) > 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? 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. > 43 times for 43 files??? (You did write "files" in your original post.) > [quoted text clipped - 3 lines] > not > > have to prompt the user 43 more times? Use something like this for the filename argument: ="C:\My Folder\ABC" & InputBox("Enter the middle part of the filename") & "XYZ.mdb" >I am using the transferdatabase action in a macro. I will be importing >several dozen files that only vary by a single name. How can I use a variable >in the database name argument that prompts the user for a parameter? -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. 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? > Use something like this for the filename argument: > [quoted text clipped - 9 lines] > > Please respond in the newgroup and not by email. 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. > Use something like this for the filename argument: > [quoted text clipped - 9 lines] > > Please respond in the newgroup and not by email. 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] >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 [quoted text clipped - 13 lines] >> >> Please respond in the newgroup and not by email. -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.