Search results

confused as to why i get 6 results yet only 5 in table and form STOCK NUMBER gt2920 HAS 5 transactions the line numbers are 18.19.20. 24 and 26 the table also has 5 transactions yet the results in the query has 6 ,, line 18 in twice any idea what could be wrong ?? Thanks steve

Private Sub cmdEmail_Contact_Click() Dim strTo As String Dim strSubject As String Dim strMessageText As String Dim strCc As String Dim strBcc As String Me.Dirty = False strTo = Me.[EmailAddress] ' strSubject ' strMessageText ' vbNewLine & vbNewLine &...

Private Sub cmdEmail_Contact_Click() On Error GoTo Err_Handler Dim strTo As String Dim strSubject As String Dim strMessageText As String Me.Dirty = False strTo = Me.EmailAddress strSubject = "" strMessageText = "" ' Me.[Firstname] & ":" & _...

SELECT Now()+91 AS EndDate, [Order Details].ProductNo, Stocklist.allocation, Types.Type, Stocklist.StockNumber, Stocklist.Material, Sum([Order Details]![OrderQty]*[Product Detail]![ProductQty]) AS ReqQty, Stocklist.DeadQty, Stocklist.StockQty, Stocklist.BpQty, Stocklist.PendingQty...

i have changed the first screen shot to total and this now takes me into design view again so i can keep testing but the second screen shot that uses the first screen shot but still wont let me into the design view / so i dont know how to change it steve

hi for some reason these errors have appeared on 2 of my queries and i have no idea why the first screen does use the second screen . but this is where i am testing different ways of doing things , the strange thing is they did work so i must have now done something wrong thanks for your...

thank you . below seems to be working

thanks but i need to explain more the sales order is for part "NS2782M1" see attached order {this is a text field ) this is an assembled part which has a bill of materials attached to it see screen shot 2 you can see the product number and the qty required to produce that product in this...

i am struggling with a formular and would like some help the 3rd screen shot shows a orderqty for 10 to a batch no "pco00001" which is unique and there is a tick box when that line item is shipped the first screen shot shows how i get the total quantity for all orders for that part (...

this managed to do it but i think it could be made smaller ? diffqty: IIf([SumOfqty allocated] Is Null,Round([StockQty]+[OnOrderQty]+[PendingQty]-Sum([Order Details]![OrderQty]*[Product Detail]![ProductQty]),4),Round([StockQty]+[OnOrderQty]+[PendingQty]-[stock allocation Query]![SumOfqty...

i tried that but got this error diffqty: IIf(isnull([SumOfqty allocated],[diffqty1],Round([StockQty]+[OnOrderQty]+[PendingQty]-[stock allocation Query]![SumOfqty allocated]-Sum([Order Details]![OrderQty]*[Product Detail]![ProductQty]),4))

i am trying to create a formular that allows me to add the allocated stock into it but struggling , at this time it looks at what the order quantity is minus what's in stock . what's on order and and tells me the quantity to order. IE DIFFQTY1 in the sceenshot below tells me i am minus...

Now i have managed to create the P/O and use the code below to send it to the supplier. but i have been told they send a word document with the order . this document is called " api conditions of purchase" could that be added to the code so it fetches It as well when sending this P/O thanks...

just to give you more information they use word and excel to do purchasing and stock input/ out put , i have been asked to make one system for them Which includes sales, finace , stores , QA , purchasing ETC . so still a lot to learn . this is there SUPPLIERS P/O i have used as a sample to mine

yes, but could i use the same stock number but put with a different description in it , albeit on different purchase orders ?

"Can you have Stock for sale that does not have a StockNumber??" i agree with this , if you are selling something then you do need a stock number. if you are purchasing something regular from the same supplier then yes allocate their stock number to that part

if you want to buy a piece of wood why do i need to have their stock number. i dont , all i need is what i want , say 3 x3 x 1000 soft wood if i sent this to many supplier for a quote i would not need all their stock numbers. . so as suggested before i just can have a dummy number and give it...

i am a little stuck and am looking for a idea how to get out of it .. this purchasing form selects the part via the stock number from a stocklist of about 5000 items and puts the cost and the material information in . all works fine but if i want to buy say a piece of wood or a paint brush...

i have 18000 parts on the system and maybe 500 suppliers

but can you just list see 1 or more supplies of any part. ? i am thinking if you are new to the company i am showing you what suppliers to use