Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
View report as PDF
Using Access 2000 and need help opening report as a PDF using Lebans A2000ReportToPDF which uses this code to open a report in a listbox of a form: Private Sub cmdReportToPDF_Click() Dim blRet As Boolean blRet = ConvertReportToPDF(Me.lstRptName, vbNullString, _ Me.lstRptName.Value & ".pdf"...- Hafa1961
- Thread
- Replies: 4
- Forum: Microsoft: Access Reports
-
Find record, add record or do nothing
I have an AfterUpdate code that uses the DLookup function to find the matching record in a corresponding table. If the matching record exists, the field is changed to the correct value based on DLookup of corresponding table. Here is my problem: If matching record does not exists the current...- Hafa1961
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
-
DLookup for duplicate entry
I have a form After Update event for a field that checks to see if a Supplier Ref has been used before. If so, it alerts the user of a duplicate entry. But what I need the code to do is to check the Supplier Ref against the SupplierID for that record. If the duplicate Supplier Ref was not used...- Hafa1961
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
DLookup and Message Box
I have a textbox named SupplierRef and when a user enters a reference the code below checks to see if a duplicate reference has been entered. If so, a message box pops-up informing the user a duplicate reference as been entered and enter another. Private Sub SupplierRef_AfterUpdate() Dim...- Hafa1961
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
