Search results

Okay that makes sense, thank you, I will actually incorporate their Personnel Numbers. Maybe that will help.

I don't have any Primary Keys except for "ID (Auto Number)" in the DataTracker table. On my data entry form, when I choose a specific Employee (Supervisor) from the drop down it will automatically add all the employee information. From that point I choose the document from a drop down menu as...

Table: DataTracker Field Names: Document, Supervisor, Month Table: CrewMapping Field Names: Supervisor Table: Documents Field Names: Document Table: Months Field Names: Month

Okay not a problem, I can change that and identify the data by year by using a column. Thanks!

Hi James. Yes, here the following tables with all my data. TBL_2015DataTracker: This table has all the data entry records from the form, which I want the query to look at ultimately. TBL_CrewMapping: This table has a list of all the employee names. TBL_Documents: This table has a list...

Hello. I need a query that will result in a list of records for a specific criteria. For example..... I have a table called "TBL_2015DataTracker" with all my data that I enter on a daily basis using a form. The data to be entered on the form is an employee name, the specific document they...

you are the best ever!!!!!! It works!!!!!!! I'm jumping up and down excited!! Thank you so very much!! You are the man of access!! You are saving me a tremendous amount of manual work and you have helped me optimize my workload!!

Bob Fitz.....Thanks for the code! I found a similar code to yours below. This one works with the exception of I didn't put the Supervisor field but it still gave me a Duplicate message when I attempted to enter a new entry after the duplicate entry so this works but as I had mentioned above, I...

Okay I can try this. Does this still work if I only want to identify duplicates for 2 specific documents? I only want the form to trigger when Monthly Inspection OR Safety Roster is chosen for X Supervisor and the X Month. If there is already a line item for "Safety Roster" for "Tom Jones"...

The only problem I see with this is that I dont want duplicates for just 2 specific documents. I have a total of 3 documents and 2 out of the 3 are the ones I don't need duplicates for. The other document, the Supervisor conducts meetings with as many employees so duplicates would suffice.

TBL_Documents Field Name: "Document" TBL_CrewMapping Field Name: "Supervisor" TBL_Months Field Name: "Month"

WOW thank you for going through all this work. Much appreciated, unfortunately this code didn't work for me. I did exactly what you told me and I went back to the form to see if the error would generate by entering a duplicate and it just took the entry like it was a new one.

1st Combo Box = "Document" Row Source = "TBL_Documents" 2nd Combo Box = "Supervisor" Row Source = "SELECT TBL_CrewMapping.Supervisor, TBL_CrewMapping.Manager, TBL_CrewMapping.AOR, TBL_CrewMapping.[Org Unit] FROM TBL_CrewMapping ORDER BY TBL_CrewMapping.Supervisor;" 3rd Combo Box = "Month"...

Thank you. I'm not too familar with coding. I know very little. Can you post an example and I can replace the field names and table names with my own references?

Hello all. This is my first time reaching out on forums. I typically find my answers on here but this time for this specific question I can't seem to find a similar post so I'm hoping for some feedback. I'm in Access 2013 and I built a form with multiple drop downs. Here is what I have in the...