Search results

Re: Shipping Calcuations so you use a continuious form or data sheet view? How do you filter it? the size of my DB is already huge (at least in my opinion and I don't even have all my stock entered in and it is already at over 600 records) now i realize that is not a lot in comparison to...

thanks for all the input.... how about the inventory flow question.... What are your thoughts on that?

Re: Shipping Calcuations oh that is not a problem I understand! I have a dentist appt tomorrow also so I feel ya... and I understand between tasks since I work on this between 4 girls ages 10 years to 6 months running around on summer vacation... no you don't NEED to i am just looking for...

Re: Shipping Calcuations ok i'm pretty sure I fully understand all this.... Thanks for taking the time to explain it.... Also what did you think of my explination for my frmCreateInvoice from my post on totaling a subform earlier? I want this DB to be as "correct" as possible I have used...

Re: Shipping Calcuations lShippingRates ShippingRateID - Autonumber (PK) ProductID - Long Integer (FK) ShippingRateBase - Currency ShippingRateAdditional - Currency what would be the best way to identify the type of product? Should I have another table with the types of products? right...

Re: Shipping Calcuations Ok I'm pretty sure I follow you in all that.... and you would call this function in the form? also Would i need to build that actual query or is that what that function is doing is building the query

Re: Shipping Calcuations I was thinking should I just implament the shipping that varies on the product now to save my self the hassel i'm sure it will cause it to have problems in the future...

Re: Shipping Calcuations I'm sure it isn't especially since I know some PHP... Yes i'm willing to learn I just worry that I come across as a complete idot and that I shouldn't even be messing around with it

Re: Shipping Calcuations oh heavens I have never even touched codes like that.... I have tried to do everything I can to avoid it.....

Re: Shipping Calcuations That is good to know because as I expand my inventory to include other items they very well may need to be charged shipping differently mental note for the future

Re: Shipping Calcuations ok so how would I do that calculation dependent upon the method that is picked I have another choice that is $6.50 for the first and $0.25 each additional could I use the field names in place of the numbers?

Re: Shipping Calcuations Oh ok I see like with the sales tax from earlier for historical invoice purposes

Re: Shipping Calcuations ok so I was close.... I don't see a need to store the amount just the method..... this would be best hadled by a table right tblShipping MethodID(PK) MethodName MethodStartFee MethodAddFee Something like that right? no not as of right now but i'm sure it is...

I'm not sure if this is the right place for this post... If not i'm sorry! $2.00 for first item $0.25 for each additional these amounts are variable depending upon the shipping method picked How would I calculate this I'm thinking with a count of the items.... Maybe?:confused:

i could only hope to be as knowledgeable as you all are but i will feel great satisfaction if I can get my database to do everything I want it to!

oh i know it isn't really a quirk.. it is more a secret thing you (or at least I) have to fight with for days before you (I) get the duh feeling! I also am glad there ar so many of y'all who know what they are doing to helpout folk like me who want to know how! I appreciate the way you all...

I didn't realize that the Name in the properties wouldn't be the same as what I saved the form as.... I made a note of this tid bit in my notebook of things I consider quirks in access LOL! It is fillin up fast!

Bob, I am still looking forward to your review.... If there is any simpler way to do this I am all ears simplicity is my middle name!

That was it! I got it thank you! how silly of me!:eek::D

This form is the form that actually creates the data in tblOrderDetails. I thought I had done this right cause it is pulling the information I wanted it too... You select the order number and then it uses the customerID from tblOrderHeader to pull the customer information (strictly for...