Search results

I managed to get this going I added the code to the after update when I select the product

Hi, When I make a new form as per your sample, it works fine When I amend my old form, the mass control is tabbed irrespective of the mass required or not Only when I go to design view and back to form view that the code worked After I have selected the product, below is the code Please...

Thank you for the info I did not add PK to the temp files as I did not think it would be used My transaction file I am updating does have the PK I mad all the amendments as sugested Thank you very much

Edited

It is still looking for the table to be present in the query and also a data type mismatch

Table 4 only has one record, that is the currency value I need to update in the Transactions - Procurement - Temp table I am gathering information from different tables to update just the one table to enable me to do calculations based on those values updated If I have joint tables which are...

Hi all, I have a query with 3 tables linked with join fields 2 and 3 as per below I need to update a table with data from a 4th table but there is no joint field If the joint between tables 1, 2 and 3 was joint where the fields are equal then there is no problem adding table 4 How do I...

Hi, I used you sample as is, for some reason when mass is required the mass control is not active When I switch to design view and back to form view, the mass control becomes active Please could you advise?

Hi, I need to add below to the formula but this once is quite a puzzle for me Could you please assist with the contention If Currency = UGX and mass required = false then Qty * Unit price If Currency = UGX and mass required = true then Mass * Unit price If Currency <> UGX and mass required =...

Thank you arnelgp I made the changes as per you sample, much appreciated I am still getting an error on code I am also still struggling with the control "Mass" , when massrequired = yes, the control is not active When massrequired = no then control is not active either

Now attached

Hi, Still struggling with this code

Hi, Please see my DB

Yeh agee Still not working though And the code you advise wont work, when massrequired = true, control should be active If my part required a mass = massrequired true, then die control will me made inactive by true Correct?

Thank you arnelgp Where are you saving the exchange rate? I am still getting the same error in the code when I open you DB Type mismatch

Still des not seem to have the require effect, not sure if I am missing something here

Thank you for the advise I actually did have a look at the code but not sure what .responcetext is or where it comes from This error appears when I do e debug print on responcetext, a run time error 2147483638, The data necessary to complete this operation is not yet available I checked the...

Appo;ogies Run time error 13, type mismatch

Error on

Yes, I apologies, still early in the morning :) It is possible to have both qty and mass I will keep the formula as is