Search results

I'm not using an AutoNumber, it's a text field.

When I try that it allows me to enter duplicates.

Are there any other functions I can use for checking if a duplicate text record exists?

np, I tried: Private Sub txtCourseID_BeforeUpdate(Cancel As Integer) If DCount("*", "tblCourse", "CourseID=" & Me.txtCourseID.Value) > 0 Then Cancel = True MsgBox "This Course ID is already being used." Me.txtCourseID.Undo End If End Sub but I get the following error prompt...

If I can get the solution for one, I can apply it to the other two.

Thought one of these might have worked but I get the prompt even when a new ID is entered. Private Sub txtCourseID_BeforeUpdate(Cancel As Integer) If DCount("CourseID", "tblCourse", [txtCourseID]) > 0 Then MsgBox "This Course ID is already being used." Me.txtCourseID.Undo...

I'm not sure I understand your question but I think the answer is their ID PK. (they're separate tables)

I've deleted the duplicate thread.

They are indexed (no duplicates) but I'm still able to create duplicates using the form. I'm going to need to add an extra layer to prevent duplications. What event should I add to the BeforeUpdate for these controls?

Is this suitable for preventing duplicate records?

At the minute I am using the following input masks and default values: "S"000 S000 "C"000 C000 "T"000 T000 (field size: 4) When searching queries I enter their ID.

What would be the Access 2007 VBA code for checking for duplicate records?

Re: A001 Custom Autonumber S001-S999 for Staff PKs C001-C999 for Course PKs T001-T999 for Trainee PKs

I'm still stuck on this, are there any other suggestions?

Yea I like the calender feature.

The table field actually has a Show Date Picker property too..

I have two medium time date/time fields and when entering information into these fields a calender is available to the right of the field. Is there a way to remove the calender for these fields?

How do I create an expression field that calculates the difference between a start time and finish time in hours, e.g. display 1 as the difference between 10:00AM and 11:00AM. Thanks.

I have a number field in my subform that's autoupdated but I'd like it to display "weeks" beside the number without trying to store it, is this possible?

I got the code that wasn't working working: Private Sub cboCourseID_AfterUpdate() If DCount("CourseID", "tblBooking", "CourseID = [cboCourseID]") >= 5 Then MsgBox "This course is full" End If End Sub For some reason the equals sign made a big difference, thanks for all your help pbaldy...