Print History storing into table

[siddnave2]

Hi,

Can any one help me to record printing history issued from my access form created by me. the details required to be stored in access table with date,username,reportname, No of prints.

Thanks in Advance.

Naveen.

 

[CJ_London]

you need a table to store the results and in the code behind your print button so code something like

currentdb.execute("INSERT INTO tblPrintLog (date,username,reportname, printQty) VALUES(now(),'" & username & "', '" & reportname & "', " & printNumber & ")"

change names to suit your setup. It is assumed you would get username from a global variable set at login time, reportname and quantity from your form