Search results

Hmmm... Looking at the subform now, it looks like it is based on the Course table and the Junction table as it has the fields Course ID and Course Title (from the Course table) and the ID, Staff ID and Course ID as well as Completion Date and Renewal Date (all from the Junction table)

SQL statement: Sorry for the delay wasn't 100% sure what to look for but here it is: SELECT StaffTable.StaffID AS StaffTable_StaffID, StaffTable.FirstName, StaffTable.Surname, StaffTable.Status, StaffTable.Role, StaffTable.Department, StaffTable.LineManager, StaffTable.[Start/LeavingDate]...

Hi Great idea, and I have modified my design but although I am still getting all the existing records showing up as they should now when I go to assign a course to a new staff member I get the course ID number instead of the course title but at least I can add a course

Link Master Field = Staff ID Link Child Field = Staff ID using the Staff course Query

Thanks for a prompt reply. The main form is bound to the staff table, the subform is bound to a staff courses query and the combo box is based on the courses table

Thanks for a prompt reply. The main form is bound to the staff table, the subform is bound to a staff courses query and the combo box is based on the courses table

Hi, I'm going round in circles with this problem and I need some help, please. I am creating a many to many relationship in my Staff --- Courses database. I have a Staff table with StaffID as the Primary key, a courses table with CourseID as the Primary key and a Junction table with its own ID...

I think you're probably right to say look at getting one built. Although the staff won't be accessing the database at the same time it is something that has to be stable and has to last over time. Thanks for taking the time to consider this.

Wow, thanks for the prompt responses. Splitting the database is no problem but I have no experience of setting up the SQL server back end - yet! From what I have read I think you are right so I will just have to continue working through it and talk to my techie team to get access to the SQL server.

Hi, I have just created a database that is intended to sit on a shared network drive and can be accessed by up 70 memebers of staff. Each member of staff has personal data stored in the database. One of the options on the user form is to search for and allow editing of their details. Clicking on...

Hi Gina and to all the rest that made suggestions to try and help out. Huuuuuge thank you for sorting it out. You made it sound so obvious and easy but I have learned a lot just from this mistake. Gina, I have taken on board your suggestion relating to the work not done, many thanks for that...

Hi Gina, Many thanks for your offer to have a look at the database. Please see attached

The Welcome screen has a single button on it titled 'nter Database' which takes you through to the Staff Record Entry Form. The code for this button from the Open Form Macro: OpenForm Form Name: Staff Record Entry Form View: Form Filter Name Where Condition: Data Mode: Read Only Window Mode...

Hi Ken, Thank you for your response. Please bear with me but how will I know if it is getting focus when it opens and I'm not sure what you mean by 'a requery or a do events just before the new record line'.

This is my problem: I have two forms (both of which open in Form View) one is a Welcome form with a single button that says 'Click here to enter the database'. When it is clicked it opens a second form - the Staff Record Entry form. On this form I have two buttons 'Add a new Record' and 'Search...

Hi, what brought me to this forum and prompted me to join was that I encountered a problem with a database I was creating. Whilst not exactly new to using access I am definitiely not an expert and this seems a good place to go to for the kind of help I need. My background is in the Education...