MS Access Links

MS Access Links

I gather links from all over the internet related to MS Access, and of course other things of interest to me in creating novel MS Access Solutions. I was finding it difficult to maintain lists of links on the Nifty Access Website, that is, until I found this WordPress plug-in:- “Inline Google Spreadsheet Viewer” By Meitar Moscovitz… Now it’s a Doddle!!! I can easily add any links into a Google spreadsheet and they automatically appear in the List. No website editing, just a simple process of adding something to a spreadsheet.

Useful Access URL's

Name
URL
Access Web and Desktop Advicehttps://vb123.com/vba/2015-08-17
Brilliant Video on Access 2010 MultiValued ComboBoxhttps://www.youtube.com/watch?v=queKMe9MiSs2016-01-26
Data Modeling 101http://www.agiledata.org/essays/dataModeling101.html2015-10-25
Database Development Exampleshttp://www.databasedevelopment.co.uk/examples.htm2015-11-03
Description of database normalization basics in Access 2000https://support.microsoft.com/en-gb/kb/2095342015-11-03
FunctionX Tutorialshttp://www.functionx.com/2015-08-17
Generate Random Data Onlinehttp://www.generatedata.com/#about2016-01-10
Helen Feddemahttp://www.helenfeddema.com/2015-11-03
How I Exported an Attachment fields data to a folderhttp://www.access-programmers.co.uk/forums/showthread.php?t=2281462016-02-14
How to Create a Stock Management Databasehttps://youtu.be/9HRmSRR29fY2015-11-04
How to return multiple values from a VBA function (Part 1)http://www.geeksengine.com/article/vba-function-multiple-values.html2015-12-08
J Street Developer Downloadshttp://www.jstreettech.com/downloads.aspx2015-11-03
Khan Academy - Learn SQLhttps://www.khanacademy.org/computing/computer-programming/sql2015-08-17
Martin Green's Access Tipshttp://www.fontstuff.com/access/index.htm2016-01-09
Microsoft Access Database Tutorial – Learn How To Use Microsoft Accesshttp://accessdatabasetutorial.com/2015-11-03
Microsoft Access interview questionshttp://www.careerride.com/microsoft-access-interview-questions.aspx2015-11-03
Microsoft Office/Access Basic Examhttps://en.wikibooks.org/wiki/Microsoft_Office/Access_Basic_Exam2015-11-03
MS Access Useful Codehttps://sites.google.com/site/msaccesscode/system/app/pages/sitemap/hierarchy2015-11-03
Ranking-queries-ms-access-sqlhttps://bytes.com/topic/access/insights/954764-ranking-queries-ms-access-sql2015-11-10
Roger's Access Bloghttp://rogersaccessblog.blogspot.co.uk/2015-11-04
Smart Access Articleshttps://msdn.microsoft.com/en-us/library/bb190857(v=office.11).aspx2015-11-17
SQL Server Centralhttp://www.sqlservercentral.com/2015-11-03
Sub Querieshttp://www.tutorialspoint.com/sql/sql-sub-queries.htm2016-01-05
Using class modules to create your own objectshttp://www.di-mgt.com.au/classes.html2015-11-03
vb123.com KBhttp://vb123.com.au/index.html?related_topics.htm2015-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=accessdev2016-01-30
Welcome To Roger's Access Libraryhttp://www.rogersaccesslibrary.com/2015-11-04
WWW SQL Designerhttp://ondras.zarovi.cz/sql/demo/2015-11-03
Microsoft Access Email FAQ - Tony Toewshttp://www.granite.ab.ca/access/email.htm2015-10-03
Soft-coded event handlers ChrisOhttp://www.access-programmers.co.uk/forums/showthread.php?t=1667992015-11-03
Mastering the Combo Box NotInList Eventhttp://www.fontstuff.com/access/acctut20.htm2015-10-22
Bag Of Cows - Regular Expression Playgroundhttp://bagofcows.com/regex/index.php2019-09-06
V-Toolshttp://www.skrol29.com/us/vtools.php2019-09-22
Database Issue Checker Utilityhttp://allenbrowne.com/AppIssueChecker.html2019-09-22
Nice easy to understand SQL sitehttps://www.universalclass.com/articles/computers/sql/using-the-in-not-and-like-operators-in-sql.htm2019-09-27
Build an Unmatched Query with SQLhttps://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=102019-09-27
Finding All Records in One Table but Not Another (FMS)https://www.fmsinc.com/MicrosoftAccess/query/outer-join/index.html2019-09-27
Tutorials for Microsoft® Accesshttps://www.everythingaccess.com/tutorials.asp2019-10-20
Darragh Murray Percentage Field Formattinghttp://www.darraghmurray.com/ms-access-tips/ms-access-percentage-field-formatting/2019-11-01
Balance Bracketshttp://www.balancebraces.com/2019-11-07
Create Table DAOhttps://www.everythingaccess.com/tutorials.asp?ID=DAO-programming-examples#CreateTableDAO2019-11-21
Good Example of a SubQueryhttps://www.everythingaccess.com/tutorials.asp?ID=What%27s-a-subquery%3F2019-11-21
Surviving subquerieshttps://www.everythingaccess.com/tutorials.asp?ID=Surviving-Subqueries2019-11-21
Article from Philipp Stiefel - Date Formathttps://codekabinett.com/rdumps.php?Lang=2&targetDoc=format-date-language-country-vba-access2019-11-22
Move Items From One Listbox to Another Listbox by MajPhttps://www.tek-tips.com/faqs.cfm?fid=63262019-11-23
Tree View Control - VBAhttps://www.jkp-ads.com/articles/treeview.asp2019-11-24
Format SQL with "Poor SQL"https://poorsql.com/2020-01-14
SQL Validator Checkerhttps://www.eversql.com/sql-syntax-check-validator/2020-01-29
The MsgBox function takes five argumentshttp://www.functionx.com/vbaccess2010/topics/msgbox.htm2020-02-16
Table to Exclude Data From a Queryhttps://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 vshttp://hilite.me/2020-03-28
Database Answers - Data Models in 50 categorieshttp://www.databaseanswers.org/data_models/index.htm2020-05-10
Tab Control Password https://www.access-programmers.co.uk/forums/threads/tab-control-password.83036/2005-05-11
Audit Trailhttps://www.access-programmers.co.uk/forums/threads/audit-trail.44231/2003-03-18
Microsoft Access and Google Calendarhttp://www.utteraccess.com/forum/index.php?showtopic=20415182017-01-12
Dev Huthttps://www.devhut.net/2017-12-02
Iterating over MS Access Dictionaryhttps://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=1ad20d6294bfb7bf5d764e964fca756388888892017-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 VBAhttp://www.access-programmers.co.uk/forums/showthread.php?t=1275962015-11-03
Switchboardhttp://www.access-programmers.co.uk/forums/showthread.php?t=880122015-11-03
Helen Feddema (NEW)https://office-watch.com/category/microsoft-access/2019-07-19
List details horizontallyhttp://www.access-programmers.co.uk/forums/showpost.php?p=308045&postcount=22015-11-03
Gina Whipp - Conditional Row Shading on a Continuous Formhttp://regina-whipp.com/blog/?p=9252015-11-03
Allen Browne - Inventory Control: Quantity on Handhttp://allenbrowne.com/appinventory.html2012-07-06
My MS Access Blog (Not Mine)http://mymsaccessblog.blogspot.co.uk/2012-07-06
Excel In Accesshttps://access-programmers.co.uk/forums/showthread.php?p=6712262019-05-10
Learn Structured Query Language onlinehttp://webcheatsheet.com/sql/interactive_sql_tutorial/2012-07-06
Grumpy Old DBAhttp://www.grumpyolddba.co.uk/default.htm2015-11-03
How Many Legs? An Exercise in Classes and Objectshttp://mymsaccessblog.blogspot.com/2008/10/how-many-legs-exercise-in-classes-and.html2008-10-11
Professor David West - OOP is Dead! Long Live OODD!https://vimeo.com/774158962014-11-03
Access OOP examples wantedhttps://www.access-programmers.co.uk/forums/threads/access-oop-examples-wanted.270135/2014-10-10
Microsoft Access interview questionshttps://www.careerride.com/microsoft-access-interview-questions.aspx2012-07-06
Extract field names from a table/query ADO/DAOhttps://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 ODBChttps://www.webhostinghero.com/connect-to-mysql-remotely-using-odbc/2018-02-16
Using Microsoft Access as a Front-end to MySQLhttps://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html2018-02-16
dbSeeChanges option with OpenRecordSet when accessing a SQL Serverhttps://weblogs.asp.net/gunnarpeipman/you-must-use-the-dbseechanges-option-with-openrecordset-when-accessing-a-sql-server-table-that-has-an-identity-column2012-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 GDochttps://docs.google.com/document/d/1H8NKEN5rhcfmLIL150Vd4MYDt4OWGc347hmC4xtSiRw/edit#2011-03-31
Report - Dynamic Filteringhttps://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 Recordsethttps://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-dao2017-07-09
Generate Word Doc from MS Accesshttps://docs.microsoft.com/en-us/office/vba/api/access.webbrowsercontrol.object2020-05-11
Export Tbl-Qry To Excl Worksheet / Workbookhttps://btabdevelopment.com/export-a-table-or-query-to-excel-specific-worksheet-on-specific-workbook/2020-05-20
Data Gnostics - Microsoft Access Tips and Trickshttp://www.datagnostics.com/tips.html2020-07-18
Vlad Cucinschi - MS Access Developerhttp://forestbyte.com/access-links/2020-07-23
Vlad Cucinschi - Pivot Table Designerhttp://forestbyte.com/ms-access-utilities/fba-pivot-table-designer/2020-07-23
Access VBA to Create Pivot Table Reportshttps://youtu.be/rsRQqwYKQDc2020-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-vba2020-07-31
Permissions based on Users Level - Gina Whipphttps://www.access-diva.com/f10.html2020-08-05
PDF on MS Access Techniques By Susan J. Doreyhttp://www.susandoreydesigns.com/software/AccessVBATechniques.pdf2020-08-08
MORE from Susan J. Dorey here:-http://www.susandoreydesigns.com/software/2020-08-08
Stock/Inventory Video - with Free Downloadhttps://youtu.be/9HRmSRR29fY2020-10-12
Pat - Exporting to Excelhttps://www.access-programmers.co.uk/forums/threads/exporting-access-data-into-excel-spreadsheet.314326/#post-17258192020-10-18
Pat - Do Validation in forms before update Eventhttps://www.access-programmers.co.uk/forums/threads/trouble-adding-code-on-date-fields.314320/#post-17258202020-10-18
Prevent Circular Referenceshttps://www.codeproject.com/articles/38655/prevent-circular-references-in-database-design2020-10-24
Excelling Automatically - Doug Steele https://www.vb123.com.au/200507_ds_excel.htm2020-12-01
USA Data sets - (See Terms & conditions to use in UK)https://gsociology.icaap.org/dataupload.html2020-12-05
Creation of Ribbons in Access 2007/2010https://www.accessribbon.de/en/2020-12-06
MontaRibbons v.7.0 Wizard create ribbons in Accesshttp://www.ribbons-access.com/2020-12-06
Writing readable code: Try* pattern - Error Code for Objectshttps://accessexperts.com/blog/2020/10/30/writing-readable-code-try-pattern/2021-02-04
Dynamic Report based on a Crosstab queryhttps://hitechcoach.com/microsoft-office/access/access-downloads/access-examples/example-reports/dynamic-report-based-on-a-crosstab-query2021-04-01
MS Access Templates from Microsofthttps://support.microsoft.com/en-us/office/featured-access-templates-e14f25e4-78b6-41de-8278-1afcfc91a9cb2021-04-06
All About Aggregate Queries Using Access 2016https://www.universalclass.com/articles/computers/all-about-aggregate-queries-using-access-2016.htm2021-04-16
Understanding Advanced MySQL Conceptshttps://www.universalclass.com/articles/computers/understanding-advanced-mysql-concepts.htm2021-04-16
Tips for Newbies by HillTJ on AWFhttps://www.access-programmers.co.uk/forums/threads/tips-for-newbies.312437/2021-04-18
Dynalist - Minimal Mindmaphttps://dynalist.io/2021-04-20
Randomizing Data Random by Micronhttps://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.html2021-04-28
Access and SQL Tips -Dynamic Reports Re:- JDrawhttps://www.slideshare.net/quest2900/access-tips-access-and-sql-part-6-dynamic-reports2021-04-29
Parts of a Form (images) exploded http://www.functionx.com/access2010/Lesson10.htm2021-05-03
Module:- bas_BanishIndexes -Author:- Jim Doherty http://www.Bytes.comhttps://bytes.com/topic/access/answers/890981-change-indexed-field-no2021-05-05
Taking a scenic drive through Access 3 PowerPointshttps://support.microsoft.com/en-us/office/taking-a-scenic-drive-through-access-cc28486e-1101-462e-ac1b-0b02ed88024c2021-05-08
Examples of using dates as criteria in Access querieshttps://support.microsoft.com/en-us/office/examples-of-using-dates-as-criteria-in-access-queries-aea83b3b-46eb-43dd-8689-5fc961f217622021-06-02
How to use Criteria in MS Access - 4 Videoshttps://support.microsoft.com/en-us/office/video-use-query-criteria-in-access-2013-4b102653-7b6f-4358-9751-1ab51fe894692021-06-03
Send eMail to Multiple Recipients - Gina Whipphttps://www.access-diva.com/vba16.html2015-09-02
Automatic Error Handling in Accesshttps://bytes.com/topic/access/insights/667905-automatic-error-handling-access2021-06-11
Add "(All)" to a combo box or list boxhttps://docs.microsoft.com/en-us/office/vba/access/concepts/controls/addallto-a-combo-box-or-list-box2021-08-29
Crystal - Expert Tutoring and Traininghttp://msaccessgurus.com/training.htm2021-09-17
Free Access TOOLS and Books - Crystal Longhttp://msaccessgurus.com/tools.htm2021-09-17
Extracting data from a closed Excel Spreadsheet ADOhttps://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 Comboboxhttps://www.experts-exchange.com/articles/35613/Search-As-you-Type-for-Microsoft-Access-Combobox.html2021-11-03
A comment "Uncle Gizmo" made to a difficult AWF Newbyhttps://www.access-programmers.co.uk/forums/threads/query-editor.85840/page-32021-11-16
Navigation Form with Ease - by ArnelGPhttps://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-17972092021-11-25
Automatic Form Resizing by "isladogs" (Colin)http://www.mendipdatasystems.co.uk/automatic-form-resizing-1/45945547842021-11-25
Create/Populate module from VBA - Doc Manhttps://www.access-programmers.co.uk/forums/threads/create-populate-module-from-vba.175967/2021-11-28
Windows API Decs - Updated for the 64-bithttps://www.microsoft.com/en-us/download/details.aspx?id=99702021-11-30
MS Access Report – dynamically collapse groupshttp://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 VBAhttps://www.everythingaccess.com/vbwatchdog.asp2021-12-17
vbWatchdog Error handler for VBA from EverythingAccess.com, by Peter Cole - Access Lunchtimehttps://youtu.be/-zEoYCdMJS42021-12-17
Implement User Preferences in MS Access - By Danny Lesandrinihttps://www.databasejournal.com/features/msaccess/article.php/3605656/Implement-User-Preferences-in-MS-Access.htm2021-12-18
Message Box MsgBox - Bitmask - Re:- MajP - AWFhttp://access.mvps.org/access/general/gen0038.htm2021-12-20
Creating Pseudo Custom Controls with Class Modules - MajPhttps://www.access-programmers.co.uk/forums/threads/creating-pseudo-custom-controls-with-class-modules.321016/#post-18021162021-12-23
Numbered Query - Roger's Access Libraryhttp://www.rogersaccesslibrary.com/forum/topic309.html2021-12-23
Continuous Form Like a Datasheet - CJ Lonconhttps://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 Bloghttps://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-18043002022-01-09
Add a value to a bound combo boxhttps://docs.microsoft.com/en-us/office/vba/access/concepts/forms/add-a-value-to-a-bound-combo-box2022-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 - isladogshttps://www.isladogs.co.uk/sql-to-vba-back-again/index.html2022-02-13
How And Why To Decompile An Access Databasehttps://www.barnesbusinesssolutions.com/WhitePaperOnHowAndWhyToDecompileAnAccessDatabase.pdf2022-04-04
Evaluate - an expression (Text) *** Eval ***https://support.microsoft.com/en-us/office/eval-function-8c4a1b10-85ba-40db-b0c8-5290da4d41662022-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 Accesshttp://www.cpearson.com/Downloads/Downloads.aspx2022-10-24
Forensics, password recovery and decryption tools by Thegrideon Software.https://www.thegrideon.com/2023-06-02
Test Regular Expressions "REGEX" "regex"https://regex101.com/2023-07-20
Peter Cole 64-bit API converterhttps://www.thememydatabase.co.uk/access32to64.html2023-08-29
Convert Windows API declarations in VBA for 64-bithttps://codekabinett.com/rdumps.php?Lang=2&targetDoc=windows-api-declaration-vba-64-bit2023-08-29
Win32API_PtrSafe with 64-bit Supporthttps://learn.microsoft.com/en-us/office/troubleshoot/office-suite-issues/win32api_ptrsafe-with-64-bit-support2023-08-29
Common Table Expressions (CTEs) Available in SQL Server database Onlyhttps://dev.to/karishmashukla/simplify-complex-sql-queries-with-common-table-expressions-ctes-3kf52023-09-01
How to find unused object/items? - MajPhttps://www.access-programmers.co.uk/forums/threads/how-to-find-unused-object-items.328215/2023-09-08
This excellent plugin for displaying Google Sheets in a WordPress website is just absolutely fantastic!
Thank you maymay

… …

More Useful Stuff HERE:-

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.