Recent content by rainbows

Pat, if he enters the stock qty and clicks of it , it changes the table so if he needs to change it back I will see what he has done. SO NO i was not thinking of backing out of it. you are correct it should not be string steve

thank you I have changed it to long not sure where to put this part Select * from tbldatachanges Where Type = 'Resin' within the code steve

Private Sub StockQty_AfterUpdate() Me.DateModified = Now() Dim OldValue As String Dim NewValue As String Dim MaterialID As Double MaterialID = Me.MaterialID OldValue = Me.StockQty.OldValue NewValue = Me.StockQty DoCmd.RunSQL "INSERT INTO TblDataChanges ( Materialid, ChangeDate, ControlName...

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...