Building a Macro?

[Hulk]

I have a database which I have to import into on a daily basis, the
problem iw that when I import I must also go to all the forms (3) and
reports (3) and update the properties to select the new database. Is there
a way to build something that when clicked on will ask for a variable and
then update all the properties at one time.


Thanks

Bill

 

[John Vinson]

I have a database which I have to import into on a daily basis, the
problem iw that when I import I must also go to all the forms (3) and
reports (3) and update the properties to select the new database. Is there
a way to build something that when clicked on will ask for a variable and
then update all the properties at one time.


Thanks

Bill

Um?

All your Forms and Reports should be based on queries which reference
one or more tables. Rather than importing into a new tablename every
time, empty the table (if that's appropriate) and import the data
*into that table*. That way your Forms and Reports will not need any
modification at all.