Show MsgBox when no data in Data Access Page?

  • Thread starter Thread starter Guest
  • Start date Start date
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!!!!
 
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."
-->
 
Back
Top