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 TouchToneTommy 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. brendageorge

    Need Help with Macro

    How can I create a macro (or Code) to automate a filtering of a form. I found how to do this by picking advance filters but need to make this easier for users. My form name is Order Details and the field I want to filter is Customer ID. Any help will be appreciated. Thanks
  2. brendageorge

    Help with invalid syntax

    I have this expression: = IIf(forms![Order Details]![Line]=[Oakhill Sq],then [Unit Price]=DLookup("[Price]","[Oakhill Sq]","[Product ID]='"&[Product ID]&"'")) It tells me that expression contains invalid syntax. What have I done wrong?
  3. brendageorge

    #Size! error

    What does this error mean?
  4. brendageorge

    Automation of number on Estimate Form

    I have a table named tblEstimates, a form named frmEstimates, and a field named Estimate#. How can it get the form to automatically assign a new number to each new estimate? In case you need to know the form has a sub form in it and the parent/child link is the field Estimate#. Thanks for any help.
  5. brendageorge

    DLookup in access 2010 help

    I have a subform (Estimates1) in a form (Estimates) that I am applying the DLookup to data source. =DLookUp("[Price]","[Oakhill Sq]","[Product ID]=[Me].[Product ID]") I am trying to find the price in table Oakhill Sq that matches the Product ID on my subform. It returns #Error. What am I doing...

Part and Inventory Search

Back
Top