Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. needhelplol

    multi-select answer

    i have found a way of using a multi-select box, entering data into a database, and then pulling it back out into a from, hope this helps someone Private Sub Form_Current() 'Deselect old values Dim varItem As Variant For Each varItem In List8.ItemsSelected...
  2. needhelplol

    using a varible in a dlookup

    fixed it using nz() thank you for your help
  3. needhelplol

    using a varible in a dlookup

    some reason working now... but... every table returns then same result, in use or not
  4. needhelplol

    using a varible in a dlookup

    back where i started, canciled op error...
  5. needhelplol

    using a varible in a dlookup

    lol good point will give a progess report
  6. needhelplol

    using a varible in a dlookup

    qbooking = SELECT Booking.BID, Booking.Date, Booking.Status, Tables.Table1, Tables.Table2, Tables.Table3, Tables.[4], Tables.[5], Tables.[6], Tables.[7], Tables.[8], Tables.[9], Tables.[10], Tables.[12], Tables.[13], Tables.[14], Tables.[15], Tables.[16], Tables.[17], Tables.[18]...
  7. needhelplol

    using a varible in a dlookup

    also in the Table!Tables, my Table1-37 are yes/no's
  8. needhelplol

    using a varible in a dlookup

    qbooking = a (access) query (bid, date, status(if table is open,paid etc), then table1-table37) first three items come from table called Booking and the rest from Table called Tables link by bid hope that helps
  9. needhelplol

    using a varible in a dlookup

    some good reading, made a start... tried your answer, renamed my field names to 'Table1-Table37' (made sense as to how you put it) rather than just 1-37 but now get a cancil prev operation error, any ideas? i don't see what would make that error thank you for your help
  10. needhelplol

    using a varible in a dlookup

    Thanks but the problem is i have 37 checkboxes, and don't want to write the code 37 times, sorry i missed a bit on my last post check = DLookup(box, "qbooking", box & "=yes") so hoping for . dlookup ( varible, "QUERY", varible = "YES" ) thank you for the quick reply
  11. needhelplol

    using a varible in a dlookup

    i don't know if this is possible in vba, to help here's a bit of background, i'm trying to creating an access replacement for a paper based log, so to speak, for a restaurant, i have a few tables, forms some with sub forms and some querys. one sub form has checkboxes to represent tables (based...

Part and Inventory Search

Back
Top