Search results

I suppose I made the mistake of searching for many to many, here's what I got: Sorry - no matches. Please try some different terms. The following words are either very common, too long, or too short and were not included in your search : many, to, many I always search first and on several...

Thanks very much for that, that's excellent. It's easier to see how it works with an example. I'm going to try and adjust the database I have but if not I'll just do a new one.

Yes I think I would keep the bookings, presumably I could filter the form so that only completed courses were visible? A sample database would be good thanks. I've been working on a junction table but I'm not sure exactly what I'm doing!!

Yes it contains all training done. it's linked to the staff table 1:n. My main form has staff details linked to a subform with training done details. I'm not expert on access, I developed this database thanks to people like yourself on these forums so maybe I'm not thinking along the right...

Thanks. So, is the information stored in this table when I enter it on a form? What becomes of the training done table?

I have a small database that tracks staff training. Main tables are: tb_staff tb_courses tb_courses_done 1 staff can take many courses. I want to introduce booking - staff can book a course but not necessarily attend. Can I just add a table, say tb_course_booked and use an update query to...

That did the trick. Thanks.

I have a form/subform linked to 2 tables, staff and training. The subform lists training done and is sorted by course. How can I change the sort order to a different field? E.g. date? Thanks.

I have a database that tracks staff training in a health trust. It's pretty simple, tb_staff, tb_courses_done which is 1:n and a tb_courses 1:n on the staff_id of tb_courses_done. I want to know how to go about adding a table(s) that will allow me to book staff onto courses and track if they...

Yes, tb_staff is linked to tb_courses_done. tb_staff has staff_id to a composite key in tb_courses_done using courses_done_id, staff_id and the start date of each course.

I have a training database with multiple courses. Certain staff do course1 and thereafter course2. Course1 is only done once and course2 is a refresher done annually. I want the query to find staff that have done course2 but not course1. Thanks.

That gives a run time error 2465.

In the before update of my data entry form I have Me.LAST_MODIFIED = Now which gives date and time when the record is modified. (LAST_MODIFIED is a field in my query set to date/time). The form has a subform - main form has staff details and the subform has training done. It works OK on the...

Sorry, DEPT_WARD is a field. The error flags whatever field I leave the main form and type in the subform e.g. DEPT_WARD or BASE.

I am getting an error on a subform in my main data entry form - run time error 432 - object doesn't support property or method. It occurs when I enter a new record in the main form and attempt to add a course in a combo box in the subform that contains course details. If I run the debugger I...

No. If I select say Zenda Smith it might go to Abe Smith or whoever is the first smith. Then I have to skip through a few records to get to the one I want. It gets me near the record I want but not exactly there!

Not sure if this is what you mean but each staff member has an autonumber id. I tried to use this by making the id a combobox but I could only get it to search by id number.

When I do that I can only search by the id. I need to search by surname and name.

I'm having a bit of trouble with the following code: Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[LNAME] = '" & Me![Combo66] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark It's in the after update in a combobox on my form. It works OK in that I can select a...

Yes, it's only a test table. I tried again with replace and it seems to have worked. There were several different lengths of spaces if you see what I mean, but I think I got them all. Thanks.