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 Mike Lewis 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: rbraunberger
- Order by date
-
What's wrong with my sql statement (date selection) in Data Report ?
Try changing strSQL to the following: [code] strSQL = "SELECT [courier query].* FROM [courier query] WHERE date BETWEEN #" & strFrom & "# AND #" & strTo & "#" [\code] This should work. The brackets around the Select statement followed...- rbraunberger
- Post #2
- Forum: Visual Basic (Classic)
-
How to count a number of records in Ms Access using Visual Basic 6?
If your recordset is called rsABC, then do this: rsABC.MoveLast rsABC.MoveFirst RecordCount = rs.RecordCount I don't believe you need the MoveFirst and MoveLast commands if you're using ADO. Hope that helps.- rbraunberger
- Post #3
- Forum: Visual Basic (Classic)
-
Firing events - Firing too many times..Please help
The problem here is with the test for 12:01am. This loop will immediately fall through because the current time actually is > 12:01am (of today, not tomorrow). The only time this will loop is between 12:00am and 12:01am -- all other times are > 12:01am. In order to make time tests like this...- rbraunberger
- Post #9
- Forum: Visual Basic (Classic)
-
ADO problem
I've had this happen when the database has been corrupted. Try repairing and compacting it and you just might be OK. Good luck!- rbraunberger
- Post #5
- Forum: Visual Basic (Classic)
