Search results

  1. N

    Question

    ok that makes sense thanks
  2. N

    Question

    ok so my next question is how dio i handle the fact that my items are sold on auction so there isn't a selling price until the auction ends and I don't know what it will be until then?
  3. N

    Question

    PNGBill: I was using the sample database you posted to total out the orders and I'm trying to figure out how to do the sales tax... I only charge sales tax on products sold to New Mexico residents How can I calculate the sales tax if I need to charge it?
  4. N

    Question

    scratch that I figured it out... which means I should be able to fix that part of all the forms... Keep your fingers crossed!
  5. N

    Question

    ok I don't know what happened but the customer id in frmCreateInvoice isn't autopopulating... I was already having problems with this sometimes it seemed to work but not always.... which I don't understand how it can sometimes work correctly
  6. N

    Question

    that worked great! thanks!
  7. N

    Question

    ok now i'm working on the frmRecordPymt... i need the dropdown for the orderID i need to autopop the customerID and the orderdetails also on frmAtAGlance in the invoiced section it is showing the order more than once... I only want it to list orders thatbhave an OrderStatus of Invoiced once
  8. N

    Question

    ok I think I fixed it....
  9. N

    Question

    i'm on frmCreateInvoice yes I removed i believe all lookups in the tables although i have to admit I don't remember putting them there in the first place. there isn't a lookup on OrderID in tblOrderDetails or tblOrderHeader which is where the orderid is being pull from
  10. N

    Question

    I double checked to make sure everything was updated and it is... i am getting a message saying the combo box for OrderID is bound to an autonumber field
  11. N

    Question

    did you have to make any changes to the forms? I didn't see where the changes in the queries would affect the forms since those queries are just for the summary page.
  12. N

    Question

    most items sell for 0.99 or 1.00 but they do occassionally go for more I wasn't sure how to handle the fluxuating selling prices so I just left it out of the inventory table the PoductCost is my cost for each item.
  13. N

    Question

    now I can't create the invoices frmCreateInvoice when I try to select the order ID it doesn't change... any idea's it was working before...
  14. N

    Question

    Hi ok i made the adjustments and am entering more information to test it Thanks again....
  15. N

    Question

    thanks so much y'all I am going to start making the adjustments you have suggested and i'll be waiting you additional comments thanks again i appreciate your help so much
  16. N

    Question

    oh the picture in the inventory....
  17. N

    Question

    i have no idea I haven't used anything later than 2007 it is a refusal
  18. N

    Question

    it won't let me it says It uses freatures that are required and not avaliable in later versions of access
  19. N

    Question

    ok here is what I have so far... Test it and what not sometimes it works the way i want it to sometimes it doesn't so see if you can see any problems because I can't find them....:confused:
  20. N

    Question

    ok i'm almost done but now i'm running into another problem and I haven't been able to find a solution but i'm not sure what to call the problem either. When I enter the price as 0.99 it rounds it to 1.00.
Back
Top Bottom