How do I run a query and print a report of that query when my data

  • Thread starter Thread starter mjisaacs
  • Start date Start date
M

mjisaacs

I have a query and a report built that I click on and it runs properly. I
need to know how to make this automatic. By this, I mean, I want the action
to take place every time my datalogger software adds a new record to the
database.
 
I have a query and a report built that I click on and it runs properly. I
need to know how to make this automatic. By this, I mean, I want the action
to take place every time my datalogger software adds a new record to the
database.
Click to expand...

What happens - within Access, in a trappable manner - when the datalogger
software adds a new record? Is this "push" from the datalogger, or "pull" from
an Access event?

Do you really want to print a new report *WITH EVERY RECORD IN YOUR TABLE*?
Sounds like it could be a enormous waste of paper!

John W. Vinson [MVP]
 
My query/report is set up to only print the last record added. When I double
click the shortcut I created, I get the printout of the last record, as
desired. What I need to know is how to automate this. The datalogge
"pushes" the data into the database when it is told to do so by my industrial
PLC. Using this, how can I trigger my report/query when a new record is
added?
 
Back
Top