Aug 10 2021 05:46 PM
Hello and thank you for anyone who can assist me with this problem. I'm trying get a form that brings up data in a calendar type design. To record data based on what date they input on. the following is the design of the form.
Under each date you would input how many minutes. The table Structure base is ID, Name, TimeValue, TimeDate.
not sure how to get the TimeDate and display Multiple TimeValues on one Form.
Thanks again for any assistance.
Aug 11 2021 01:35 AM
Aug 11 2021 09:56 AM
Aug 11 2021 11:31 AM
No. A crosstab query changes a normalised Access table into a spreadsheet type layout.
See Make summary data easier to read by using a crosstab query - Access (microsoft.com)
A query based on several tables may be editable. It depends on the query SQL.
Please post the SQL for the form record source as I don't have enough info to give any advice.
Aug 12 2021 08:50 AM
Aug 13 2021 01:43 PM
Aug 13 2021 04:50 PM
Aug 14 2021 09:45 AM
Aug 14 2021 10:21 AM
I also created several similar forms a few years ago and can vouch for the fact that it was a lot of work. One example was for viewing/editing student attendance data and another for calendar events in a school:
The monthly calendar could also be viewed as a weekly and daily calendar in which time slots were included
In each case, just as George described earlier, I created a crosstab query based on a normalised table. Next I made a 'temp table from the crosstab so the data could be edited on the form. Likewise, on closing the form, all the data was saved back to the original table and the 'temp table' was emptied.
I do still have these examples but they are part of a commercial app for schools and it would be far too lengthy a process to extricate.
However Peter Hibbs at Utter Access forum has been developing an Outlook style calendar for Access for many years and it is still freely available. It should certainly be useful to you and it may well be that you can adapt it for your own needs: https://www.utteraccess.com/topics/1969978.
For info, it is a very lengthy thread with over 370 posts.
Aug 14 2021 02:45 PM
Thanks for pointing to Peter Hibb's calendar. I'd forgotten it.
Nice work on the attendance and events calendars.
I'm working on a simplified demo, a bit at a time. It might be ready to share soon.
Aug 15 2021 12:37 PM
My demo "works" as is, but I surfaced a serious flaw during testing. The approach I took works satisfactorily if there is ONE event per day. However, it can't adequately handle multiple events on a single day. I'm not sure I want to put in any more time on it, as a matter of fact.
If the demos and downloads previously cited don't meet your needs, I'd say a traditional main form/subform design is in order.
If I feel more ambitious later, I might tackle this again, but right now not so much.
Aug 19 2021 09:34 AM