G'day,
I am very unknowledgeable when it comes to ms access so please be patient.
What I have atm is a database where we put all correspondence that cmes in and goes out. Very basic design it has a number, date, file number, and some text boxes for other things.
When the db opens, I want it to check the current date on the switchboard form, and see if the year(yyyy) is 1 greater than the last record in a table, then append that table to the archive table. If it isn't then do nothing.The append query is ready to go, but I lack the skills to write code or whatever to make it happen when it is suppose to.
The names in tables, queries and forms are:-
frm_in-log
frm_out-log
Switchboard
tbl_in-log
tbl_out-log
tbl_archive
qry_in-log
qry_out-log
Like I said, I have very basic knowledge of MS Access. Oh and we are using Access97.
Thanks for any help.
I am very unknowledgeable when it comes to ms access so please be patient.
What I have atm is a database where we put all correspondence that cmes in and goes out. Very basic design it has a number, date, file number, and some text boxes for other things.
When the db opens, I want it to check the current date on the switchboard form, and see if the year(yyyy) is 1 greater than the last record in a table, then append that table to the archive table. If it isn't then do nothing.The append query is ready to go, but I lack the skills to write code or whatever to make it happen when it is suppose to.
The names in tables, queries and forms are:-
frm_in-log
frm_out-log
Switchboard
tbl_in-log
tbl_out-log
tbl_archive
qry_in-log
qry_out-log
Like I said, I have very basic knowledge of MS Access. Oh and we are using Access97.
Thanks for any help.