User Profile

viveksarthak

Last Activity: Aug 12 '17, 04:47 AM

Joined: Aug 12 '17

Location:

viveksarthak replied to Search for a record and print a report

in Access

Aug 12 '17, 04:46 AM

Code:

Private Sub cmdAll_Click()
Dim LSQL  As String
 
'Clear criteria
GCriteria = ""
 
'Display all customers
LSQL = "select * from Customers"
 
Form_frmCustomers.RecordSource = LSQL
Form_frmCustomers.Caption = "Customers (All customers)"
 
MsgBox "All customers are now displayed."
 
End Sub
 
Private Sub cmdReport_Click()

...

See more | Go to post

Last edited by NeoPa; Aug 12 '17, 04:58 PM. Reason: Added mandatory [CODE] tags.

Profile Sidebar

Leave a comment:

how to make search button for my website for finding anything