Скачать или смотреть AEU14 - Creating Calendar Format Reports (Duane Hookom)

This month’s session was led by Duane Hookom (MVP 2001-2016). Duane's presentation demonstrated techniques for data reporting in calendar formats with an additional example by Jeff Conrad. The same, simple method could be used to print seating charts and other spatial data.

Items covered included:
Quick demo of reports
Requirements
Data structure
"Tricks" used to achieve
Code review
Limitations and opportunities

LINKS:
Download the PDF & ACCDB (zipped) from: https://isladogs.co.uk/aeu-14/

Duane's website: http://www.access.hookom.net/ (*Hook'D on Access)

TIMES:
0:00 Welcome and Intro by Colin Riddington
0:29 Today's presenter - Duane Hookom - Microsoft Access Calendar Reports
1:34 Visualization of Napoloeon's 1812 march to Moscow
3:09 Specification - Week at a glance calendar similar to Outlook
3:51 Other Solutions e.g. Crystal Long / Richard Rost / Power BI
4:24 Weekly Schedule By Doctor (Design / Demo)
5:33 Weekly Schedule By Doctor (Code) - use of Me.MoveLayout=False
8:08 Report Query showing calculation for WeekOf field
9:13 Limitations & Opportunities
11:28 Daily Schedule All Doctors (Design)
13:22 Daily Schedule All Doctors (Code)
14:05 Colin - question - Is a Zoom box available in Report view? (Yes!)
15:08 Ade - question - Use a control width as a multiplier rather than setting a constant?
16:57 Crew Rotation Scehedule (Design / Demo / Code)
20:48 Dual Value Chart (Design)
21:26 Dual Value Chart (Code / Demo)
25:07 Calendar Style Schedule Report (Code / Demo)
26:36 Use of Print event (not Format) to ensure all boxes are the same height
27:55 Discussion about purpose/effect of MoveLayout=False
34:17 Jeff Conrad - Demo of Restaurant Management Application using Duane's techniques
38:44 Ant - question about report events not firing in Preview mode
40:20 Ade - question about table of contents reports
43:46 Next month - Peter Bryant - Automating DSN-Less Communication to SQL Server
46:20 Download files from this month from https://isladogs.co.uk/aeu-14/
46:39 End