ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
NameURLDATE.RankDetails
2
Access Web and Desktop Advicehttps://vb123.com/vba/2015-08-175
3
Brilliant Video on Access 2010 MultiValued ComboBoxhttps://www.youtube.com/watch?v=queKMe9MiSs2016-01-265
4
Data Modeling 101http://www.agiledata.org/essays/dataModeling101.html2015-10-255
5
Database Development Exampleshttp://www.databasedevelopment.co.uk/examples.htm2015-11-035
6
Description of database normalization basics in Access 2000https://support.microsoft.com/en-gb/kb/2095342015-11-035
7
FunctionX Tutorialshttp://www.functionx.com/2015-08-175
8
Generate Random Data Onlinehttp://www.generatedata.com/#about2016-01-105
9
Helen Feddemahttp://www.helenfeddema.com/2015-11-035
10
How I Exported an Attachment fields data to a folderhttp://www.access-programmers.co.uk/forums/showthread.php?t=2281462016-02-145
11
How to Create a Stock Management Databasehttps://youtu.be/9HRmSRR29fY2015-11-045
12
How to return multiple values from a VBA function (Part 1)http://www.geeksengine.com/article/vba-function-multiple-values.html2015-12-085
13
J Street Developer Downloadshttp://www.jstreettech.com/downloads.aspx2015-11-035
14
Khan Academy - Learn SQLhttps://www.khanacademy.org/computing/computer-programming/sql2015-08-175
15
Martin Green's Access Tipshttp://www.fontstuff.com/access/index.htm2016-01-095
16
Microsoft Access Database Tutorial – Learn How To Use Microsoft Accesshttp://accessdatabasetutorial.com/2015-11-035
17
Microsoft Access interview questionshttp://www.careerride.com/microsoft-access-interview-questions.aspx2015-11-035
18
Microsoft Office/Access Basic Examhttps://en.wikibooks.org/wiki/Microsoft_Office/Access_Basic_Exam2015-11-035
19
MS Access Useful Codehttps://sites.google.com/site/msaccesscode/system/app/pages/sitemap/hierarchy2015-11-035
20
Ranking-queries-ms-access-sqlhttps://bytes.com/topic/access/insights/954764-ranking-queries-ms-access-sql2015-11-105
21
Roger's Access Bloghttp://rogersaccessblog.blogspot.co.uk/2015-11-045
22
Smart Access Articleshttps://msdn.microsoft.com/en-us/library/bb190857(v=office.11).aspx2015-11-175
23
SQL Server Centralhttp://www.sqlservercentral.com/2015-11-035
24
Sub Querieshttp://www.tutorialspoint.com/sql/sql-sub-queries.htm2016-01-055
25
Using class modules to create your own objectshttp://www.di-mgt.com.au/classes.html2015-11-035
26
vb123.com KBhttp://vb123.com.au/index.html?related_topics.htm2015-11-175
27
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-305
28
Welcome To Roger's Access Libraryhttp://www.rogersaccesslibrary.com/2015-11-045
29
WWW SQL Designerhttp://ondras.zarovi.cz/sql/demo/2015-11-035
30
Microsoft Access Email FAQ - Tony Toewshttp://www.granite.ab.ca/access/email.htm2015-10-035
31
Soft-coded event handlers ChrisOhttp://www.access-programmers.co.uk/forums/showthread.php?t=1667992015-11-035
32
Mastering the Combo Box NotInList Eventhttp://www.fontstuff.com/access/acctut20.htm2015-10-223
33
Bag Of Cows - Regular Expression Playgroundhttp://bagofcows.com/regex/index.php2019-09-063
34
V-Toolshttp://www.skrol29.com/us/vtools.php2019-09-223
35
Database Issue Checker Utilityhttp://allenbrowne.com/AppIssueChecker.html2019-09-223
36
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-273
37
Build an Unmatched Query with SQL
https://anthonysmoak.com/2017/10/18/return-unmatched-records-with-sql-and-microsoft-access/
2019-09-273
38
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-273
39
Finding All Records in One Table but Not Another (FMS)https://www.fmsinc.com/MicrosoftAccess/query/outer-join/index.html2019-09-273
40
Tutorials for Microsoft® Accesshttps://www.everythingaccess.com/tutorials.asp2019-10-203
41
Darragh Murray Percentage Field Formattinghttp://www.darraghmurray.com/ms-access-tips/ms-access-percentage-field-formatting/2019-11-013
42
Balance Bracketshttp://www.balancebraces.com/2019-11-073
43
Create Table DAO
https://www.everythingaccess.com/tutorials.asp?ID=DAO-programming-examples#CreateTableDAO
2019-11-213
44
Good Example of a SubQueryhttps://www.everythingaccess.com/tutorials.asp?ID=What%27s-a-subquery%3F2019-11-213
45
Surviving subquerieshttps://www.everythingaccess.com/tutorials.asp?ID=Surviving-Subqueries2019-11-213
46
Article from Philipp Stiefel - Date Format
https://codekabinett.com/rdumps.php?Lang=2&targetDoc=format-date-language-country-vba-access
2019-11-223
47
Move Items From One Listbox to Another Listbox by MajPhttps://www.tek-tips.com/faqs.cfm?fid=63262019-11-233
48
Tree View Control - VBAhttps://www.jkp-ads.com/articles/treeview.asp2019-11-243
49
Format SQL with "Poor SQL"https://poorsql.com/2020-01-143
50
SQL Validator Checkerhttps://www.eversql.com/sql-syntax-check-validator/2020-01-293
51
The MsgBox function takes five argumentshttp://www.functionx.com/vbaccess2010/topics/msgbox.htm2020-02-163
52
Table to Exclude Data From a Queryhttps://btabdevelopment.com/how-to-use-a-table-to-exclude-data-from-a-query/2010-07-113
53
Hilite - converts your code - USE:- Lang VB.Net - Style vshttp://hilite.me/2020-03-283
54
 Database Answers - Data Models in 50 categorieshttp://www.databaseanswers.org/data_models/index.htm2020-05-103
55
Tab Control Password https://www.access-programmers.co.uk/forums/threads/tab-control-password.83036/2005-05-113
56
Audit Trailhttps://www.access-programmers.co.uk/forums/threads/audit-trail.44231/2003-03-183
57
Microsoft Access and Google Calendarhttp://www.utteraccess.com/forum/index.php?showtopic=20415182017-01-123
58
Dev Huthttps://www.devhut.net/2017-12-023
59
Iterating over MS Access Dictionary
https://www.access-programmers.co.uk/forums/threads/vba-iterating-over-ms-access-dictionary.291089/
2016-12-203
60
Running Sum In Query.mdb (beginner)
http://www.rogersaccesslibrary.com/forum/runningsuminquerymdb-beginner_topic279.html?SID=1ad20d6294bfb7bf5d764e964fca75638888889
2017-01-103
61
Combobox - Why Doesn't the Dropdown sustain?
https://www.access-programmers.co.uk/forums/threads/why-doesnt-the-dropdown-sustain.285870/
2016-04-083
62
Manipulating XL via VBAhttp://www.access-programmers.co.uk/forums/showthread.php?t=1275962015-11-031
63
Switchboardhttp://www.access-programmers.co.uk/forums/showthread.php?t=880122015-11-031
64
Helen Feddema (NEW)https://office-watch.com/category/microsoft-access/2019-07-191
65
List details horizontallyhttp://www.access-programmers.co.uk/forums/showpost.php?p=308045&postcount=22015-11-031
66
Gina Whipp - Conditional Row Shading on a Continuous Form
http://regina-whipp.com/blog/?p=9252015-11-031
67
Allen Browne - Inventory Control: Quantity on Handhttp://allenbrowne.com/appinventory.html2012-07-061
68
My MS Access Blog (Not Mine)http://mymsaccessblog.blogspot.co.uk/2012-07-061
69
Excel In Accesshttps://access-programmers.co.uk/forums/showthread.php?p=6712262019-05-101
70
Learn Structured Query Language onlinehttp://webcheatsheet.com/sql/interactive_sql_tutorial/2012-07-061
71
Grumpy Old DBAhttp://www.grumpyolddba.co.uk/default.htm2015-11-031
72
How Many Legs? An Exercise in Classes and Objectshttp://mymsaccessblog.blogspot.com/2008/10/how-many-legs-exercise-in-classes-and.html2008-10-113
73
Professor David West - OOP is Dead! Long Live OODD!https://vimeo.com/774158962014-11-031
74
Access OOP examples wanted
https://www.access-programmers.co.uk/forums/threads/access-oop-examples-wanted.270135/
2014-10-101
75
Microsoft Access interview questionshttps://www.careerride.com/microsoft-access-interview-questions.aspx2012-07-061
76
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-053
77
How to Connect to Your MySQL Database Remotely Using ODBC
https://www.webhostinghero.com/connect-to-mysql-remotely-using-odbc/2018-02-161
78
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-161
79
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-183
80
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-033
81
@@Identity Private GDoc
https://docs.google.com/document/d/1H8NKEN5rhcfmLIL150Vd4MYDt4OWGc347hmC4xtSiRw/edit#
2011-03-313
82
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-313
83
Avoid when using VBA Recordset
https://www.techrepublic.com/blog/10-things/10-plus-mistakes-to-avoid-when-using-vba-recordset-objects/
2017-07-093
84
BatchCollisionCount - Recordset.Update method (DAO)
https://docs.microsoft.com/en-gb/office/client-developer/access/desktop-database-reference/recordset-update-method-dao
2017-07-093
85
Generate Word Doc from MS Accesshttps://docs.microsoft.com/en-us/office/vba/api/access.webbrowsercontrol.object2020-05-111
86
Export Tbl-Qry To Excl Worksheet / Workbook
https://btabdevelopment.com/export-a-table-or-query-to-excel-specific-worksheet-on-specific-workbook/
2020-05-201
87
Data Gnostics - Microsoft Access Tips and Trickshttp://www.datagnostics.com/tips.html2020-07-181
88
Vlad Cucinschi - MS Access Developerhttp://forestbyte.com/access-links/2020-07-231
89
Vlad Cucinschi - Pivot Table Designerhttp://forestbyte.com/ms-access-utilities/fba-pivot-table-designer/2020-07-231
90
Access VBA to Create Pivot Table Reportshttps://youtu.be/rsRQqwYKQDc2020-07-271
91
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-311
92
Permissions based on Users Level - Gina Whipphttps://www.access-diva.com/f10.html2020-08-051
93
PDF on MS Access Techniques By Susan J. Doreyhttp://www.susandoreydesigns.com/software/AccessVBATechniques.pdf2020-08-081
94
MORE from Susan J. Dorey here:-http://www.susandoreydesigns.com/software/2020-08-081
95
Stock/Inventory Video - with Free Downloadhttps://youtu.be/9HRmSRR29fY2020-10-121
96
Pat - Exporting to Excel
https://www.access-programmers.co.uk/forums/threads/exporting-access-data-into-excel-spreadsheet.314326/#post-1725819
2020-10-181
97
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-181
98
Prevent Circular References
https://www.codeproject.com/articles/38655/prevent-circular-references-in-database-design
2020-10-241
99
Excelling Automatically - Doug Steele https://www.vb123.com.au/200507_ds_excel.htm2020-12-011
100
USA Data sets - (See Terms & conditions to use in UK)https://gsociology.icaap.org/dataupload.html2020-12-051