How to confirm if a place is avilable on form

[steven low]

Hi guys

I have three tables course table, customer table and a booking table.

Booking table is were I book the course for the customer.

Now what I like is:

• confirm if the place is available on the course
• confirm how many places are available on the course selected
• show if the customer has already booked a place on the course

is this possible on the booking form and if so is there a guide I can use or any help. I would think this would be done on a form?

Thank you

 

[pbaldy]

You can either use recordsets or DCount() and DLookup() to get the number of people signed up for a course from the courses table, the total available from the courses table, and whether a specific customer has signed up for a course.

 

[steven low]

HI pbaldy

The DCount and Dlookup look as if they need to be done on queries.

I feel this would be the easiest as I am creating a project for my A level.

Do I create a Dlookup and Dcount on a query form or can I create it in m current booking form?

 

[pbaldy]

The domain aggregate functions can be used pretty much anywhere, not just in queries. In a query, I'd be more likely to use a subquery or a join to a totals query that totaled up people signed up for courses.

 

[steven low]

I will try and implement this.

Is there a guide I could use to do this, I am abit confused if I can do this on a form or not?

 

[pbaldy]

I don't know of a guide for this specific task. Here's one on domain aggregates:

http://www.mvps.org/access/general/gen0018.htm

but there are many ways. In a form, you can use If/Then logic and the domain aggregate functions (or a recordset) to get and compare the applicable values and take the appropriate actions.

 

[steven low]

Hi guys

I am really having a problem with these D count and dlookup

I have three tables

the booking table is the main one to book

I want to do the following on my form.

I have done the following =Count([bookingID]) which shows the total number of courses on the course, but I want to show how many are remaining.

and in txtbx2 I want to confirm if a place is avilable on the course as longs as its less then 20 and a text box to confirm



• confirm if the place is available on the course
• confirm how many places are available on the course selected
• show if the customer has already booked a place on the course

 

[axl gullen]

i've gotta do the same thing but have no idea how to do it
any help???

 

[steven low]

Hi guys

Any help plzzzzzzzzz