Recent content by PicassoB

First thanks for looking at this - the problem is that on changing the decimal separator to a comma, I get the error message in the field with the above code. this was supplied by bob fitz on the forum which I greatly appreciate, and worked perfectly until I changed the decimal separator Is...

Help please, can anyone see a problem with the code below I needed to change the decimal symbol from a dot to comma for use in Europe. On changing the the settings to a comma everything works fine but for the field that I have the code in the AfterUpdate properties Private Sub...

Thanks for the help Missingling - the system is used in the lab as bench mark testing against competitors products and Min/Sec are important will try the options and see if this will be acceptable appreciate your help :)

Thanks again for your help Bob - its good you are prepared to help the novices

yes just as you said, great dare I ask if there is a way I can change the time field to minutes & seconds it is currently a number field /60 because if I use the standard time field I can only input up to 23min, my system would then be complete :o

Many thanks Bob it works brilliant just as I required Spent hours trying different ways and hoped some one would know a code to solve my problem really appreciate you helping a novice with code

Thank you for looking at this and the response, maybe I didn't explain to well what I require. Basically when I change the labour rate I need this to cascade down all the records automatically so the operators in different countries only need to enter the labour rate and then click the calculate...

Could anyone help please with this problem, I have searched the forum but not found anything to help. I have a system that has a Continuous sub form, (example attached) this is used to calculate various processes. The problem is I would like to have the Labour cost as a single field in the...

Hi MStrf, thanks for the responce I have allready tried this, still comes up Zero must be some thing so simple i cant see it

Hi could any one help with a problem I am having getting a calculation to work from a combo box - The product and cost come from a drop down list, cost comes from colum 2 - calculation works fine until I do the total sum which comes up blank or error. attached is a jpeg of the form in design and...

Many thanks guys for the responce and help I have it sorted now :)

Hi, on running my report the data in the detail section comes up in reverse to how it is entered in the form - could any one please give me a simple solution to put this in the correct order :o

Thanks Kowalski for your responce - I have got the report to work problem now is I have a unbound field in the form to discount the labour hrs (which is a calculated field) this works fine in the main form but does not discount in the sub form (always stays at the defult value) any Idears what...

Hi Guys I have a problem with a repot, I have inserted a sub form (continuous form)in the detail section of the report - problem is on running the report the form duplicates itself according to the number of records in the form - any idears please i am using 2003

many thanks DF works perfect - simple when you know how, I appreciate the help from the experts