Search results

I have tried to do this code and since I don't really understand how it works I'm obviously doing something wrong. I am now getting a syntax error in date. This is my code: Private Sub Form_BeforeUpdate(Cancel As Integer) If DCount("*", "TBL_EmpTrainDate", "[Employee_ID]='" & Me.Employee_ID & "'...

I'm going to update my question to see if I can get an answer. I have a form to enter training by employee. If the training number, employee and date all together have already been entered I need it to not allow it. If any one of the three is different it can be entered.

The new record control is not available. I can't create the form from that table because it is blank. I need the form to fill it in. The info comes from a different table. Maybe there is something I need to do that I don't realize. I didn't create the original db I'm just tasked with repairing...

This is for engagement points that employees receive for participating in particular activities. I want it to update already created records if necessary and append new records created using the form.

FYI: I am sort of a novice and definitely not a programmer so please baby me. Here is the SQL for the append. I don't understand the other question. INSERT INTO [Employee Engagement Points] ( Go_By_Name, Last_Name, Engagement_Points, Activity, Employee_ID ) SELECT [Employee Engagement...

I am trying to create a form to enter data into a table that I ultimately will create a report from. I have created a blank table with the columns I need. I created an append query to add the new records and an update query and a macro to run them on click of a button. It all runs but it doesn't...

There is a combo box to look up the employee which then populates the employee number(which is also a combo box) and name. Then there is a combo box to look up the training number which populates the training description. Then only the date has to be entered. I tried the code you suggested and...

Datatype is Autonumber and Field name on that form is CB_TrainNo.

BTW this is 2003 but will be migrated to 2007

Yes that is true. Each employee can have each training once for each date. But can have mulitple trainings on one date or the same training on different dates. And yes the same training for different employees on the same date is necessary.

OK Getting closer maybe. However each employee can have the same training no/description and same date but not both at the same time. For example if John Doe has CPR training on 3/1/2013 then CPR cannot be entered again on 3/1/2013 but it can be entered for a different date. That's what I need...

Thanks I guess but since as I stated I don't know very much at all about coding I have no clue what you mean or how to start. I know where the before update is but that's about it. Please be more specific/give example.

I have a form that training is entered into. It has Employee name, training # and description, and date. I want users to not be able to enter the same training on the same date. Different training on the same date is ok and the same training on different dates is ok. How do I go about doing...

Hi everyone. My name is Valerie and I work as IT support. I have had a good bit of training in Access 2007 but still pretty much a newbie. Working on fixing an old database that has lots of problems. You may see me a lot.