Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

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

Loading

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

Loading

Update database front ends…

Everyone who has split a database needs a way to update the Frontends. There are a few choices out there…

Tony’s Auto FE Updater BTAB Development Front-End Auto-Update Enabling Tool Automatically Deploy a New Access Client

…and here’s another one: In Backend (and this can be an SQL Server) create a table… tblVersionControlMaster vcmVersionControlID (PK, […]

Loading

My Database Standards…

There is a discussion, *Database Standards when using outside Contractors*, in a group that I have been watching and it got me to thinking… While I have a set of standards (and a Model Database), I have not written them down. So every time I need to ask a Subcontractor to do some work for […]

Loading