Search all of our videos below:
- 1. Using IIF() and Tempvars in Cascading Combo boxes - February 2020
February’s meeting was presented by George Hepworth, of Grover Park Consulting. George is an author and long time Access MVP.
- 2. Calendar Maker - January, 2020
presented by Crystal Long
17 January 2020
hosted by Dale Fye
Draw monthly calendars with Microsoft Access using a report and VBA. To make it easy, there is a menu form, but you don't need it to make calendars. There can be a big calendar on a page with one month, or multiple calendars per page showing however many months you want to see.
To draw a calendar on any report, anywhere, whatever size you want, call the CalendarMaker sub, which has parameters for the report object, xy coordinates, width, and height. The report object doesn't need any controls for the calendar, it just needs a page to act as a canvas to draw on. To address any coordinate on the page, the code should be in the Report_Page event.
When each calendar is drawn, the language used for month and day names is controlled by your Windows region settings. Start weeks with any day, like Sunday, Monday, or whatever you like. Show information on days using queries that you design from your database.
- 3. Goodbye, memory errors! - December, 2019
This month’s presenter is Karl Donaubauer, long time Access MVP and organizer of several annual Access conferences in Europe, including an English language version in Vienna, Austria (25/26 Apr 2020).
- 4. VBA Code Quality - November, 2019
- 5. Data replication with Access (part 1) - September, 2019
- 6. Denormalizing Data - March, 2019
- 7. How to add shortcut (right-click) menus to Access applications - February, 2019
- 8. Demonstration on using Power BI with MS Access - December, 2018
- 9. Open Discussion - May, 2018
- 10. Reports - December, 2017
- 11. ListBox Selection - November, 2017