Search results

  1. N

    2 fields in combobox, how to access one of them ?

    but where do you specify the combobox name ?
  2. N

    2 fields in combobox, how to access one of them ?

    yes thats exactly what I meant , thnx alot for the help . :)
  3. N

    Update fields dynamically?

    Thanks alot for the help guys, I am almost getting it to work ! :)
  4. N

    2 fields in combobox, how to access one of them ?

    hallo there , I have a combobox build upon a query, with 2 fields inside , how can I access one of them ? thnx in advance
  5. N

    Update fields dynamically?

    first thnx alot for the help guys! and... here is the problem : "Use the WHERE stament to populate the next listing in accordance to what was selected within the first combo/drop down list box. " how can I do that ?? I mean how can I update the query after the AFTER update thnx again guys
  6. N

    Update fields dynamically?

    hallo there .. I have the following problem : I have 3 tables tblShow: SHOW_ID FILM_REF SHOW_DATE SHOW_TIME SHOW_SEATS SHOW NO -------------------------------- tblBooking BOOKING_NUMBER MEMBER_REF SHOW_ID BOOKING_DATE BOOKING_SPEC_NO --------------------------------- tblFilm FILM_REF...
  7. N

    dynamically update the fields

    hallo there .. I have the following problem : I have 3 tables tblShow: SHOW_ID FILM_REF SHOW_DATE SHOW_TIME SHOW_SEATS SHOW NO -------------------------------- tblBooking BOOKING_NUMBER MEMBER_REF SHOW_ID BOOKING_DATE BOOKING_SPEC_NO --------------------------------- tblFilm FILM_REF...
  8. N

    VBA & SQL error

    :( I think I've annoyed you to much already ! the good news is the error msg changes, the bad news is , still giving me error . now its telling me "you cancelled the previous operation" (am I the only one getting these funny error msgs?) thnx again
  9. N

    VBA & SQL error

    hallo again (thnx alot for the help btw). well , the thing is , I've just added 2 diffrent msgs in the if - else statment just to check if its working. but it would not get that far, it would stop at the : rst.Open _ Source:="SELECT query1.status" & _ " FROM query1" & _ " WHERE...
  10. N

    VBA & SQL error

    the same thing happen still the same error ... (Me.SHOW_ID.Value is a reference to a combobox value (but this is the right way of doing it , I hope)) :( Do you think there is another way of doing it ?
  11. N

    VBA & SQL error

    hallo guys, look I am not the guy that usually bug others, but I am now in a state where I need to ask someone for help .. I have tried several methods to solve this problem, but with no result. anyway the problem is like this : When you press the button add in the booking form the onclick even...
Back
Top Bottom