Automatically printing a report based on a new entry

  • Thread starter Thread starter SQL Brad
  • Start date Start date
S

SQL Brad

Hello all, I am wanting to do the following:

I want to enter some demographic data for some vendors using a web-front end
on an intranet. Basically we are going to enter contract data, then as soon
as the record is added in the database, I want 3 or 4 different reports to
print to a laser printer. After the report is printed, I want the record
moved to a different table (that holds all contract information).....in
essence when a person enters the information via a web-front end, it would go
to a temp table, then after the report prints, it gets moved to a permanent
table...is there a macro that checks for new records and if there is one...it
does x actions....

thanks in advance.
 
Brad,

There is no Event in Access that detects when a new record has been
added to a table.

One option would be to have a macro running on the Timer event of a
form, which counts the number of records every so often (whatever is an
apopropriate interval in your scenario), and takes the actions if there
has been an increase. You could use a TempVar via the SetTempVars
action to hold the current record count.
 
Back
Top