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 derfloh 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. DarthLink

    DoCmd.OpenReport not using given Where Condition

    There is a Detail_Format function in the Report. It loads an external picture into an Image.
  2. DarthLink

    DoCmd.OpenReport not using given Where Condition

    They're numeric - good catch. I always do that. Removing them doesn't fix the problem though; it's still not running the Where Statement.
  3. DarthLink

    DoCmd.OpenReport not using given Where Condition

    item_no and Serial_no are both integers. The complete code: strSerial = "[item_no] = '" & ModelNo & "' AND [Serial_No] = '" & Format(SerialNo, "0000000") & "'" MsgBox (strSerial) MsgBox (Grpt) DoCmd.OpenReport Grpt, acViewPreview, , strSerial ModelNo, SerialNo, and Grpt are defined earlier...
  4. DarthLink

    DoCmd.OpenReport not using given Where Condition

    I am. It's ignoring it, or simply not using it. That's the problem; sorry if I forgot to mention that.
  5. DarthLink

    DoCmd.OpenReport not using given Where Condition

    This goes to a Report, Filter is blank, and FilterOn=true
  6. DarthLink

    DoCmd.OpenReport not using given Where Condition

    I was given the task at my office of porting data from an Access Database into our SQL Server while keeping the data linked to an Access Project to use the forms already written. This I have done, but in so doing created several problems in the code that I have not been able to quickly...

Part and Inventory Search

Back
Top