Synchronize sub-forms!

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

Read More

Force users out of an Access Application

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

Read More

Access Date/Time Picker

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

Read More

De-normalizing data for the user interface

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

Read More

Shortcut menus – What is this menu

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

Read More

Make Directory

Ran into a situation this week where one of my clients wanted to save documents to a deeply nested path structure which included their clients name, the calendar year, calendar month, and then the file name.  Unfortunately, many times those paths don’t exist and you cannot simply execute a command like: mkdir “H:\ClientReports\ClientName\2019\January\” to create […]

Read More
© 2020 Developing Solutions | ScrollMe by AccessPress Themes