Access Web and Desktop Advice | https://vb123.com/vba/ | 2015-08-17 |
Brilliant Video on Access 2010 MultiValued ComboBox | https://www.youtube.com/watch?v=queKMe9MiSs | 2016-01-26 |
Data Modeling 101 | http://www.agiledata.org/essays/dataModeling101.html | 2015-10-25 |
Database Development Examples | http://www.databasedevelopment.co.uk/examples.htm | 2015-11-03 |
Description of database normalization basics in Access 2000 | https://support.microsoft.com/en-gb/kb/209534 | 2015-11-03 |
FunctionX Tutorials | http://www.functionx.com/ | 2015-08-17 |
Generate Random Data Online | http://www.generatedata.com/#about | 2016-01-10 |
Helen Feddema | http://www.helenfeddema.com/ | 2015-11-03 |
How I Exported an Attachment fields data to a folder | http://www.access-programmers.co.uk/forums/showthread.php?t=228146 | 2016-02-14 |
How to Create a Stock Management Database | https://youtu.be/9HRmSRR29fY | 2015-11-04 |
How to return multiple values from a VBA function (Part 1) | http://www.geeksengine.com/article/vba-function-multiple-values.html | 2015-12-08 |
J Street Developer Downloads | http://www.jstreettech.com/downloads.aspx | 2015-11-03 |
Khan Academy - Learn SQL | https://www.khanacademy.org/computing/computer-programming/sql | 2015-08-17 |
Martin Green's Access Tips | http://www.fontstuff.com/access/index.htm | 2016-01-09 |
Microsoft Access Database Tutorial – Learn How To Use Microsoft Access | http://accessdatabasetutorial.com/ | 2015-11-03 |
Microsoft Access interview questions | http://www.careerride.com/microsoft-access-interview-questions.aspx | 2015-11-03 |
Microsoft Office/Access Basic Exam | https://en.wikibooks.org/wiki/Microsoft_Office/Access_Basic_Exam | 2015-11-03 |
MS Access Useful Code | https://sites.google.com/site/msaccesscode/system/app/pages/sitemap/hierarchy | 2015-11-03 |
Ranking-queries-ms-access-sql | https://bytes.com/topic/access/insights/954764-ranking-queries-ms-access-sql | 2015-11-10 |
Roger's Access Blog | http://rogersaccessblog.blogspot.co.uk/ | 2015-11-04 |
Smart Access Articles | https://msdn.microsoft.com/en-us/library/bb190857(v=office.11).aspx | 2015-11-17 |
SQL Server Central | http://www.sqlservercentral.com/ | 2015-11-03 |
Sub Queries | http://www.tutorialspoint.com/sql/sql-sub-queries.htm | 2016-01-05 |
Using class modules to create your own objects | http://www.di-mgt.com.au/classes.html | 2015-11-03 |
vb123.com KB | http://vb123.com.au/index.html?related_topics.htm | 2015-11-17 |
Webforms can use VBA forms? - Interesting!!! | https://social.msdn.microsoft.com/Forums/office/en-US/aded6487-1183-49aa-ab9d-5be62a05587b/access-2010-web-database-convert-a-webform-to-a-normal-form?forum=accessdev | 2016-01-30 |
Welcome To Roger's Access Library | http://www.rogersaccesslibrary.com/ | 2015-11-04 |
WWW SQL Designer | http://ondras.zarovi.cz/sql/demo/ | 2015-11-03 |
Microsoft Access Email FAQ - Tony Toews | http://www.granite.ab.ca/access/email.htm | 2015-10-03 |
Soft-coded event handlers ChrisO | http://www.access-programmers.co.uk/forums/showthread.php?t=166799 | 2015-11-03 |
Mastering the Combo Box NotInList Event | http://www.fontstuff.com/access/acctut20.htm | 2015-10-22 |
Bag Of Cows - Regular Expression Playground | http://bagofcows.com/regex/index.php | 2019-09-06 |
V-Tools | http://www.skrol29.com/us/vtools.php | 2019-09-22 |
Database Issue Checker Utility | http://allenbrowne.com/AppIssueChecker.html | 2019-09-22 |
Nice easy to understand SQL site | https://www.universalclass.com/articles/computers/sql/using-the-in-not-and-like-operators-in-sql.htm | 2019-09-27 |
Build an Unmatched Query with SQL | https://anthonysmoak.com/2017/10/18/return-unmatched-records-with-sql-and-microsoft-access/ | 2019-09-27 |
Unmatched SQL - Jon K - Can I use NOT EXISTS instead of NOT IN? | https://www.access-programmers.co.uk/forums/showpost.php?p=308061&postcount=10 | 2019-09-27 |
Finding All Records in One Table but Not Another (FMS) | https://www.fmsinc.com/MicrosoftAccess/query/outer-join/index.html | 2019-09-27 |
Tutorials for Microsoft® Access | https://www.everythingaccess.com/tutorials.asp | 2019-10-20 |
Darragh Murray Percentage Field Formatting | http://www.darraghmurray.com/ms-access-tips/ms-access-percentage-field-formatting/ | 2019-11-01 |
Balance Brackets | http://www.balancebraces.com/ | 2019-11-07 |
Create Table DAO | https://www.everythingaccess.com/tutorials.asp?ID=DAO-programming-examples#CreateTableDAO | 2019-11-21 |
Good Example of a SubQuery | https://www.everythingaccess.com/tutorials.asp?ID=What%27s-a-subquery%3F | 2019-11-21 |
Surviving subqueries | https://www.everythingaccess.com/tutorials.asp?ID=Surviving-Subqueries | 2019-11-21 |
Article from Philipp Stiefel - Date Format | https://codekabinett.com/rdumps.php?Lang=2&targetDoc=format-date-language-country-vba-access | 2019-11-22 |
Move Items From One Listbox to Another Listbox by MajP | https://www.tek-tips.com/faqs.cfm?fid=6326 | 2019-11-23 |
Tree View Control - VBA | https://www.jkp-ads.com/articles/treeview.asp | 2019-11-24 |
Format SQL with "Poor SQL" | https://poorsql.com/ | 2020-01-14 |
SQL Validator Checker | https://www.eversql.com/sql-syntax-check-validator/ | 2020-01-29 |
The MsgBox function takes five arguments | http://www.functionx.com/vbaccess2010/topics/msgbox.htm | 2020-02-16 |
Table to Exclude Data From a Query | https://btabdevelopment.com/how-to-use-a-table-to-exclude-data-from-a-query/ | 2010-07-11 |
Hilite - converts your code - USE:- Lang VB.Net - Style vs | http://hilite.me/ | 2020-03-28 |
Database Answers - Data Models in 50 categories | http://www.databaseanswers.org/data_models/index.htm | 2020-05-10 |
Tab Control Password | https://www.access-programmers.co.uk/forums/threads/tab-control-password.83036/ | 2005-05-11 |
Audit Trail | https://www.access-programmers.co.uk/forums/threads/audit-trail.44231/ | 2003-03-18 |
Microsoft Access and Google Calendar | http://www.utteraccess.com/forum/index.php?showtopic=2041518 | 2017-01-12 |
Dev Hut | https://www.devhut.net/ | 2017-12-02 |
Iterating over MS Access Dictionary | https://www.access-programmers.co.uk/forums/threads/vba-iterating-over-ms-access-dictionary.291089/ | 2016-12-20 |
Running Sum In Query.mdb (beginner) | http://www.rogersaccesslibrary.com/forum/runningsuminquerymdb-beginner_topic279.html?SID=1ad20d6294bfb7bf5d764e964fca75638888889 | 2017-01-10 |
Combobox - Why Doesn't the Dropdown sustain? | https://www.access-programmers.co.uk/forums/threads/why-doesnt-the-dropdown-sustain.285870/ | 2016-04-08 |
Manipulating XL via VBA | http://www.access-programmers.co.uk/forums/showthread.php?t=127596 | 2015-11-03 |
Switchboard | http://www.access-programmers.co.uk/forums/showthread.php?t=88012 | 2015-11-03 |
Helen Feddema (NEW) | https://office-watch.com/category/microsoft-access/ | 2019-07-19 |
List details horizontally | http://www.access-programmers.co.uk/forums/showpost.php?p=308045&postcount=2 | 2015-11-03 |
Gina Whipp - Conditional Row Shading on a Continuous Form | http://regina-whipp.com/blog/?p=925 | 2015-11-03 |
Allen Browne - Inventory Control: Quantity on Hand | http://allenbrowne.com/appinventory.html | 2012-07-06 |
My MS Access Blog (Not Mine) | http://mymsaccessblog.blogspot.co.uk/ | 2012-07-06 |
Excel In Access | https://access-programmers.co.uk/forums/showthread.php?p=671226 | 2019-05-10 |
Learn Structured Query Language online | http://webcheatsheet.com/sql/interactive_sql_tutorial/ | 2012-07-06 |
Grumpy Old DBA | http://www.grumpyolddba.co.uk/default.htm | 2015-11-03 |
How Many Legs? An Exercise in Classes and Objects | http://mymsaccessblog.blogspot.com/2008/10/how-many-legs-exercise-in-classes-and.html | 2008-10-11 |
Professor David West - OOP is Dead! Long Live OODD! | https://vimeo.com/77415896 | 2014-11-03 |
Access OOP examples wanted | https://www.access-programmers.co.uk/forums/threads/access-oop-examples-wanted.270135/ | 2014-10-10 |
Microsoft Access interview questions | https://www.careerride.com/microsoft-access-interview-questions.aspx | 2012-07-06 |
Extract field names from a table/query ADO/DAO | https://www.access-programmers.co.uk/forums/threads/extract-field-names-from-a-table-query-ado-dao.106892/ | 2006-05-05 |
How to Connect to Your MySQL Database Remotely Using ODBC | https://www.webhostinghero.com/connect-to-mysql-remotely-using-odbc/ | 2018-02-16 |
Using Microsoft Access as a Front-end to MySQL | https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html | 2018-02-16 |
dbSeeChanges option with OpenRecordSet when accessing a SQL Server | https://weblogs.asp.net/gunnarpeipman/you-must-use-the-dbseechanges-option-with-openrecordset-when-accessing-a-sql-server-table-that-has-an-identity-column | 2012-07-18 |
Are linked tables the best way to use SQL Server? | https://accessexperts.com/blog/2012/10/02/are-linked-tables-the-best-way-to-use-sql-server-yes-no-maybe/ | 2016-04-03 |
@@Identity Private GDoc | https://docs.google.com/document/d/1H8NKEN5rhcfmLIL150Vd4MYDt4OWGc347hmC4xtSiRw/edit# | 2011-03-31 |
Report - Dynamic Filtering | https://www.access-programmers.co.uk/forums/threads/filter-multiple-fields-in-a-report-with-a-form-and-allow-blank-fields-to-be-returned.207573/ | 2011-03-31 |
Avoid when using VBA Recordset | https://www.techrepublic.com/blog/10-things/10-plus-mistakes-to-avoid-when-using-vba-recordset-objects/ | 2017-07-09 |
BatchCollisionCount - Recordset.Update method (DAO) | https://docs.microsoft.com/en-gb/office/client-developer/access/desktop-database-reference/recordset-update-method-dao | 2017-07-09 |
Generate Word Doc from MS Access | https://docs.microsoft.com/en-us/office/vba/api/access.webbrowsercontrol.object | 2020-05-11 |
Export Tbl-Qry To Excl Worksheet / Workbook | https://btabdevelopment.com/export-a-table-or-query-to-excel-specific-worksheet-on-specific-workbook/ | 2020-05-20 |
Data Gnostics - Microsoft Access Tips and Tricks | http://www.datagnostics.com/tips.html | 2020-07-18 |
Vlad Cucinschi - MS Access Developer | http://forestbyte.com/access-links/ | 2020-07-23 |
Vlad Cucinschi - Pivot Table Designer | http://forestbyte.com/ms-access-utilities/fba-pivot-table-designer/ | 2020-07-23 |
Access VBA to Create Pivot Table Reports | https://youtu.be/rsRQqwYKQDc | 2020-07-27 |
Backup Recommended by Richard (Doc) | https://stackoverflow.com/questions/45718163/can-an-ms-access-database-create-a-backup-of-itself-while-its-open-using-vba | 2020-07-31 |
Permissions based on Users Level - Gina Whipp | https://www.access-diva.com/f10.html | 2020-08-05 |
PDF on MS Access Techniques By Susan J. Dorey | http://www.susandoreydesigns.com/software/AccessVBATechniques.pdf | 2020-08-08 |
MORE from Susan J. Dorey here:- | http://www.susandoreydesigns.com/software/ | 2020-08-08 |
Stock/Inventory Video - with Free Download | https://youtu.be/9HRmSRR29fY | 2020-10-12 |
Pat - Exporting to Excel | https://www.access-programmers.co.uk/forums/threads/exporting-access-data-into-excel-spreadsheet.314326/#post-1725819 | 2020-10-18 |
Pat - Do Validation in forms before update Event | https://www.access-programmers.co.uk/forums/threads/trouble-adding-code-on-date-fields.314320/#post-1725820 | 2020-10-18 |
Prevent Circular References | https://www.codeproject.com/articles/38655/prevent-circular-references-in-database-design | 2020-10-24 |
Excelling Automatically - Doug Steele | https://www.vb123.com.au/200507_ds_excel.htm | 2020-12-01 |
USA Data sets - (See Terms & conditions to use in UK) | https://gsociology.icaap.org/dataupload.html | 2020-12-05 |
Creation of Ribbons in Access 2007/2010 | https://www.accessribbon.de/en/ | 2020-12-06 |
MontaRibbons v.7.0 Wizard create ribbons in Access | http://www.ribbons-access.com/ | 2020-12-06 |
Writing readable code: Try* pattern - Error Code for Objects | https://accessexperts.com/blog/2020/10/30/writing-readable-code-try-pattern/ | 2021-02-04 |
Dynamic Report based on a Crosstab query | https://hitechcoach.com/microsoft-office/access/access-downloads/access-examples/example-reports/dynamic-report-based-on-a-crosstab-query | 2021-04-01 |
MS Access Templates from Microsoft | https://support.microsoft.com/en-us/office/featured-access-templates-e14f25e4-78b6-41de-8278-1afcfc91a9cb | 2021-04-06 |
All About Aggregate Queries Using Access 2016 | https://www.universalclass.com/articles/computers/all-about-aggregate-queries-using-access-2016.htm | 2021-04-16 |
Understanding Advanced MySQL Concepts | https://www.universalclass.com/articles/computers/understanding-advanced-mysql-concepts.htm | 2021-04-16 |
Tips for Newbies by HillTJ on AWF | https://www.access-programmers.co.uk/forums/threads/tips-for-newbies.312437/ | 2021-04-18 |
Dynalist - Minimal Mindmap | https://dynalist.io/ | 2021-04-20 |
Randomizing Data Random by Micron | https://www.access-programmers.co.uk/forums/threads/randomizing-data-for-posted-dbs.306745/ | 2021-04-22 |
Allen Brownes "Search Form" | http://allenbrowne.com/ser-62.html | 2021-04-28 |
Access and SQL Tips -Dynamic Reports Re:- JDraw | https://www.slideshare.net/quest2900/access-tips-access-and-sql-part-6-dynamic-reports | 2021-04-29 |
Parts of a Form (images) exploded | http://www.functionx.com/access2010/Lesson10.htm | 2021-05-03 |
Module:- bas_BanishIndexes -Author:- Jim Doherty http://www.Bytes.com | https://bytes.com/topic/access/answers/890981-change-indexed-field-no | 2021-05-05 |
Taking a scenic drive through Access 3 PowerPoints | https://support.microsoft.com/en-us/office/taking-a-scenic-drive-through-access-cc28486e-1101-462e-ac1b-0b02ed88024c | 2021-05-08 |
Examples of using dates as criteria in Access queries | https://support.microsoft.com/en-us/office/examples-of-using-dates-as-criteria-in-access-queries-aea83b3b-46eb-43dd-8689-5fc961f21762 | 2021-06-02 |
How to use Criteria in MS Access - 4 Videos | https://support.microsoft.com/en-us/office/video-use-query-criteria-in-access-2013-4b102653-7b6f-4358-9751-1ab51fe89469 | 2021-06-03 |
Send eMail to Multiple Recipients - Gina Whipp | https://www.access-diva.com/vba16.html | 2015-09-02 |
Automatic Error Handling in Access | https://bytes.com/topic/access/insights/667905-automatic-error-handling-access | 2021-06-11 |
Add "(All)" to a combo box or list box | https://docs.microsoft.com/en-us/office/vba/access/concepts/controls/addallto-a-combo-box-or-list-box | 2021-08-29 |
Crystal - Expert Tutoring and Training | http://msaccessgurus.com/training.htm | 2021-09-17 |
Free Access TOOLS and Books - Crystal Long | http://msaccessgurus.com/tools.htm | 2021-09-17 |
Extracting data from a closed Excel Spreadsheet ADO | https://www.access-programmers.co.uk/forums/threads/extracting-data-from-a-closed-excel-spreadsheet.320109/ | 2021-10-26 |
Wiring up your common click procedure | https://www.access-programmers.co.uk/forums/threads/loop-all-controls.309782/ | 2021-10-26 |
Search As you Type for Microsoft Access Combobox | https://www.experts-exchange.com/articles/35613/Search-As-you-Type-for-Microsoft-Access-Combobox.html | 2021-11-03 |
A comment "Uncle Gizmo" made to a difficult AWF Newby | https://www.access-programmers.co.uk/forums/threads/query-editor.85840/page-3 | 2021-11-16 |
Navigation Form with Ease - by ArnelGP | https://www.access-programmers.co.uk/forums/threads/navigation-form-with-ease.280311/ | 2021-11-24 |
Remote Subforms - Galaxiom - Master/Child - will work across | https://www.access-programmers.co.uk/forums/threads/linking-forms.320562/#post-1797209 | 2021-11-25 |
Automatic Form Resizing by "isladogs" (Colin) | http://www.mendipdatasystems.co.uk/automatic-form-resizing-1/4594554784 | 2021-11-25 |
Create/Populate module from VBA - Doc Man | https://www.access-programmers.co.uk/forums/threads/create-populate-module-from-vba.175967/ | 2021-11-28 |
Windows API Decs - Updated for the 64-bit | https://www.microsoft.com/en-us/download/details.aspx?id=9970 | 2021-11-30 |
MS Access Report – dynamically collapse groups | http://jkafer.com/2014/ms-access-report-dynamically-collapse-groups/ | 2021-12-10 |
Good Thread on Null & vbNullString & vbNull & More! | https://www.access-programmers.co.uk/forums/threads/vbnull-and-vbnullstring.272779/ | 2021-12-17 |
vbWatchdog - Professional error handling for VBA | https://www.everythingaccess.com/vbwatchdog.asp | 2021-12-17 |
vbWatchdog Error handler for VBA from EverythingAccess.com, by Peter Cole - Access Lunchtime | https://youtu.be/-zEoYCdMJS4 | 2021-12-17 |
Implement User Preferences in MS Access - By Danny Lesandrini | https://www.databasejournal.com/features/msaccess/article.php/3605656/Implement-User-Preferences-in-MS-Access.htm | 2021-12-18 |
Message Box MsgBox - Bitmask - Re:- MajP - AWF | http://access.mvps.org/access/general/gen0038.htm | 2021-12-20 |
Creating Pseudo Custom Controls with Class Modules - MajP | https://www.access-programmers.co.uk/forums/threads/creating-pseudo-custom-controls-with-class-modules.321016/#post-1802116 | 2021-12-23 |
Numbered Query - Roger's Access Library | http://www.rogersaccesslibrary.com/forum/topic309.html | 2021-12-23 |
Continuous Form Like a Datasheet - CJ Loncon | https://www.access-programmers.co.uk/forums/threads/continuous-form-that-allows-users-to-resize-and-reorder-columns-like-a-datasheet.320624/ | 2021-12-25 |
Many To Many Blog | https://vertabelo.com/blog/many-to-many-relationship/ | 2022-01-09 |
Difference between "&" and "+" used to concatenate - Pat Harman | https://www.access-programmers.co.uk/forums/threads/iterating-through-dates-in-a-for-loop.321183/post-1804300 | 2022-01-09 |
Add a value to a bound combo box | https://docs.microsoft.com/en-us/office/vba/access/concepts/forms/add-a-value-to-a-bound-combo-box | 2022-01-22 |
Restore Database Objects (LoadFromText) | https://www.access-programmers.co.uk/forums/threads/restore-database-objects-loadfromtext.296459/ | 2022-01-25 |
SQL to VBA & Back Again - Colin - Mendip Systems - isladogs | https://www.isladogs.co.uk/sql-to-vba-back-again/index.html | 2022-02-13 |
How And Why To Decompile An Access Database | https://www.barnesbusinesssolutions.com/WhitePaperOnHowAndWhyToDecompileAnAccessDatabase.pdf | 2022-04-04 |
Evaluate - an expression (Text) *** Eval *** | https://support.microsoft.com/en-us/office/eval-function-8c4a1b10-85ba-40db-b0c8-5290da4d4166 | 2022-10-05 |
Improve dB Speed - CJ London | https://www.access-programmers.co.uk/forums/threads/addressing-performance-issues.291269/ | 2022-10-06 |
C Pearson - Excel VBA code - Could be adapted to MS Access | http://www.cpearson.com/Downloads/Downloads.aspx | 2022-10-24 |
Forensics, password recovery and decryption tools by Thegrideon Software. | https://www.thegrideon.com/ | 2023-06-02 |