by Jeff Shirley | Mar 30, 2018 | Blog
Moving between SQL and Access there are a few tricks you need to know. I thought it would be good to show some common areas which are stumbling blocks: Commands: Access vs SQL CInt and CString use Cast or Convert (depending on scenario) Nz([Field1,null) ...
by Jeff Shirley | Mar 14, 2018 | Blog
Short blog today, this is a great read on relationships in Access 2016: Access 2016 Relationships Thanks to Microsoft for this one!
by Jeff Shirley | Feb 20, 2018 | Blog
The worst query I ever had to write which powers a master report for the database user. Here it is. I don’t think I can make it smaller, there were too many weird rules, aggregates, and translations in it. And we needed to pull different columns based on...
by Jeff Shirley | Feb 4, 2018 | Blog
Another simple but powerful piece of code I get asked for a lot: Age calculations. it sounds so simple…but it isn’t! You can use variations of this for other purposes like aging receivables, calculating time lapse, etc. Requirement: a date field (in...
by Jeff Shirley | Jan 15, 2018 | Blog
Only because this was an issue for several people over the last year who called us…note the following: Older Access databases end in .mdb (Access 2003 or earlier) Newer Access databases end in .accdb (Access 2007 and later) If you compile a database (Click File,...
by Jeff Shirley | Dec 10, 2017 | Blog
In order to give a tab control different events for each tab being clicked, you can use a case statement. The case statement uses the case number to match to the Tab Page Index. Each tab has an identifier, starting at 0. This works well, as long as you don’t...
