Show MsgBox when no data in Data Access Page?

G

Guest

How can I show a message box that tells the user when there is no data in the
recordset of a data access page? I know that you can create an expression on
a report for NoData, but I can't seen to figure it out for a DAP. Please
help me!!!!
 
K

Ken Snell \(MVP\)

You can use the DataPageComplete event of the MSODCS object to do this, I
believe.


<SCRIPT language=vbscript event=DataPageComplete(DSCEventInfo) for=MSODSC>
<!--
dim cto
cto=DSCEventInfo.DataPage.Recordset.RecordCount
If cto=0 Then msgbox "There are no records."
-->
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Access Page 1
Data Access Page Development Questions 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Locking File 3
nodata on reports 2
Data Access Page. Please Help... 3
Data Access Page | Why use this feature? 3
No data event in report 2

Top