Search results

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

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

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

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

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

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

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

the data below shows me what i have invoiced and what has been paid I am trying to return the net amount only if the invoice has been paid the 2 ways i have tried either give me all the same results ie net amount and exp1 even if the paid has not been ticked Expr1: IIf(Not...

hi, i have discovered that the sales people need to put a value or text in the feild called " intcoterms , i also see they have not been entering any date in that field also so i will default that to 0 what i am trying to do is add the "expr1" field value to the " sum of ordertotal field "...

hi , i have a sales form that has product numbers IE 1. FC1234M1 OR AB2345M1 which we are making and selling I Also have a stocklist form with all the parts to make any product we have now started to make extra products incase any go wrong for each order ie order is for 10 but we...

the form below shows me the 2 item i have purchased the middle sub form tell us what is received and in that form i tick the box " stock change " the form below that then changes the "on order qty" and the stock qty this is done by a query i have some vba that when i manually change the...

when i create a bill on materials the file goes into the first location i have listed which is my folder path \\192.168.2.11\contdocs\Engineering\material list in pdf now they want to move it to another location listed below \\192.168.2.11\contdocs\Engineering\Document libraries\approved...

my database covers 7 areas of manufacture, sales, engineering , purchasing, stores, quality , finance each person can log onto their own area with a password the backend is split away from the FE . there are about 60 tables, 100 forms, 120 quires , 20 reports of which i am trying to tide...

yesterday someone tried to open the form called stocklist ( button located along the red line ) and this error came up . the form has been open hundreds of times without a problem . after rebooting his computer it was ok again . i am trying to understand why this could happen . any ideas...

i am struggling to think how to do this the screen below shows a contract part arriving at the goods inwards then the stores man fills in the date the parts arrive , the qty received and the GRN number the inspector then has to complete the date parts inspected and if passed or not...

i would like to be able to stop people entering certain words within a sentence in the text field MaterialPUR. and warning them if they try to. the words for example are. drw drg drawing w room see screenshot below as an example thanks steve

Below is a form that changes the stock qty and allocation and stock balance in the yellow feild which is called update i put the qty i am taking out of the stores in this case 10 so when i have pressed the button " update allocation " this second form below shows that this has happened ...

this marco i found on an old database that records the date and time when the stockqty gets changed via the after update event so i thought i could do the same think on a new database but i cannot find the "setvalue" from the dropdown box can you please advise what i am doing wrong thanks...

hi , i have a table that stores all the records for 4 companies. it is possible to link that table to another access database but only the information from one of the companies not all 4 thanks steve