If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Macros, coding and design
How does one best outfit Access2003 so
-- When the .mdb file opens, it writes a =Now() Date to a field in Table? When the .mdb closes, it writes a =Now() Date to a field in Table? -- What, I wonder, is MSysObjects hidden table? -- Jim Shores on Red Mountain in Birmingham, Alabama |
#2
|
|||
|
|||
Macros, coding and design
Jim
If you have a form that is opened when the file opens, you could add event code to when it opens. If that's the "last" form that closes, you can use that event, too. You can create a code module to handle the writes-to-table -- you just need events (?OnOpen, OnClose?) to trigger that code. -- Good luck Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|