Recent content by reddwarf999

Have a report based on a query. Report opens in preview mode and shows only one line of data when there should be mutiple lines. Using this code below to output a snapshot file: Sub OutputLoanCardReport() Dim strUserName As String, strPath As String strUserName = Reports![Loan Card...

Thank you so much Isskint and Spikepl. Isskint, I did as you told me and the button wouldn't work anymore so I added rst.Bookmark = Me.Bookmark right after your rst.MoveFirst and it worked like a charm. Spikepl Thank you for the pointers. I usually do as you suggested and in this case...

Hi all, Access/VBA noob using Access 2003. My DB is for loaning equipment to users. Got pretty much everything working well but someone asked if this could be done: When the Find Next button reaches the last record matching criteria, have a MsgBox indicate so to the user ie: "Search...