Argument question in a macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ginger - 02 Aug 2004 23:22 GMT

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 argument 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!
.

Reply to this Message

Ken Snell - 03 Aug 2004 01:22 GMT

see answer in macros group

Signature

Ken Snell
<MS ACCESS MVP>

> 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
[quoted text clipped - 7 lines]
> Please help!
> .

Reply to this Message