Error when updating sub report
If you also want to avoid that, do something like "If rs Ctrl Rec.I have a 1 row table that I'm trying to read into a recordset using VB6, but when I try to access any of the fields in the record, I get a runtime error 3021 "No current record". Path & "\" & "LLSYS.mdb") Set rs Ctrl Rec = db Ctrl Rec.I thought that when you use the Set Recordset command the recordset is populated with the contents of the target table. Open Recordset("SYS_CONTROL_RECORD") Msg Box rs Ctrl Rec. Path & "\" & "LLSYS.mdb") Set rs Ctrl Rec = db Ctrl Rec.(no need for DAO.) 2- Set rs Ctrl Rec = db Ctrl Rec. MDB style database, I've found the DAO to be an incredibly powerful tool. I can keep track of variables on my own loll When you put too much restrictions on coding, it becomes VB 2010 and I don't wish that anyone *laughs heartily* Hey Navion, I'm totally with you. VBP project is a monumentally bad idea in my opinion.
Open Recordset("SYS_CONTROL_RECORD") is ok too 3- I always use indexed recordset, and by habit, I always include the line : rs Ctrl Rec. vb6coder14, here's the DAO help file, in case you don't have it. I mostly work alone these days, but I've had to fire programmers in the past who wouldn't leave unbroken code alone. There's another "code sharing" thread on here where I made a similar point. It's the same issue, someone "fixing" code for one project that breaks another. , a$, and a# days, but I have managed to wean myself into the new "as string" etc format.
Command Text = "INSERT INTO U_USERS_TABLE (USERNAME, PASSWORD, FIRSTNAME, LASTNAME) VALUES (" "'" txt Username.
Error when updating sub report comments