Search results

thank you . now works great

below is the query i run and it gives me this result for this part number which is correct ie "issued to the shop floor" yet when i select another part number it says " purchased " yet it should be the same as the first one steve

i am still confused . so just to make it more interesting , i go to B&Q and buy paint , wood etc etc . i then go to a supermarket and i buy other things and put them in stock how do i calculate that in my year end if there is not a currency field in every part number in stock ?

i agree with that but see below how do you know if these items in stock that are for orders or not what currency they are in so i can do my year end cost ?

they are interested how i will do the stocktake calculation thats why i ask should all the stock be in pounds ot in all of the currencies and how do i show that on the stocklist what currency it is in if i need to do that

My stocklist which could be 5000 items can and does include ,say soap, pens , pencils, gloves , paper , etc etc The p/o does include the transport costs etc see raised p/o so should the item i am purchasing in the form i an creating always be in pound or the correct currency . if in pounds...

firstly we always get a quote on the order before Placing that order so we know the costs / total costs and i know have 2 ways to try and deal with the stocktake list 1. always put the quote price in the P/o table in their currency then no exchange rate is needed for the p/o i send to the...

hi i have a Dilemma and i am not sure which way to go so lets say i have 3000 stock items sample below , anyone of these items could come from any country in the world . lets say the first 2 items i purchase from one supplier in england, the next 3 in europe and the last 5 in china so i...

"if you want one procedure to call three other procedures then yes." ok , i have done the above today i see it could go wrong for me if for some reason the report was wrong yet i have put it to the file and sent it to the customer could the code for the "cmdOpenInvoice_Click" be modified to...

these are the 3 codes i use should they be put them into one of which i would struggle to do or just call up the 3 Private Sub cmdEmail_Click() Dim strTo As String Dim strSubject As String Dim strMessageText As String Me.Dirty = False strTo = [Order Details...

at the bottom on the first screen shot there are 3 buttons i use to open acknowlegement , send it to a file , and send it to the customer i am now trying to adda button to carry out all these tasks in one go but i dont know how to call them up having tried a few ways. the code at the bottom...

Managed to look at this again , this is working good ok now , had to do a couple of changes albeit guess what i was doing. thank you for all your help , as it was said much easier that it closes the order automatically steve Me.Parent.Refresh Dim rec_count As Long, ship_count As Long...

below is my order and order details screen. there are 3 products required for this order. i have discovered that the "order shipped button is sometime being pressed before all 3 products have been shipped. these could be shipped at different dates when the order shipped buttom is pressed the...

ok . i dont want to get into problems later so i am not sure what i should change them fields to . should it be decimal ? can you round formulars ie =[qtyrecd]-[qtyreqd]-[rejected] steve

i am not sure if this can be correct or not but it seems to be working although i did change the qty just to check before the feild size was single

hi , i am confused as to why i get strange numbers when i put numbers after the .dot for example below you can see the quantity reqd is 150 .439, i have had 2 deliveries booked in 103.439 and 47.00 which now equals the reqd qty the field in yellow should show 0 and the conditioning...

hi this is some code someone helped me with a long time ago, and i am trying to go thro all the codes i have been given help with to try and understand how they work for future this code works great but i am total confused how it gets the oldvalue as i have no feild anywhere calling it up...

although i think not a good way of doing it but i used another 2 queries and put a subreport into my report and it worked

this is the sales header and sales details forms both have seperate tables this is the product and Bill of materials for each product also showing is the stocklist form all 3 have tables this is my purchasing form and header for any item is require to make the sales products both...

in the last few weeks i have tried to create an invoicing module within my database this is the report i have been trying to create to see if it all works ok or not below the are 3 orders of which you can see the first one there are 3 line items to invoice of which the system says i have the...