 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / February 2006email from recordset
Hi All: I think I may be in over my head on something here. I have a database which contaings, among other things, a table with fields for email addresses and expiration dates. I am trying to set up something that will email a notice to subscribers when their subscriptions are about to expire. I found the following article at the MS Knowledge base covering this subject (sort of) which is article number 318881. Following the directions, I am getting this error when I debug the code: Compile Error: User defined type not defined apparently relating to this line of code: Dim MyDB As Database The only specified reference in the article is Microsoft Outlook 11.0 Object Library, which is checked. This has me completely baffled, so any help would be greatly appreciated. Steve Hi Steve, This probably means that the KB code is written to use the DAO library but your database only has a reference to the ADODB library. (Both these have recordset objects, but only DAO has a database object.) Go to Tools|References and add a reference to the Microsoft DAO 3.xx object library (it's 3.60 in recent versions of Access). Then play safe and make your code clearer by using explicit declarations, e.g. Dim MyDB As DAO.Database Dim rsXX As DAO.Recordset >Hi All: > [quoted text clipped - 16 lines] > >Steve -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. Yep..that was it. Thanks a lot, John Steve Hi Steve, This probably means that the KB code is written to use the DAO library but your database only has a reference to the ADODB library. (Both these have recordset objects, but only DAO has a database object.) Go to Tools|References and add a reference to the Microsoft DAO 3.xx object library (it's 3.60 in recent versions of Access). Then play safe and make your code clearer by using explicit declarations, e.g. Dim MyDB As DAO.Database Dim rsXX As DAO.Recordset On Wed, 1 Feb 2006 21:28:36 -0600, "Steve" <steve@nospamtnccreations.com> wrote: >Hi All: > [quoted text clipped - 17 lines] > >Steve -- John Nurick [Microsoft Access MVP] Please respond in the newgroup and not by email. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.