Search results

I found the answer and a syntax for doing what I wanted to do updatetable(fld) = True rather than ![fld] = True I can't say that I totally understand, but it works! Thanks

I tried that as well and get the same Error in the same spot...

Thanks.. that solved the 91 error, now I am back to the good ol' 3265. Dim fld As DAO.field Dim strfldnm As String . . Set fld = updatetable(0) . . For x = 0 To length If e(x) > 0 Then xstr = CStr(x) .Edit...

Thanks, now as I am sure you are aware, I am newbie, and unsure how I would go about "instantiating the variable fieldname" (which I will change thanks). Once I have instantiated the variable, will I be able to use the variable to call multiple field names in my loop to input the data as required?

Code Please be warned that this is likely ugly and inefficient, but I have been trying to use some work arounds to make it work. Sub UpdateGaps() Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim updatetable As DAO.Recordset Dim ident As String Dim length As Integer Dim xp(8) As Variant...

Hi, I am trying to create vba application which compares two records across specified fields. The results are then recorded to a different set of fields in a different table. I have racked my brain, and for the life of me can not figure out how to do this. Does anyone know how this task...