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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: DaveLondon
- Order by date
-
Set recordset value as a variable
Thanks guys :) That's fantastic :)- DaveLondon
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Set recordset value as a variable
Hi there, I'm using Acces 2000 and I currently have working code that moves though a record set: Dim rs As DAO.Recordset Dim db As DAO.Database Dim strSql As String Dim dataitem As String strSql = "SELECT CODE FROM Qry_Unique_Stocks;" Set db = CurrentDb...- DaveLondon
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Loop through Query Records
That has worked :) Many thanks ! Dave.- DaveLondon
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Loop through Query Records
The debugger doesn't highlight it. I just get the message box when I click the button. Yes the SQL executes fine.- DaveLondon
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Loop through Query Records
Hi there, I'm trying to write a button click module in Access 2000 that will loop through all the records in a query. The code I have so far is: Dim rs As Recordset Dim strSql As String strSql = "SELECT ISIN FROM Qry_Unique_Stocks;" Set rs =...- DaveLondon
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
