Search results

Hi there Should work no sorry :o

Hi Rural I have attached my database. The form i am working is the adding booking form and that is coming from the booking table. I just want the form to have the booking ID to have a auto number as soon as I open it. Shaf

Hi Rural guy I am using combo boxes. but the id number for the id auto id number is a text box.

HI Rual guy Yess the table primary is the auto number but it is not updating. Every time I load my form, the the text box is not reading the record in the table and not updating?

HI there rural tried Me.Refresh on dirty, no luck the fild within the table is a auto number but it does not refresh to the a new number. just keeps on one and there is already a one on the table.

I have created the table with the auto number but it does not update on the form automatically, how can i do this on the form? :confused:

Hi guys I have a problem with my booking form. On the table the number is a primary key and is a auto number now I have used this on a form but It does not update and find the next suitable number. I am using a text box. How would I make it update automatically on the form as soon as I...

Okey MR B What I will do is complete my version today. I am using text boxes and comand boxes mostly to add a customer and booking. I will finish the database and try and implement the code on mine.:o

Hi Mr B I have made somthing similer to what you have done, but using text boxes. I need to implment if . confirm if the place is available on the course • confirm how many places are available on the course selected How would you do that on your design?

I have three tables Course table CourseID Day Time Price Trainer Customer Table CustomerID Title Firstname Surname Address Town PostCode Telnumber Booking Table BookingID CustomerID CourseID The booking is the main table which is the relation with the the other two tables:o

Hi there I am creating a form with a combined three tables to do a booking course form for a customer. I have created a form for adding a customer and his course. I have to do the following but I am not sure how I do this, all I know is that I would need to use a dloopup but not sure how...

Thank you guys Got it working finally :)

Hi there What I am confused about is not getting the information into the correct text boxes eg text 1 = column 2 text 2 = column 3 For some reason I cant get this, I have followed what you have told me. I just want the Id number in the combo box and nothing else. :confused: Please see the...

Hi John Sorry, it has been along time, I had to sit down and go through it again, I have tried it, and igt only appears to read column 1 only. Why is this? I have tried column 2,3 and 4 and no luck Is it because I have relations with the tables. :confused: help I have attached my database...

Hi GalaxiomAtHome Do you mean Control Source. IS there a guide I could follow, it is very confusing!!!:confused:

Hi guys I want to use a combo to search for information. At the moment I am trying to find out how to do this, I have a combo box and three text boxes and what I want to do is select the ID number in the combo box and once the number is select in the combo box the text boxes will also...

Hi guys Any help plzzzzzzzzz :confused:

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...

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?

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?