|
||||||
Access MVP (2010-2015) |
You don’t want your Users to open a Report that has nothing to show them, better to give them a message instead. On the Reports NoData event you can use… Private Sub Report_NoData(Cancel As Integer) On Error GoTo Report_NoData_Error MsgBox "No data to Display", vbOKOnly, "Report" Cancel = True Report_NoData_Exit: Exit Sub Report_NoData_Error: If Err.Number […] 2,035 total views, 3 views today Put the TEXT box on the Report and in the Control Source put… =[Name] OR to get the Report Name and the Date/Time =[Name] & " Printed on " & Now() OR to get the Report Name and the Date =[Name] & " Printed on " & Date() …now if you change the Name of […] 1,352 total views |
 |
||||
|
Copyright © 2024 Gina's Coffee Shop - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
