Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Queries really can’t do everything…

que-ry [kweer-ee] noun, plural que-ries verb, que-ried, que-rying

an inquiry a computer language used to make queries into databases and information systems A way to view a subset of information from one or more tables in a database Queries return records from one or more tables according to the parameters set in that query

However, […]

Loading

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

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