by Jonathan Halder | Jan 14, 2025 | Blogging, MS Access, MS Access Features, MS Access VBA Coding
One strategy I have used to run automated processes with Access is to use Command Line switches. So to start up Access you use the Access program “MsAccess.exe”, usually with the full path to it, then use the database you are opening as an argument, and...
by Jonathan Halder | Jan 13, 2025 | Blogging, MS Access, MS Access VBA Coding
I seem to have had a number of problems lately with a particular user who is running into issues trying to open an Access application multiple times. When doing so, the second instance will shutdown, but before doing so will display a box saying that Access already...
by Jonathan Halder | Jan 10, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Reports, MS Access VBA Coding
Another gotcha in Access is when you use a function of any kind as a query field or as a bound field on a form or report. This can also be done in Conditional Formatting fields in forms and reports. Let’s say you bind a continuous form field to the builtin...
by Jonathan Halder | Jan 9, 2025 | Blogging, MS Access, MS Access Forms, MS Access VBA Coding
I had written some code for a client using the onChange and onKeyPress events of a ComboBox to be able to determine when the user had simply typed some text in, or whether they had selected an item from the dropdown list using the dropdown event. This was because the...
by Jonathan Halder | Jan 8, 2025 | Blogging, MS Access, MS Access Forms, MS Access Queries, MS Access Tables, MS Access VBA Coding
Today I had a weird problem that took me about 2 hours to track down. I had a normal form in Continuous view that was not triggering an error of any kind, but would not write to the record. It could see all the records, you could navigate to them, and I had a delete...
