Search results for query: *

I have some experience with INSERT INTO statements, but when having to use them with an execute statement like conn.execute with all the quotes and all, I cannot seem to get it right. I have a simple INSERT INTO as a tester that works fine using conn.execute strSQL. However, the first parameter...

Hi All, I constructed a class module (VB6) so I can make additions and deletions to database with a listview interface. I have not used a class for anything in a long time. The problem is It will not compile. I hit run with full compile and nothing happens. Instancing set at 5, multiuse and...

USING VB6 AND ACCESS 2002 (Sorry Old Stuff) I am trying to pass 3 variables into an SQL query. I get error: "No value give for one or more required parameters." There seems to be a problem with the SQL syntax although it compiles perfectly. The SQL statement executes with this: strSQL =...

I am trying to develop an SQl Query that involves two tables. The VB6 program I am writing is basically for an office football pool and queries an Access 2002 database. It involves two tables, "Players" which has the players, the matchup ID and their respective picks for each game broken down...