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 SkipVought 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: *

  • Users: ProdS
  • Order by date
  1. ProdS

    Multiple query criteria in form

    Thanks, but i tried that last one but it didnt help, if i selected nothing in the form, it successfully showed all records, but not when i made a specific selection, it still turned up no results, I'll try it again though
  2. ProdS

    Multiple query criteria in form

    all my objects are unbound though, there is no record source in the form
  3. ProdS

    Multiple query criteria in form

    Sooooooo close!! I opened the form and selected one and bingo! it worked! But when i closed the result table and clicked on another selection, the error "You cancelled the previous operation" came up. What could be causing that?
  4. ProdS

    Multiple query criteria in form

    WHERE ((([Arrivals/Departures].[Plane ID])=[Forms]![advflight]![plID]) AND (([Arrivals/Departures].[Gate Number])=[Forms]![advflight]![gate]) AND (([Arrivals/Departures].[Arriving From])=[Forms]![advflight]![arriving]) AND (([Arrivals/Departures].[Date of Arrival])=[Forms]![advflight]![darr])...
  5. ProdS

    Multiple query criteria in form

    same thing again, no records in my query There definetely should be, i tried multiple values in all fields but i still got no results However, when i entered data into the form which was exactly the same as one record in my table, it successfully showed that one. Not sure if that helps.
  6. ProdS

    Snychronizing Folders

    I'm not sure, but doesnt Microsoft Briefcase do something like this, correct me if im mistaken
  7. ProdS

    Multiple query criteria in form

    No luck, i get a "You cancelled the previous operation" error, when i debug, it highlights Private Sub Command29_Click() DoCmd.OpenQuery "advflightsearch" <--whole line highlighted Me.arriving = "" Me.gate = "" Me.plID = "" Me.departing = "" Me.darr = "" Me.ddep = "" Me.Airline = "" End Sub
  8. ProdS

    Multiple query criteria in form

    Thanks, but i tried that last one but it didnt help, if i selected nothing in the form, it successfully showed all records, but not when i made a specific selection, it still turned up no results this is what i have in the form Private Sub Command29_Click() DoCmd.OpenQuery "advflightsearch"...
  9. ProdS

    Multiple query criteria in form

    Hi, I am currently doing a database project for school. I have a form called "advflight" which has 2 list boxes, 2 text boxes and 3 combo-boxes. The problem is that when i select one value from a box to be my criteria, it accepts all the other values as nothing, therefore returning no results...

Part and Inventory Search

Back
Top