Recent content by steven low

  1. S

    Not updating auto number on form

    Hi there Should work no sorry :o
  2. S

    Not updating auto number on form

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

    Not updating auto number on form

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

    Not updating auto number on form

    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?
  5. S

    Not updating auto number on form

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

    Not updating auto number on form

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

    Not updating auto number on form

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

    Please help with form

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

    Please help with form

    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?
  10. S

    Please help with form

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

    Please help with form

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

    Combo box to fill in text boxes

    Thank you guys Got it working finally :)
  13. S

    Combo box to fill in text boxes

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

    Combo box to fill in text boxes

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

    Combo box to fill in text boxes

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