Search results

Problem solved! I had to go into my subform in design view and put the total text box in the footer of that. Then I just put that subform in a form and referenced to the total text box inside the subform using another text box in the form. Thanks all for help

Bump Please help

Yh it is in the footer but I still get the error "#Error" coming up in the text box? Any help?

Thanks for the reply I think that the code will work but I am having trouble getting the columns to add together. Heres my code: =Sum([tblTest subform 1].[Form]![Quantity]) I already tried =Sum([Quantity]) But it didnt work Any suggestions?

Where would I apply this? to the click event on the text box? I would need it so when I press a button it will put the value in a text box. Or even better without the button and it just updates on its own?

Very sorry this is probably all over the internet but I cant seem to figure it out :S I am trying to add two columns with multiple records in them together using VBA. I have one column named "Quantity" and that has 5 records going down Column1(Row1) = 2 Column1(Row2) = 3 Column1(Row3) = 1...

Thanks for the quick reply's Here what I am trying to do I have several records I have in a table and I have quantities for each one, what I want to happen is when I press a button it takes one away from the quantity field and also stamps it with a date. I already have the code to make it...

I have an update query that adds a date to a field which works perfectly but I am wondering if I can get it to check if there is a date there already, if so add another field and put the date in that? Here is my code currently: Private Sub Command33_Click() Dim t1 As Date t1 = Date...

Ahh thanks you have been super helpful :D

Oh what a legend all that works! nice one

Ahh great stuff that works :) But it updates all of the records at once? Is there a way to update one record using a value in a textbox? maybe if the ID was in a textbox the code would read it and update just that record?

Thanks for the quick reply :) I have put that in but still the same error?

I am trying to create an update query for the first time and am a little stumped of how it works. I am trying to update a field in a table with the current date as a request. I have a table named tblTest and a field named Date2 that I am trying to update with the current date, the button that...