Search results for query: *

Thanks Duane. Very much appreciated. Know I can see the pattern for future reference and of course the code works now!!

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

The typo is a result of cut and paste. the code is okay. There is only one instance of the class necessary. Add_Matchup is called by the client program like this: objSchedule.Add_Matchup(txtYear, txtSeason, txtWeek, txtDay As txtDate, txtVisitor, txtHome)...

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

Sorry for the belated reply. Forgot to bookmark this site and could not remember where I had posted. The string variable in quotes worked! Thanks so much for the help.

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 =...

AWESOME!!! Exactly what I needed. Works perfect. Thanks so much for the quick reply and solution. I have been working on this for weeks. Gary

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