Automate append

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which has 2 buttons that append updated info to each its own
tables; I have to manually press these buttons each day to update
information, is there a way to have this with VBA Code?

Thank
Octet
 
One approach would be to create a procedure that "presses those buttons"
(i.e., runs the code behind them) the first time the application is started
on any particular day.

To do this, you'll need a form you are sure will be opened (?startup form?),
an event procedure in that form's OnOpen event (to "press"), and I'd suggest
either a table to store "Last Date Run" or a file system .INI file to store
the same, so the routine doesn't run each time the application opens. The
routine will be responsible for checking today's date (Date()), checking the
"LastDateRun", and deciding whether to "press".

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Back
Top