Have you ever: – needed to know what record was displayed at the top of a continuous form or sub-form – wanted to re-query a form and reset it so that the selected record is in the same position within the continuous form or sub-form that it was in before the re-query – needed to […]
Have you ever needed to work on an application and couldn’tbecause someone had a lock on either the front-end or the back-end? Some of you have probably already incorporated a similar feature into your own applications, but I’ve seen a couple of posts recently on several Access websites, so I thought I’d share the method […]
Bug in latest Office update affects Access’s ability to recognize Identity Columns in linked SQL Server tables. This bug affects C2R installations of Office 2016, 2019, and O365. If your application refreshes existing links or creates new links to the SQL Server tables, these columns will be recognized as PK (if they are), but will […]
Finished updating the latest version of my Date/Time picker. You can read more about this in my Experts Exchange article. You can use it as a date picker, time picker, or both with very little code. I use it in my billing application, allowing me to default the start and end times of my work […]
Have you ever wanted to display and edit data in a form that looks like a Cross-Tab query? A great example of this might be to allow users to enter their hours spent on various projects (rows) for each day (columns) in the current week or month. Last month, during my monthly Access User Groups […]
In preparation for my Skype for Business meeting this morning, I pulled some code I use to determine which shortcut menu I’ve encountered. The file “WhatsThis.bas” contains three functions. dfcbt_WhatsThisMenuAdd: Adds at item to the bottom of every shortcut menu which will display a popup with the name of the shortcut menu that the item […]
Everyone who uses Windows is familiar with shortcut (right-click) menus. Through A2003, it was relatively easy to create these menus via a built-in interface, but this feature was deprecated in 2007, making it more difficult to create shortcut menus. As a result, I’ve seen fewer developers taking advantage of this feature of Access, despite the […]
Are you ready for a Linked Table Manager (LTM):Â Â Â Â Â Â Â Â Â Â Â Â – with a sizable form – which identifies which connections are valid and how many tables are associated with each connection – which doesn’t ask you to select the BE multiple times when you’ve identified tables from multiple sources to refresh? For years, the Access community […]
Right-Click (shortcut) menus are in integral part of the Windows   environment and users expect to see them in their custom       applications as well. However, the shortcut menus built-in to MS Access frequently present users with a full set of options, many of which you might not want […]
In addition to the database development and maintenance services we provide, Developing Solutions also develops custom Add-ins for Microsoft Access which improve the developer experience: The Access Shortcut Tool is an add-in designed to replace the shortcut (right-click) menu creator that was built-in to A2003 but was left out of 2007 and all subsequent versions […]