Microsoft Access Auto Print

  • Thread starter Thread starter Intern08
  • Start date Start date
I

Intern08

I am trying to get a report and a label to print automatically once a test
has been finished. The way the system works is a test program dumps data into
access and once that data is done dumping I want the report and label with
that information already update in them to automatically print.

So in a sense...once access updates the label and report with the new data I
want to set up an auto print command. Any Ideas??
 
as far as i know what you want is a trigger but access dosnt have
triggers it has to be done manually if you are runing this test
program and the dump of data into access from excel or word or
something you can manipulate access from word or excel using vba code
to automatically do some work as an event in that application but if
you have some external application that saves information to the mdb
file directally then the only way is to open access and run the report
then click print

tell me if you are trying to do the first thing and ill give you some
information

hope this helps
 
Intern08 said:
I am trying to get a report and a label to print automatically once a
test has been finished. The way the system works is a test program
dumps data into access and once that data is done dumping I want the
report and label with that information already update in them to
automatically print.

So in a sense...once access updates the label and report with the new
data I want to set up an auto print command. Any Ideas??

The test program will need to automate access and call the methods
needed to print the report. You might want to move this question over to
a VBA group for more details.
 
Back
Top