Articles & Videos
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
I have a form that displays Contacts, and I want the user to be able to select whatever Department(s) the contact works in. On the Contact form, I have a listbox that lists all Departments available …
Concurrent updates will fail - at least partly
This happens when two (or more) processes tries to update the same record:
The first starts editingThe second starts editingOne of them saves the ed…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel.
Part 1 of this series discussed basic error handling code using VBA.
trying to extract just 3 values from an xml file (attached)
To enter a date is tricky
The Date Picker is a safe method to always ensure valid dates to be entered without noisy error messages disturbing the user. However, for many scenarios like accounting and…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, t…
Using Access & Outlook 2013. What I am trying to do is send a task to an exchange shared folder called P/O Tasks under the user admin1. I can get it to send to my default Tasks folder but that'…
Citrix is inflexible
This is notorious and for a reason. The environment provides tight security, so no steps altering it will be allowed except for a very good reason - and deploying your Access app…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form t…
I already have an application that can log into an OWA mailbox, and process all of the inbox items according to rules we have set up. Unfortunately, this application does not allow me to move the proc…
To enter time is difficult
Entering time in a form in Microsoft Access can be difficult. There is no time picker like the date picker, and if there was, it would be too slow to operate for many users…
I have all my files in the cloud of SharePoint Online. I need access to these files, with VBA, to open them from the desktop. How can I browse to these files in the cloud?
I've been an Access developer since Access 2.0, and having to manually widen my query columns has always annoyed me. This article traces the development of a Sub that saves a lot of clicking and dragg…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referen…
I have a search button that is built based on filtering a form but I want to
modify that to turn the filter on for the unbound box first. So I am trying
Me.SearchResults.filter = strWh…
Rounding should be right at hand
In many areas, rounding that accurately follows specific rules are needed - accounting, statistics, insurance, etc.
Unfortunately, the native functions of VBA th…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to b…
Hello - title of question pretty much says it all - I need to test a string value to see if it is a field name in a table, using VBA (Access 2003).
What I'm presenting in this article is the result of 2 conditions in my work area:
We have a SQL Server production environment but no development or test environment; andWe have an MS Acc…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:…
I have a form that will allow the user to set some conditions and store those conditions so that a dynamic query can be made that reflects the selections.
I have 12 fields which are represented with …
Have you ever been given the advice NOT to use domain functions inside queries? I have, and I have repeated that advice over and over again; why? The main reason is that this process …
by Patrick G. Matthews Introduction: A common request in the various database zones at Experts Exchange involves returning a concatenated list of the various items in ColumnB for eac…
by Patrick G. Matthews Introduction: All major SQL dialects allow for a Count aggregate function, and Access's native Jet SQL is no exception. As in other database platforms, Acc…
Seattle, United States
26,832 points this week
14,708 points this week
Jim Dettman (Microsoft MVP/ EE MVE)
Syracuse, New York Area, United States
10,139 points this week
Stratford, CT, United States
9,200 points this week
Scott McDaniel (Microsoft Access MVP - EE MVE )
North Augusta, South Carolina, United States
8,068 points this week