Search results

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

Hi guys thanks for the responce - the problem is that, as it is written I get the #error message - when I put in the field name as suggested the total is £0.00 also I am using access 2003 -

Could some one please help, just spent some time looking through all the posts regarding this , but still cannot get this simple sum to work I have a continuous form and require a field to give the total sum of the retail cost attached is a Jpeg of the form and code in the control source please...

Could any one help please I have a form with a field that has the total cost of a number of functions [Text407] I am trying to bring this into a report via a query (copy attched) with out any success, as the result comes up blank any one spot whats wrong please?

Thanks for the information will try this out - I have version 2003 I currently have the images stored in a different location with a hyperlink field in the estimate form, this works fine for the form but could not find away to bring them into the report, that is emailed to the customer again...

Hi could some one please help - I have searched the forum for a solution but not found or understood anything I have seen to resolve my problem I have a database for estimating accident damage on vehicles - the main form as fields for all the costings, plus a field that is hyperlinked to a...