Search results

I get an error when I try it that way. I was thinking of using code that checks the hidden column field to make sure it doesn't go over a certain number, would I use the following code: Private Sub cboCourseID_AfterUpdate() If [txtDCount] > 5 Then MsgBox "This course is full" End If End...

I'm using the following code: Private Sub cboCourseID_AfterUpdate() If DCount("CourseID", "tblBooking", "CourseID = [cboCourseID]") > 5 Then MsgBox "This course is full" End If End Sub I have three different bookings for the same course by three different people. So that should mean there...

I have a hidden field with following control source: =DCount("CourseID","tblBooking","CourseID = [cboCourseID]") Each course is counted, how do I restrict it to 50 now?

I have Trainee, Staff, Course, and Booking tables and forms. Everything is working fine but I want to limit the amount of bookings per course to 50, how would I go about doing this? Thanks.

Create a report that doesn't use row sources then link to that report with a button labeled print blank form.

Are there any IDE's for PostgresSQL?

Windows 8 doesn't recognise my HTC Desire S when I plug it into my USB port and I've tried installing the USB drivers at different compatibilities and it still won't recognise it. The Device Manager recognises it, I've tried using the Device Manager to update the drivers but with no success...

I couldn't figure out how to adapt it to the format I wanted it in and when it tried the explained method it wouldn't update the records. If someone could find the same tutorial but for a A001 type format I'd be greatful.

It's for a new database being created, tested it and it does exactly what I was looking for. :rolleyes: Thanks for your response though, that'll probably come in handly later down the road.

Or, in the field properties in design view enter A000 into the 'Format' property and select increment in the 'New Values@ property. :D

C001 Custom Autonumber Is there a way I can format AutoNumber for a primary key, for example, have the first ID start as C001 then for the next entry Access will automatically go to C002, and so on and so forth?

The biggest kept secret to losing weight is to walk, walk everywhere!

Hi, I know how to create a form with a subform. However I am having difficulties creating it for this powertools database system. The system is based around customers loaning tools for a couple of days then returning them. I basically want the customers details in the main form and the tool...

I am currently having some difficulties autopopulating and filling in my subform.:banghead: (I'm using the 2007 version) Here's a link to the zip file with the database and the .txt file with the scenario. www(dot)fileconvoy(dot)com/dfl(dot)php?id=gaa237002f2b17ffa99919909493c16d44117e24c4...