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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by VanIsleMan
-
Close report. Easy??
Okay, I think this is working now. What I've done is this... In the code behind the button that triggers the report, I've added error handling code to trap error 2501. Private Sub cmdGrowthChart2to20_Click() On Error GoTo errHandler DoCmd.RunCommand acCmdSaveRecord If...- VanIsleMan
- Post #8
- Forum: Microsoft: Access Reports
-
Close report. Easy??
Nice try, AtlasAF. But the code still trips up on DoCmd.Close. I'm afraid I don't understand what "processing" the error message is referring to. Could it be because the DoCmd.Close is enclosed in an If statement and control has not yet been passed to End If?- VanIsleMan
- Post #6
- Forum: Microsoft: Access Reports
-
Close report. Easy??
How would I use the NoData event when the recordset is generated in code, rather than by a report query? Thnx Lex IE: Dim db As Database Set db = CurrentDb() Dim StrSQL As String StrSQL = ("SELECT TOP 9 tblPatients.PatientID, tblPatients.PatientFirstName, tblPatients.PatientLastName...- VanIsleMan
- Post #3
- Forum: Microsoft: Access Reports
-
Close report. Easy??
Well, you'd think this would be easy, but I'm having great difficulty with it. All I want to do is close a report if the recordset is empty. The recordset is built in the report using code. If there are no records in the recordset, control is passed to a MsgBox, like so... If intPtVisits = 0...- VanIsleMan
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
-
Font size in reports changes on its own, at times
BroomerEd, Did you ever solve this problem? I am experiencing exactly the same problem.- VanIsleMan
- Post #8
- Forum: Microsoft: Access Reports
