Search results

Thanks Trevor, Can you advise what this line indicates? Set rst = db.OpenRecordset("Commission", dbOpenTable) On opening my form i get "Run time error 3219 invalid operation, on hitting debug it takes me to the above line of code. Maybe i have a different name for that section but as you are...

Thanks for that Trevor, the only one query i have is where you state "What do you need to check for ! rst.Fields("TotalKitCost").Value = Me.Text8.Value" My text box (as i am aware) doesnt have a name as it is an unbound text box. Apologies if i am clueless but i am self taught so far.

I have attached a dummy DB with a basic view of my current set up. The form Equipment has a Total field (in the footer) which calculates the totals. The Total Kit Cost form just has one field and i would like it to take the Total from the Equipment form and place in the the Total Kit Cost field...

Unfortunately i am unable to copy the table and form, any other ideas?

I have no idea if i can do that, i will give it a go and see how i get on, thanks for all your help so far.

oh not really alot i can do about it then :-(

the problem is my database has been split, am i still able to send it?

Where it states Project I.D is that the name of the field i want the information to go to? If so i have tried using the code provided on before and after update but neither have worked, i also left the """" in not sure if i was supposed to. I have no understanding of code so apologies if i seem...

ok do i put the code behind the field i want the value to go to? or the field that already has the total formula behind it?

Oh i see, is there no way of it automatically adding the data, having to copy and paste it kind of defiates the object. I was just hoping to set it up that the total value would be stored in another field.

Thanks for coming back to me, where do i need to place the below, i dont work with code often. Private Sub Command7_Click() DoCmd.GoToControl "Project ID" DoCmd.RunCommand acCmdCopy Docmd.OpenForm "The form name goes here" DoCmd.GoToControl "Project ID" DoCmd.RunCommand acCmdPaste End Sub...

Hi All, I have a field called TotalKitCost, and on another form called "Equipment" i have an unbound text box with a control source of =SUM([TotalCost]) that text box totals all the amounts and displays the information in the form footer. Instead of manually entering that information in another...

Thank you so much, works brilliantly.

Hi All, Please find attached an image of the form i am describing, the Total Price is called "TotalPrice" in the table, the Total Cost is called "TotalCost" in the table, it is set as a continuous form so many records can have say 20 pieces of equipment and some can have one. The TotalCost i...

Thanks for coming back to me again, unfortunately i am only a beginner in access so would you be able to show me an example? or is there anywhere online that shows this?

Well the first part i have managed to do so thank you for that. The second part however i am receiving problems, my form called equipment is set to a continuous form design so every time i need to add another line of info it automatically displays all the fields again ready for entry. On...

Thanks for coming back to me but which part do i use to build the expression, before update after update etc?

It sure did make sense and worked brilliantly thank you.

So i have 5 fields example: Field1 Field2 Field3 Field4 Field5 + a Total Field I would like it to add all 5 fields together and enter the amount in the total box, on occasions amount could be £29.99 so preferably would not like it to round the figures up. I also have another form which is set...

My db is massive and is also split, can you advise or is it to long, i only need the general idea as im sure i will remember.