I need help printing only one record. the command i use prints all records.
Printable View
I need help printing only one record. the command i use prints all records.
I don't understand exactly what you're doing, but maybe you can build a query that will return just the one record you're after, and then print the results of that query?
I am very new to vb and trying to make a front for a database. I can print the access report using the code below but it prints all records and i just want to print the current record.
Private Sub Command2_Click()
Dim oApp As Object
Set oApp = GetObject("C:\windows\desktop\security\security.mdb", "access.application")
oApp.Visible = False
oApp.DoCmd.openReport "security"
End Sub