Recent content by Thetaz1951

Thanks for that one jdraw though as you said it made no differenece.

Okay I corrected the dimension issue but the error still exists, the corrected code is below Sub PutinNewTag(TableIn As String, Tagtype As String, textline As String) Dim strSQL As String Dim NameIn As String Dim TagName As String Dim Db As DAO.Database Dim rstin As...

The StrSql is already in the code, though there is something wrong here and I do nto know what it is, baffling to this one. strSQL = "Select * from " & [TableIn] & _ "WHERE " & [TagName] & " = " & NameIn & _ "AND " & [PNTTYPE] & " = " & Tagtype That is...

Tagname is a field of the Table I am working in, I am attempting to populate that field if not already there. I see I have set it as two different types (Field and String) in the Function and the Sub - will correct that one. Still have the same error.

This almost has to be a simple issue but I just do not see it. I have some code that will run if I am populating an empty table(no duplication's possible) but now I am trying to create a Sub to check for existence of a record and handling it going forward. Anyways the big picture is looping...

I'm an old dog learning new tricks. I have been using small snippets of VBA to make my work easier and I have used the same code (with mods) since Access 2? days, anyway a while back. I make a modification with each new project(1-3 years range) so I am not an expert by any means, simply using...