Search results

REFERENCES For more information about Activate and Deactivate events, search the Help Index for "Activate," or ask the Microsoft Access 97 Office Assistant. For more information about Print events, search the Help Index for "Print Event," or ask the Microsoft Access 97 Office Assistant. The...

why can'i use this module please

from microsoft,it works fine Create a table with the following structure: Table: tblPrintedReports -------------------------------------------------- Field Name: ID DataType: AutoNumber Indexed: Yes (No Duplicates) Field Name: ReportName...

try with the ommand line "DoCmd.RunCommand acCmdSaveRecord" To save and exit the form I have a save button with the following code connected onClick: MsgBox "Please Collect The Print Out" DoCmd.Close DoCmd.OpenForm ("Main Menu") This saves the data that has been entered on the form, closes...

Rich thanx for yur help , the solution was with this code Private Sub cmdPrint5_Click() On Error Resume Next DoCmd.RunCommand acCmdSaveRecord If DCount("*", "tbl1", "PrintYesNo=False AND notification=False") > 0 Then DoCmd.OpenReport "affichage", acViewPreview, , "PrintYesNo=False AND...

sorry now right

i try again

converted o 97

this is a copy of my DB

i have use it but no solution . sorry for my bad english.

i use this code it work fine . my problem is if no data i got my form print as number of rows x2. CODE Private Sub cmdPrint5_Click() On Error Resume Next DoCmd.RunCommand acCmdSaveRecord Dim stDocName As String DoCmd.OpenReport "affichage", acViewPreview, WhereCondition:=" PrintYesNo = False...

I need the button to print any records that have not already been printed, even if this means you click on the button at 10am in the morning and then you might want to click on it at 12am the same day - the button just needs to pick up only the reports that haven't been printed before and print...

the best way tu use autonumber without autonumber.

perhaps a solution with this

sorry for my bad english can someone put an exemple.and what we must do when we use winrar?