Search results

i have my database of which you all have kindly helped me with . it had about 30 tables , 40 forms , they will be 7 people using it i have split the backend away and put a copy of the front end to each laptop . although there is a button for them to get at there own department and maybe on...

thank you , all working great

i was a liitle confused when i put the either currency , decimal ets . when i put currency it put the £ sign infront of the number so thats why i put decimal or am i doing it wrong? thanks steve

thank you to everyone this worked ok you may also try Decimal data type and Scale = 3. steve

sometimes the allocation could be 0.001decimal places and now if i click on that field the same number appears but when i click of it it goes to 1

i have just noticed a strange number in my allocation field ""9.999999E-0" yet in other records it seems to be ok i have took a screen shot of the table . to see the properties can you please advise what i have not done correctly thanks steve

thank you for your help and great advise steve

am i not correct in making the material a number field in product details so it can link to the materialid in the stocklist ? then use the combo box to give the materail description

stocklist table there are 96 products and each product has a Bill of materials attached to it . i select the materail from the stocklist then that populates the stock number , product ID and i enter the qty required for that product

i am confused as to which is correct because i have been told many different things please see below you can see i have linked stocklist MATERIALID to Product detail Material some tell me this is correct some tell me it should be Material to material which one should it be and why...

i am sorry i posted the last post befpre i read yours yes it was set to NO i set it to yes and all is great thanks everyone steve

DELETE [stocklistapic].* FROM [stocklistapic] LEFT JOIN [stocklistnew] ON [stocklistapic].[StockNumber] = [stocklistnew].[StockNumber] WHERE ([stocklistnew].[StockNumber] Is Null) the query is showing the records but not deleting the steve

thanks , i am getting this error , but what i dont understand is created the database so i cannot see why this would come up??? as i can delete , tables, records etc

i am trying to delete records from a table called stocklistapi which had about 6000 records . the other temporary table is called stocklist new i have 600 records in that how can i delete the records is stocklist api that does not match the records in stocklist new . using the field called...

i have just noticed that the approved date is different on the 2 forms , one is numbers and the other is the date. what can cause that ? thanks steve

Line 35 was wrong Private Sub cmdUpdate_Click() 10 On Error GoTo cmdUpdate_Click_Error 30 Me.StockQty = Me.StockQty - Me.update 35 If Me.allocation < Me.update Then Me.allocation = 0 36 Else 40 Me.allocation = Me.allocation - Me.update 50 Me.update = 0 60...

i found my mistake, thanks for your help steve

Private Sub cmdUpdate_Click() 10 On Error GoTo cmdUpdate_Click_Error 30 Me.stockqty = Me.stockqty - Me.Update 35 If Me.allocation < Me.Update Then Me.Update = 0 36 Else 40 Me.allocation = Me.allocation - Me.Update 50 Me.Update = 0 60 Refresh End If MsgBox "The...

happy new year to everyone what i am trying to do is when i enter a number in the yellow box called update it will remove that amount from the stock qty and it also did from the allocation but i am trying to change it so that if the allocation is less than the value i put into the update...

the qty required is the amount to need to buy to cover the orders the qty out is the amount you need to buy because you could have some in stock the qty reqd is what the purchaser will actually buy incase he want to put some extra into stock i dont know how to do an update query using a...