Using a parameter in a transferdatabase macro

  • Thread starter Thread starter ginger
  • Start date Start date
G

ginger

I have 55 county files I need to import to a central db.
I am looking for a way to pass the county name as a string
to the database name parameter in the transferdatabase
macro.
Example: \\ivan\mm\field office
backups\"COUNTYNAME"\data\vrdisedu.mdb
"COUNTYNAME" will be 55 different counties, with all other
info staying the same.

Please help!
 
You might try this:

="\\ivan\mm\field office backups\" & InputBox("Enter County Name:") &
"\data\vrdisedu.mdb"
 
Thank you. That worked GREAT!
-----Original Message-----
You might try this:

="\\ivan\mm\field office backups\" & InputBox("Enter County Name:") &
"\data\vrdisedu.mdb"


--

Ken Snell
<MS ACCESS MVP>




.
Thank you. That worked GREAT!
Click to expand...
 
Back
Top