Search results

  1. J

    Moving/Hiding Multiple Controls with VBA

    I am creating a new module for our company database to track project cost vs budget. Our system is set up with multiple cost lines, each containing various cost codes. However, not all lines will be used on a project. Typically only 5-6 lines, but I need to set the form up to use the other...
  2. J

    Select Query keeps changing to Union Query

    I have a query that I have created as a Select Query. It will work fine for a little bit, but keeps converting to a Union Query on its own and then gives an error "Syntax Error (missing operator) in query expression 'Tanks.'." This is driving me nuts. I've gone through the Design View when it...
  3. J

    Syntax Error Missing Operator

    I am attempting to perform a Dlookup to populate an unbound control with the following command: Me.txtad_Ship.Value = DLookup("[ad_Ship]", "[Tanks]", "[Job_ID] = " & Me.Job_ID) For some of the records, I get an error message of "Syntax error (missing operator) in query experssion '[Job_ID]...
Top Bottom