Search results

hi, I previously created an order form which contained a combo box that when a "customer" was selected their address details would be automatically appear in textboxes on the form, it also cloned the customers address details into a series of Shipping address information textboxes with the...

Hi, i have my inputmedia record source set to a query called Order Details Extended in which there is a column with the following in it: ExtendedPrice: CCur(InputMedia.iCostPerUnit*[iQuantity]*(1-[iDiscount])/100)*100 which is fine, but im trying to find a way to enable price modification so...

ok, So on my orders form i have loads of fields which all addup like so: Subtotal: =Nz([txtCC])+Nz([Subtotal])+Nz([Subtotal2])+Nz([subtotal3])+Nz([Freight])+Nz([delivery cost])+Nz([consignmentcost]) VAT: =Nz([Total])*0.175 Total: =Nz([Total])+Nz([VAT]) now the Nz() bit i was told would...

On my order form i have 4 command buttons, 3 for dates and 1 for a notes section. i have some code for this, but it seems when i enter data in the new form / calendar a new entry is created in my Orders table when it should be part of the order being entered. this is the code i currently am...

Hey, My company have a set of default prices for each of their services, however these prices can vary per customer. Clearly i need to incorporate this feature into my database and ive thought of a few ways and im pretty sure the following way is the most efficient. I plan on Saving the Order...

hey, i have a customer form which includes a "Country" combo box.. the reason i did this is because i have a separate table with a list of countries and their VAT (Value Added Tax, you americans call it sales tax i think :)) rates. i want this country saved in the customers table.. i need...

Hi, Ive set up a command button on a Client List form which is supposed to email a client a specific invoice. I have a few questions tho regarding this service.. i would try it myself but i have a dataless database atm :) If i want to send a client a particular invoice by email and i click...

Hi, i am currently making a database for my company which will take care of the invoicing ordering and any other aspects.. i was making good progress until my manager mentioned to me that theres a special ordering number system that they want to keep and want me to incorporate into my...

hi, In my Orders form i have a combo box which determines where the order will take place. There are only 2 selections atm as we only have two sites.. What i need this combo box to do is instead of saving "Gatwick" when it is selected i need it to replace it with GWO- as this will be combined...

Hi, On my Ordering form i have 3 subforms that each have a different table and different products within those tables. I was wondering if it is possible to get the values from these tables (so that they act as default values) but if these values need to be modified, can they be saved to a...

Hi, I have a form in which orders are placed. Each product we sell has a set value, however this does sometimes change depending on the client. What i need is to enable my db users to change the value for the unit price of a product in the form without the original value in the table changing...

Hi, Im trying to make my checkbox have a value of 10 so that when it is checked it adds £10 to my total.. Ive searched the forums and read 20 odd threads but they didnt seem to be of any help.. my checkbox is linked to a yes/no field called congestioncharge in a table called orders. ive...