Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Custom Record Count…

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 […]

 1,920 total views,  1 views today

Sort using Labels…

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 […]

 1,817 total views

To Few Parameters Expected n…

…while using db.OpenRecordset with a Parameter…

Change this…

Set rst = db.OpenRecordset(“qryYourQuery”, dbOpenSnapshot)

To this, for TEXT… Set rst = db.OpenRecordset(“SELECT * FROM qryYourQuery WHERE tblYourTable.ytYourField= ‘” & [Forms]![frmYourForm]![txtYourTextBoxOnForm] & “‘”)

Or, if your field is NUMERIC…

Set rst = db.OpenRecordset(“SELECT * FROM qryYourQuery WHERE tblYourTable.ytYourField = ” & [Forms]![frmYourForm]![txtYourTextBoxOnForm])

Or, if your field is […]

 2,431 total views,  1 views today

Count how many times a value appears in a table…

Ever want to…

Track how many times the Item has been returned for repairs Make sure the Item on the Packing Slip has a valid Return Authorization Make that Spare Part hasn’t already been used for another repair

For those times I use…

Place the below code in a Module remembering not to name the […]

 1,179 total views

Confirm record count after Excel import…

When importing records from Excel here’s a way you can let the User know they all made it.

Step 1… In your Import code include the UpdateUser() line…

Function ImportMySpreadsheet() Dim lngColumn As Long Dim xlx As Object Dim xlw As Object, xls As Object, xlc As Object Dim dbs As DAO.Database Dim rst As […]

 1,554 total views,  1 views today