Search results

  1. F

    Question Adding two totals together

    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...
  2. F

    Check records for data

    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...
  3. F

    Question Update query has error 424 Object required

    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...
Back
Top Bottom