C
commexec
G'day,
I am very unknowledgeable when it comes to ms access so please b
patient.
What I have atm is a database where we put all correspondence that cme
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 th
switchboard form, and see if the year(yyyy) is 1 greater than the las
record in a table, then append that table to the archive table. If i
isn't then do nothing.The append query is ready to go, but I lack th
skills to write code or whatever to make it happen when it is suppos
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 ar
using Access97.
Thanks for any help
I am very unknowledgeable when it comes to ms access so please b
patient.
What I have atm is a database where we put all correspondence that cme
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 th
switchboard form, and see if the year(yyyy) is 1 greater than the las
record in a table, then append that table to the archive table. If i
isn't then do nothing.The append query is ready to go, but I lack th
skills to write code or whatever to make it happen when it is suppos
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 ar
using Access97.
Thanks for any help