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

  • Users: qad122
  • Content: Threads
  • Order by date
  1. qad122

    Help with performing a calculation on a form

    On a mainform for a Sales Order, I calculate the Subtotal, Shipping Costs and Tax. For the shipping costs, I have a code that states if there is no shipping, do not make shipping costs visible. However, it still charges for shipping. Any ideas on how to write a statement saying to NOT...
  2. qad122

    DLookup Question

    Why would a DLookup statement cause a #Name? on the next row of an order entry, and that next row is blank? Susan
  3. qad122

    Subform HELP

    I have a continous subform that lists product name, unit price, qty, and extended price. I have a combo box set to the product name, and I have a default value on the Item Unit Price (=DLookup("[ProdUnitPrice]", "tblProduct", "[ProdID]= '" & [Me]![ItemProdID] &...
  4. qad122

    Subform Help

    I have a continous subform that lists product name, unit price, qty, and extended price. I have a combo box set to the product name, and I have a default value on the Item Unit Price (=DLookup("[ProdUnitPrice}", "tblProduct", "[ProdID]= '" & [Me]![ItemProdID] &...
  5. qad122

    Linking 2 Subforms to a Main form

    Here it goes, and I shall try to be as descriptive as possible. I am new at this access game, and am presently stumped. I have a main form(Sales Order Form) with a combo box that is a sales query with the fields of SaleID, SaleCustID,etc). I have two subforms on the main form. One is the...
  6. qad122

    Unique Autonumber Design

    I want to create a unique customer ID number consisting of the first four characters of the customer's last name, and then 4 random numbers. It is driving me crazy. I have been successful in creating automatic sales ID, and product ID with the DLookup function. Any suggestions? thanks, Susan

Part and Inventory Search

Back
Top