Optimizing queries: Fixed a query that was almost literally taking forever to run. It had run before, but I changed some ODBC links and it 'seemed' to have broken. Turns out it was using different ODBC connections for different tables, taking an exponentially long time to compare the 250,000 records or so.... Moral of this story, when in doubt, relink the tables!
IIF. Not, iff, if... argh.
Full Outer Joined queries - Access doesn't do this. =). Search Google groups for "Full Outer Join Access"...
Trying to display the total from a subform on the main form? Try something like this in the footer of the subform :totalbox =Sum([Value]) then a txtbox equal to this field in the main form.
Access's ODBC driver isn't perfect. I recently had a Crystal Report fail when reading a very complex query via ODBC, but it worked perfectly when switching to DAO access. YMMV.
Access can select records perfectly fine using standard SQL's "%" as a wildcard BUT for Update queries, I have needed to use "*" [access's wildcard]. Argh.
Make an internal connection to the database with ADO (i.e. the comparable command to set db=currentdb in DAO)
Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
Running a query in Access is NOT the same as being able to call the query via ODBC! See this post for a good description of why this is so (VBA functions don't work)
A set of links: http://www.developershandbook.com/downloads.htm
Access Label Wizard choices differ between English and Metric - there are different standard labels listed! (I.e. it doesn't just change the units in the size)
More label weirdness - if you create a label and it prompts that it is too wide for the data, try changing the print order from left-right to top-down. Same labels, different print order, but for some reason, it just works. YMMV
Access DDL (i.e. "CREATE TABLE") syntax with real practical examples - http://allenbrowne.com/func-DDL.html
Email Address - split out domain - Domain: Right([Email], Len([Email]) - InStr([Email], "@")) - from https://www.fontstuff.com/mailbag/qaccess05.htm