Stumped on Meeting Attendance Database

[miahmacdougal]

Hello all,
I am somewhat of a noob when it comes to Access, I can usually figure out what I need to do (as long as it is not too advanced), but for some reason I am totally stumped today. I know what I am trying is simple, but for some reason I cannot get it to work.
What I am trying to do is make a simple meeting attendance roster where I input a basic title of the meeting, add a date, add the length of time of the meeting, and then use a drop down to chose the employees who attended. Sounds simple, right?
Well, it is giving me issues. When I try to input data in the form, I can input into the meeting info, the date, the time - but when I go to input the employees into the subform, I receive an error "Field cannot be updated". What am I doing wrong?:banghead:
Thanks in advance, I am going to go drown myself in coffee now.

 

[Frothingslosh]

I cannot look at the database as it's an accdb rather than an mdb, but I *CAN* tell you that that error message usually means you're trying to update a non-updatable recordset. Often, that means your subform is based on a query using either sorting and grouping or a DISTINCT statement. Is either the case?

 

[miahmacdougal]

I checked to see if my Query was sorting, and it wasn't; and I don't have a DISTINCT statement in it either
Thank you for taking the time to assist, it is much appreciated

Back to the drawing board!

 

[jdraw]

Do you have a data model?
Do you have a clear statement of what your database is about?
You need these before forms and queries.

 

[miahmacdougal]

What I am aiming for is to be able to sit down and input meeting attendance about once a week. When my supervisors perform their weekly safety meeting with their crews (where the crew members may change weekly), they take a topic, have a 5 minute to an hour meeting, and then return the meeting notes to me. Presently, I log who attended which meeting for how long, and I am doing that in Excel – it is a drawn out process that, depending on how many meeting notes are turned in, can take upwards of a half of a day to input. I figure it is going to be a many to many relationship since the same person may attend many different meetings in a week, and each meeting can have several people in them. What I have so far for tables are:

TblMeetings
PK MeetingID – Auto Number
Meeting (this is the general topic of the meeting) – Text
Date of Meeting – Date/Time
Total Time of Meeting – Number


FK EEID
FK MeetingID


TblEmployee
PK EEID
Employee
Thank you,

Tim

 

[jdraw]

I suggest you work through this tutorial and then apply the same steps to your situation.

Good luck