Search results

the quote is sent to he customer then if he agree I send them an order, sometimes I don't need to raise a quote just the order. and some times the order will not always reflect the quote the subforms are parts from the stocklist that I will quote on and also sell . but sometimes I...

hi I am unable to open the file .it is I think because it says its a PHP ext steve

hi In my forms quote and orders I have subforms these subforms fetch parts from the stocklist when I select the productno the material comes with it ( all good) what I want to try and do is not limit the productno or material to the stocklist when I try to changed limit to list to "no" it...

hi , I have a form called "stocklist2" I also have a table called " allocation" I want to put a field in the stocklist form that looks for the material in the "allocation" table. sums up the " qty allocated" from that table and returns that value in the stocklist form. the field in...

ok , thanks for you help steve

hi , I have tried to do something like that. by trying to copy examples but failed. and help appreciated steve

hi , thanks for your help it seems to be working great. I just had to reset the link master in the orders form because all records where going to all the orders. I really appreciate your help. I have posted another issue I would like to solve on the forms forum with a different...

hi I have a table called stocklist and a table called stone type the stocklist could have many parts the same but a different colour/type at present the user has to look thro many records to select what he wants I have been asked if it possible to have the stonetype list come up then...

hi, this is the formula In my query Unit price: [itemcost]*[exchangerate] I would like it to also have the discount taken from it . the field name is discount , but I am not sure how to put that into my query. it is a percentage discount any help appreciated steve

hi, thanks fo all your help but I am struggling I have attached a sample copy of my database. if possible I would like quote number 2 ( id number) to copy to the order form and this would be order no 1 ( again id number) as quote no1 did not become an order thanks steve

hi , re the append idea. in the quote form the quoteid is the quote number, this links to the quote to the quote details in the order form the ordered is the order number and this links to the order details so I am not sure how to overcome this. I can append both the quote and quote...

hI, The first form is for quotes, and the auto number is the quote number . the form quote had the customer, date etc details the form orders had the part details if we get the order I want to just copy the details over and create the order number and be able to modify and piece of...

hi yes , copy and paste both form and subform

hi , I have a form called "quote" and a subform called "quote details" I also have a form called "orders "and a subform called "order details" is it possible to press a buttom and copy the form I am in in "quote" which includes quote details to a new form in "orders" and order...

hi , thanks for your help I have managed to sort out how to make it work on another form now. I have been asked if it is possible to have 3 costs per part up to 5 parts cost "x" 5 parts to 20 parts cost " x1" and above 20 parts cost "x2 " then depending on the qty I want to buy or sell...

hi thanks for all your help on this it seems t wrking fine now , I did manage to change the it to the quote form I have tried to replicate what you did without success on my purchasing form using date2 on that form, I got the costs in but they are still using the date from the quote form...

hi , I have managed to get this working so far but I have got a problem the costs do not come on the next quote I raise I have to wait until I raise the order, can we get it that the costs come when I raise the quote thanks steve

hi yes it was related to it. the idea of the new table was the correct method but did come unstuck with this part please see the form sales orders it has the subform in it where I need the costs thanks steve

hi I have attached a sample of my form and tables the form " order details subform" does let me edit and add, but when the product cost table is attached attached " see copy of order detail subform" I cannot add or edit . but I need to unless there is another way to get the cost into the form...

hi , I have a form that is created by a select query and all is working ok and I can add or change data in that form I have now created another table and put it into the select query and it runs ok and gives me the results I need but the problem is I cannot now add or change any data in...