***NEW CUSTOMER OFFER***
Get 15 minutes of free Live Help!

Code Snippets + Tips

Get a list of form controls sorted by tab order

Jan 29, 2014 in Arrays, Collections, Controls, Forms, Loops, Microsoft Access, VBA | 0 comments

When you iterate through a collection of controls in a Microsoft Access form, the order of the list of controls that you end up with may not be sorted as you expect. Rather than being sorted by the tab index, the list will be sorted …

read more

Scroll in a Microsoft Access text box using the mouse wheel

Jan 27, 2014 in Forms, Uncategorized, VBA, Windows API | 1 comment

Microsoft Access does not have built-in mouse wheel scrolling in form text boxes. You can provide mouse wheel scrolling by writing some VBA code in the Form_MouseWheel() event procedure. Trying to scroll in a text box can be particularly frustrating if the bottom of the …

read more

Get total hours and minutes from summing columns of Hours and Minutes

Oct 22, 2013 in Date, Time, and Age Functions, Microsoft Access, Number Functions, VBA | 0 comments

Get total hours and minutes from summing columns of Hours and Minutes

This function can be used to return total hours or total minutes from a column of Hours and a column of Minute values.  For example, in the table below, an Hours value was captured separately from a Minutes value in a time clock application.  If …

read more

Use VBA to add days to a date but exclude Saturday and Sunday

Oct 8, 2013 in Date, Time, and Age Functions, Microsoft Access, Microsoft Excel, VBA | 0 comments

This function finds a date a certain number of days from a start date when weekends are not included. It can be used when your work week does not include Saturday and Sunday and you want to find a business day in the future. Microsoft …

read more

“Folder In Use” Error After Using DoCmd.OutputTo for PDF Export

Oct 1, 2013 in Errors, Microsoft Access, VBA | 0 comments

“Folder In Use” Error After Using DoCmd.OutputTo for PDF Export

I got a “Folder In Use” error after using a loop that included the DoCmd.OutputTo macro action to export a Microsoft Access report to PDF files.  The error occurred when I tried to rename the folder that the PDF files were exported to. Using the...

read more

Live Chat Software