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 Mike Lewis 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. qad122

    Help with performing a calculation on a form

    Darrylle, Thank you! It worked...and I am smiling! -Susan
  2. qad122

    Help with performing a calculation on a form

    Hey Darrylle, I have the following on the footer of a form: SubTotal = frmsalelineitemsubform.Form!SubTotal Shipping Costs = [SubTotal]*0.1065 Tax = [SubTotal]*.065 Total Due = [SubTotal]+[Tax]+[Shipping Costs] Everything works great, when I have shipping costs. However, I have a check box...
  3. 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...
  4. qad122

    DLookup Question

    You are exactly right. I had the code in the default! Duh!!! It took me all day to figure that one out. -Susan
  5. qad122

    Subform HELP

    Hey Ken, I didn't see your post, so sorry for the next question that I posted. I thought about doing a select qry on it, and will see if that works. I already have a qry for the product and sale line items. The problem that I was concerned about is that I have a combo box(for Prod ID and...
  6. 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
  7. 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] &...
  8. qad122

    Subform Help

    Hey Rick, Sorry for the "typos", but I do have the correct sequence in my database. I don't know if this helps, but I do put a requery in, and I am thinking that the subform just needs to possibly refresh itself? I have no idea...
  9. qad122

    Linking 2 Subforms to a Main form

    Richard, Thanks, that suggestion worked great! -qad122
  10. 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] &...
  11. 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...
  12. 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