Printing issue

[psharp]

Access 2003 data base with many end users. This is a training and incident tracking system and the end users need to print reports for each record. Is there a way to print just one record at a time as opposed to printing all records or having the users have to indicate what pages they need to print?

 

[SpentGeezer]

Access 2003 data base with many end users. This is a training and incident tracking system and the end users need to print reports for each record. Is there a way to print just one record at a time as opposed to printing all records or having the users have to indicate what pages they need to print?

This sample from the SGA may help...

 

[bulrush]

I usually have an edit screen where the user can edit one record. On this screen I have many buttons, Add, Delete and Print Screen (prints current record only). If a print screen will fit on one piece of paper, I do make a command button with this code (code from Access macro wizard):

dim procname as string
On Error GoTo Err_cmdPrintScreen_Click
procname = "cmdPrint"
docmd.hourglass true
    Runcommand acCmdSelectRecord
    DoCmd.PrintOut acSelection

Exit_cmdPrintScreen_Click:
docmd.hourglass false
    Exit Sub

Err_cmdPrintScreen_Click:
    Call DispError(procname)
    Resume Exit_cmdPrintScreen_Click

In my case, printing the gray background of the form (using this code) is usually acceptable practice. YMMV.