D
DM - NPS
I have a table (tbl_Tree) that gets updated weekly using data collected from
a GPS unit. So what I want to do...... Create a command button that lets
the user designate where the Access database is located. Once the user does
this, it will automatically go into that database, find the table "tree" and
link to it, copy the records from the table tree and load them into my table
(tbl_Tree), delete the linked table, and then open the tbl_tree so the user
can verify that their records were loaded.
I used a macro with 5 steps: TransferDatabase (to link to the table in the
other access database), Open Query (append query that appends records from
the linked table to my table, deleteObject to delete the linked table,
OpenTable to open the table, and GoToRecord to go to the first record.
This works GREAT, the only problem in the TransferDatabase command I have to
enter the entire pathway and database name that contains the table I want to
link to. The problem is everytime we download from the GPS unit the name
changes so the user must go and rename the database before they click the
command button.
How do I do a TransferDatabase method that lets the user designate the
database that contains the table "tree" to link to?
Sorry for the long message but thanks for the help.
a GPS unit. So what I want to do...... Create a command button that lets
the user designate where the Access database is located. Once the user does
this, it will automatically go into that database, find the table "tree" and
link to it, copy the records from the table tree and load them into my table
(tbl_Tree), delete the linked table, and then open the tbl_tree so the user
can verify that their records were loaded.
I used a macro with 5 steps: TransferDatabase (to link to the table in the
other access database), Open Query (append query that appends records from
the linked table to my table, deleteObject to delete the linked table,
OpenTable to open the table, and GoToRecord to go to the first record.
This works GREAT, the only problem in the TransferDatabase command I have to
enter the entire pathway and database name that contains the table I want to
link to. The problem is everytime we download from the GPS unit the name
changes so the user must go and rename the database before they click the
command button.
How do I do a TransferDatabase method that lets the user designate the
database that contains the table "tree" to link to?
Sorry for the long message but thanks for the help.