|
||||||
Access MVP (2010-2015) |
There are times you want to display a Record Count on your Form. Or, maybe, you want to use your own Navigation Buttons but how to get the Record Count to display? Here are two options… Click to see entire Form txtPage is the name of the unbound TEXT field between the […] On continuous forms Users always want to Sort and while they could do it from the Toolbar (Access 2003 or lower) or the Ribbon (access 2007 or higher), here’s another option… The two fields we’re going to use are Date Modified and Import Date. As you can see, I changed the LABEL back color to […] 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 […] 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 […] Here are a few tips when upsizing tables to an SQL Server that I have picked up along the way… Make a Back-Up of your Database… (added 7.26.2013) Need I say more? Just say *NO* to… …Special Characters or Symbols These characters have meaning when used in Access and on an SQL Server. While wrapping […] |
 |
||||
|
Copyright © 2026 Gina's Coffee Shop - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
