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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dim dbsNew As Database... undefined type???
Many Thanks All working fine now.- aqua56
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Dim dbsNew As Database... undefined type???
I am trying to create a new recordset from the current database. When I try to compile after using... Dim dbsNew As Database Dim rstItem As Recordset Set dbsNew = CurrentDb Set rstItem = dbsNew.OpenRecordset( _ "SELECT * FROM Items") The compiler throws up...- aqua56
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Multiple E-mails from form controls.
I have an Access database form, where projects are tracked by entering dates as each step is completed. I need to e-mail simple text reports for each step. When a user double-clicks, these boxes the date is automatically inserted and we use the DoCmd.SendObject to send an e-mail, although no...- aqua56
- Thread
- Replies: 0
- Forum: Microsoft: Access Modules (VBA Coding)
