Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help with ado.recordset.filter syntax, please!
Thank you for your help! The following works fine: adoAtlete.Recordset.Filter = "[" & ActiveYear & "_Reg_Nr] LIKE '" & cboNumber.Text & "'" I know that there's some issues with the database build. I just made a tester to see how everything's going to fit together and to get some ideas on...- dwsteyl
- Post #5
- Forum: Visual Basic (Classic)
-
Help with ado.recordset.filter syntax, please!
SBerthold Thank you for your reply. Please ignore the first post as that was a very bad example. This might be more enlightning: I'm writing a program to contain athlete information. The field to be filtered actually has the name "2001_Reg_Nr" or "2002_Reg_Nr" etc. which stands for...- dwsteyl
- Post #3
- Forum: Visual Basic (Classic)
-
Help with ado.recordset.filter syntax, please!
Hi there people! I'm working in VB 6, using an ADO control to connect to an Access 2000 database. The access database has 4 columns. Each column represents a different year, for ex. "2001", "2002" etc. At startup a combobox (cboNames) is populated with all the names from only one of these...- dwsteyl
- Thread
- Replies: 5
- Forum: Visual Basic (Classic)
