GPGeorge
George Hepworth
- Local time
- Yesterday, 21:25
- Joined
- Nov 25, 2004
- Messages
- 2,286
Can you display and edit properly normalized data in a form which resembles a spreadsheet?
Although it sounds impossible, it can be done with the right technique. Pat Hartman shares her method with us.
She will show us the sample database containing two examples (using the same technique) of how to take data that is properly normalized and display it so that it looks like a spreadsheet (rows displayed as columns) but is actually updateable. The technique uses a separate query for each column, then a master query to join all the “column” queries into a single recordset. It is limited but works well for 12 months. Using her downloadable sample databases as templates, you can expand the technique in your own applications.
Prepare for the presentation by downloading the files Pat will demonstrate and discuss.
Join us for a lively presentation and follow-up Q & A. We often range beyond the topic of the evening’s presentation, so plan on sharing your own ideas and experiences with your colleagues.
Please join us for our Monthly Chapter Presentation , at 6:30PM Pacific (UTC -8)
(Please verify your Time Zone offset with World Time Buddy as Daylight Savings changes are coming up soon.)
Access Pacific holds FREE Q&A webinars the First Thursday of every month, from 6:30 pm to 7:30 pm Pacific.
Add AUG Pacific meetings to your Outlook Calender
One of my favorite parts of most meetings has been when we end the recording and just talk. Usually we focus on the material in the presentation, but not always
. We get a chance to stay connected with other working Access developers; that's invaluable and rare in this virtual world.
If you have ideas for a presentation, or a topic you'd like to explore, use this email or the feedback link on the AUG web site to let me know.
Access Pacific holds FREE Q&A webinars the First Thursday of every month, from 6:30 pm to 7:30 pm Pacific.
________________________________________
Please prepare ahead of time by downloading Zoom, if you don’t already have it.
Add the meeting to your Outlook calendar.
To join our meetings, please use the following link and phone number or use your computer’s speakers with audio:
When it’s time, join the meeting from here:
Join Zoom Meeting
Although it sounds impossible, it can be done with the right technique. Pat Hartman shares her method with us.
She will show us the sample database containing two examples (using the same technique) of how to take data that is properly normalized and display it so that it looks like a spreadsheet (rows displayed as columns) but is actually updateable. The technique uses a separate query for each column, then a master query to join all the “column” queries into a single recordset. It is limited but works well for 12 months. Using her downloadable sample databases as templates, you can expand the technique in your own applications.
Prepare for the presentation by downloading the files Pat will demonstrate and discuss.
Join us for a lively presentation and follow-up Q & A. We often range beyond the topic of the evening’s presentation, so plan on sharing your own ideas and experiences with your colleagues.
Please join us for our Monthly Chapter Presentation , at 6:30PM Pacific (UTC -8)
(Please verify your Time Zone offset with World Time Buddy as Daylight Savings changes are coming up soon.)
Access Pacific holds FREE Q&A webinars the First Thursday of every month, from 6:30 pm to 7:30 pm Pacific.
Add AUG Pacific meetings to your Outlook Calender
One of my favorite parts of most meetings has been when we end the recording and just talk. Usually we focus on the material in the presentation, but not always
. We get a chance to stay connected with other working Access developers; that's invaluable and rare in this virtual world.If you have ideas for a presentation, or a topic you'd like to explore, use this email or the feedback link on the AUG web site to let me know.
Access Pacific holds FREE Q&A webinars the First Thursday of every month, from 6:30 pm to 7:30 pm Pacific.
________________________________________
Please prepare ahead of time by downloading Zoom, if you don’t already have it.
Add the meeting to your Outlook calendar.
To join our meetings, please use the following link and phone number or use your computer’s speakers with audio:
When it’s time, join the meeting from here:
Join Zoom Meeting
Last edited:
and jump up on the table where we were playing cards.
