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!
-
ado stop fetching data into excel after 100 records
I used ado recordsets to fetch data from an access 2003 queries into excel spreadsheets. The module will automatically open a Excel template and populate the data from Access onto 3 different spreadsheets and then print the workbook directly to adobe pdf file. The program only successfully...- ac277
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Update Query with system date
Hi, I have an update query which update the date field with the current system date but the query returns zero. Can somebody please see if there is anything wrong with my code? UPDATE tblEmpChange SET tblEmpChange.ToDate = Date() WHERE tblEmpChange.[cur_Status] Like '*Leave' and...- ac277
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
