by Jonathan Halder | Jul 16, 2024 | MS Access, MS Access Features, MS Access VBA Coding
I had never heard of this keyword. I was perusing the Microsoft Learn web site and happened across this in the VBA reference here: Deftype statements (VBA) | Microsoft Learn Here is the basic definition from that page: Used at the module level to set the default data...
by Jonathan Halder | Jul 12, 2024 | MS Access, MS Access VBA Coding
A lot of Access users (especially newer ones) like to use the function DLookup to quickly lookup a value from a table or query. It is quite handy shorthand and can be used in VBA and in queries. The usage of DLookup is: DLookup (Expr, Domain, Criteria)...
by Jonathan Halder | Jul 11, 2024 | MS Access, MS Access Features, MS Access Forms, MS Access Queries, MS Access VBA Coding
I’m revisiting my ListBox control work from these two articles: Access ListBox Row Source and Type | Access JumpStart ListBox Column size adjustments | Access JumpStart The second article discsusses how to adjust column sizes using the ColumnWidths property and...
by Jonathan Halder | Jul 9, 2024 | MS Access, MS Access Forms, MS Access VBA Coding
In a previous article, I discussed a listbox conundrum I had with really long lists: Access ListBox Row Source and Type | Access JumpStart One of the things I wanted to do with this listbox was adjust the column sizes of the list on the fly, depending on the size of...
by Jonathan Halder | Jul 8, 2024 | MS Access, MS Access Features, MS Access Queries
Sometimes my customers ask me for data from their database that they want to see in a way they’ve never looked at or needed to look at it before. When this happens to me and the answer is a data pull, I will often either pull up an existing query with the answer...
