A
Arturo
I have a 2003 Access database that will be used at several sites. I’ll call
it MyDB. When the user gets the file, they will open it and will be presented
with a form asking for an ID number. In this example, I will use the ID
number ID6. Once this ID number is entered into the form it will be stored in
a linked database which I will call MyBE.
At the end of each session the MyBE file will be sent to another location.
Before sending the file I would like to rename it to the ID number and MyBE.
I need this to happen while the file MyDB is closing.
For example, the user clicks a button that tells the program to quit. While
closing, it renames MyBE to ID6MyBE.
Can anyone tell me how to do this? Thanks.
it MyDB. When the user gets the file, they will open it and will be presented
with a form asking for an ID number. In this example, I will use the ID
number ID6. Once this ID number is entered into the form it will be stored in
a linked database which I will call MyBE.
At the end of each session the MyBE file will be sent to another location.
Before sending the file I would like to rename it to the ID number and MyBE.
I need this to happen while the file MyDB is closing.
For example, the user clicks a button that tells the program to quit. While
closing, it renames MyBE to ID6MyBE.
Can anyone tell me how to do this? Thanks.