Formatting Excel worksheet: Adding FreezePane

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

Read More

Application Launchers

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

Read More

Using Access to fill Word Mail merge documents

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

Read More

Access – T-SQL Translator

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

Read More

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
© 2024 Developing Solutions | ScrollMe by AccessPress Themes