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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: XsivelyLost
- Order by date
-
Getting Errors With Report after Filtering
As my son says, "You da Man!!!!" This works Perfectly!!! I can't thank you enough. I'm sure as this "XsivelyLost" little mouse runs his little maze you will hear from me again. I don't know if there is a feedback page on this sight but if I find it you'll get my best...- XsivelyLost
- Post #7
- Forum: Microsoft: Access Reports
-
Getting Errors With Report after Filtering
Oh, Gord. It appears that everything has a resident 'BUT' statement. Ok, the previous error is gone, BUT, I am getting a new one saying that there is a "Data type mismatch in the criteria expression". (I hate a button that forces you to say "OK" especially when I am...- XsivelyLost
- Post #5
- Forum: Microsoft: Access Reports
-
Getting Errors With Report after Filtering
Thank you for such a quick response. I made the changes as prescribed, checking everything twice and ran into another problem. I received the error message that the EmpNumber could relate to two different tables in the FROM statement of my SQL Statement. Well, yes this is true. It could. The...- XsivelyLost
- Post #3
- Forum: Microsoft: Access Reports
-
Getting Errors With Report after Filtering
I searched the forum and found several ideas to even get to where I am now. BUT!, I entered the following code to filter my report: Private Sub PrintRptBttn_Click() On Error GoTo Err_PrintRptBttn_Click Dim stDocName As String Dim strFilter As String stDocName =...- XsivelyLost
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
