Search results

Yes, that is exactly it (I would like it bigger though if possible) And I want these 3 buttons to open the same Form called "Individuals". When I enter data in the database I have already set it so that I have a lookup of two options to choose from EMP or RES... Thank you for your help. :)

Working on both the above right now but I do go slowly so bare with me. :)

Yes, I understand that now and it was entirely my mistake :o

Hello and thank you very much for your input. My first Switchboard worked fine but was based on my original database (tblResidents and tblEmployees). Once I followed your advice and merged all "individuals" in one table I deleted tblRsidents and tblEmployees and created one tblIndividuals which...

tblIndividuals I have a list of individuals in the same table (Employees & Residents) I need to create a switchboard with 2 buttons that will give staff an option to OPEN the same FORM but with either all the RESIDENTS or EMPLOYEES I have IndividualID and IndividualType (Res or Emp). I tried...

Can I still run this query if I have an autonumber PK?

Please find attached amendments made so far. PRIMARY KEY QUESTION: Can I leave ReportsID on AutoNumber? How about all the other tables that I am going to have to create as advise above. Can all the PK be left on AutoNumber or will this cause confusions? Re the tblReports and tblComment, which...

Can this comment table be used for both Employees and Residents?

Thank you so much Pat Hartman. I am going to start all over again slowly and following your advice. Could you confirm if I should change the 3 PK from AUTONUMBER to text and numbers and type them in manually? i.e. a-z for ResidentID A-Z for EmployeeID 0-9 for ReportID Thank you.

OK is this any better...

Bump! Can anyone help by checking the attachment above for me? Please feel free to ask me any questions and if it is wrong I will have no problem restarting the database all over again. Thank you kindly.

Thank you Pat Hartman. I have played with the Switchboard and it is exactly what I need :) I have attached what I have done so far on my database. I could try to put all the employees and residents in the same table but I do not know what "flag" is? Would appreciate it if you can spot my...

I have been asked to elaborate in simple words so I am going to try. I have a database When I open it I want to see TWO BUTTONS on a Form (like a login screen) -Employees -Residents

Hello there I am new here and to Access 2007. I am creating a database with several tables and the main ones would be about - Employee Database - Resident Database Right now I am creating all my tables and I will have several tables with information relating to either Employee or Residents...

Hello I was an ICT Teacher for 10 years until I was dismissed due to ill health. As I am not fit to work (disabled - chronic illness) I have decided to do voluntary work for my professional friends from home to keep busy. I love challenges so I took on several Access 2007 projects which I have...