LEARN MS-ACCESS TIPS AND TRICKS

DIRectory and File Copy Utility. Last week, we explored how to use the Dir() DOS command to read files from the Disk one by one and display...

Introduction. Most of us are familiar with the Dir() function from the days of the DOS operating system. Dir() has often been the very fir...

Form Recordset and Bookmarks. Bookmarks are stored in a form’s Recordset when the form is loaded into memory. For each record in the table o...

Activity Dates and Quarterly Reports. There are four Quarters in a Year: Jan - Mar = 1st Quarter Apr - Jun = 2nd Jul - Sep  = 3rd Oct - D...

Finding the Last Day of the Week. How can we determine the weekend date or the first day of a week using the current date as input? Similarl...

Time Value Formatting Beyond Twenty-Four Hours. The standard time format hh:nn:ss displays values up to 23 hours, 59 minutes, and 59 second...

Opening Multiple Instances of a Form in Memory. Over the past few weeks, we have been learning about the dot (.) separator and the exclamati...

The Final Post and Continued from Last Week's Post . In Microsoft Access, application objects such as Tables, Queries, Forms, Text Boxes...

Dots and Exclamation Marks Usage with Objects in VBA2.   Last Week's Topic Last week, we learned a few examples of using the dot (.) sep...

Dots and Exclamation Marks Usage with Objects in VBA. Beginner VBA learners are often confused about how to correctly reference controls in ...