Search results

I am using the "On No Data" event in the report properties. Can you tell me what the code should be in order to generate the second report when there is no data in the first?

Here is what I entered and I get a runtime error saying "You cancelled the previous operation". the If statement line is highlighted in the debug window. Option Compare Database Option Explicit Private Sub Report_NoData(Cancel As Integer) If Nz(DCount("*", "q_Temperature_Monitoring Query 2")...

Okay I will try this but first a another question? In the If statement what does "Nz" refer to??? How does this generate the printed report? It seems that this would only open the report.

I have a report which I want to print when its preceeding report has no data. I used the following code but nothing happens. Can someone point this newbee in the right direction??? Option Compare Database Option Explicit Private Sub Report_NoData(Cancel As Integer) Dim Nodata1 As...

Thanks ... I will continue to work on this and be back if I have more questions. Appreciate the help

Makes sense ... I am a novice at this .... I placed a lable in the detail section but the only choices I have for Visible is yes or no. This is true for all the fields in the report. ?????

The reason to print this is to comply with State and Fedral Licensing requirements to show that there were no instances where the criteria was met. I agree it is rediculous!

That works ..... GREAT ... it ommits the report all together. What would be the language to print "No qualifing Data" in the body of the report itself?

Thanks for the quick reply ...... I am using 2003 which has the "On NO Data" event, but not well versed in VBA yet. I have also tried an IIf condition in the calculation with no change in the result.

I have a report that when there is no qualifing data prints with #ERROR in all the calculated fields. The calculated fields include counts, sums, and grand totals. (When thre is data the report works as expected.) How can I either have the calculations show 0's or have the report print with a...

Okay that makes sense now. I will no doubt be adding other tables down the road and will keep all of this in mind when I do. Thanks for your assistance ... and no doubt I will be back to the forum with more questions looking for help. Dan

Hi Bob, Let's see if I understand what you did. First, I understand the ALLOW EDITS mistake. Next the auto number ID field serves as the common field between the two tables so would that be the identifier to use in the seard of data from both tables? Could you use visitdate in the same...

Bob Thank you very much for the help and making revisions. I will go through it and I am sure I will be back to you with what will seamingly very fundamental questions. I am still learning. Dan

Okay ... must be having a senior moment ... here is the updated zip with more taken out. Originally tried to send it unzipped. Thanks

Did notice the message that the file is 2.72 which exceeds 2.0 Will strip some more out and try again!!

Bob Did you get the upload? In the forms tab you will see the form I am using .... labeled in the propety section Dan

Bob Okay I went through the upload ... it is called "copy of database". Thanks again.:) Dan

Okay .... give me a couple minutes to clear the data. Thanks Bob

I can delete the data as I am working in a copy of the original. My goal is to get the data entry to work. I think I remember how to upload here but alternately can I zip it and email it to you directly?

Bob, To answer your question about the 2 tables with 3 common fields ... A stupid oversite on my part but the second table was an add on later in the developement of the data base. I realize this would have been much simpler if I added it. Many queries and reports have been created since so it...