I’ve recently been working on a project where the user wants to be able to export many of his data tables/queries to Excel, with additional formatting added.  I ran into a problem that just drove me crazy for 3 days.  All I wanted to do was place the cursor in cell E3 and click the FreezePanes […]

Join me at 09:00 AM (USA Eastern Time), 19 March for a presentation on “Application Launchers”. During this discussion we will discuss the myriad of techniques to ensure you users have the latest version of your application(s), every time they are launched. AccessUserGroups.org/ET #MSAccess #AppLauncher

During the February session of the AccessUserGroups.org ET meeting, I gave a presentation on using Access to feed data to a Word mail merge document, and gave some tips on neat functionality within mail merge documents which might be beneficial to Access users.  The video of this presentation is available here. Please join us for […]

During the AccessUserGroups – ET session this morning, one of our attendees provided a link to a new tool being offered by AccessUserGroups.org which converts Access SQL to T-SQL or to VBA code. You can try this tool out at: SQL Converter This tool does a very good job of translating Access (Jet) SQL into […]

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 […]

Check out my new article on how to use multiple instances of the same sub-form to create a calendar in MS Access. I find this technique useful in a variety of situations, but more so in the case of calendars or when working with dates.  The article contains a sample database which includes tables for […]

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 […]

One of the reasons that developers disable form shortcut menus is because the shortcut menus available when you click on the form or the form title bar allow users to do things which we don’t want them to do (switch to design view is just one of many). As part of the work I did […]