Notification of blank entries on report when searched

[drblackard]

I designed a database that I am using for my DJ service. I have a query setup to check for available dates but I would like to get a little bit high tech with this if you will allow me to. I would like to have some type of popup box or command that will popup my calendar that I am using, when the available date is vacant. Right now I get a blank report if the date is available, which works fine for me but I would like to make it a little fancier, if you know what I mean. Professional if you will...Thanks in advance for your help.

 

[Remou]

Hi
Please include some of your existing code.

 

[drblackard]

Actually there is no code that I have designed..I am using Microsoft Access and just using the "What" feature in the query .... then made a report from the results of the "What" question asked in the query with the results of a report. I can send the code that access wrote for this if that would be of help. Thanks

 

[Remou]

Yes please.

 

[drblackard]

Here is the code that Access uses to check for the date...



Private Sub Command14_Click()
On Error GoTo Err_Command14_Click

Dim stDocName As String

stDocName = "tdate"
DoCmd.OpenReport stDocName, acPreview

Exit_Command14_Click:
Exit Sub

Err_Command14_Click:
MsgBox Err.Description
Resume Exit_Command14_Click

End Sub

 

[Remou]

You could try the NoData event of your report.

 

[drblackard]

Don't know anything about the nodata format or how to use it...just tried to read up on it from the Help files..confusion..can you please assist me. Thanks

 

[Remou]

I´m away at the moment, you can try these fora and also the vb help files. Look at the properties of your report in design view, you will find No Data listed on the events tab.