Module "CarryOver" from Mr. Allen Browne
in [Queries]
|
From: Leo on 28 Mar 2010 19:19 I copies and followed the instructions and installed the module from the site below: http://allenbrowne.com/ser-24.html It is not working and hangs at the very first 'Dim' statement which is Dim rs As DAO.Recordset Am I expected the modify the code here and anywhere else in the module? Please help. Thanking you in advance Leo
From: Gina Whipp on 28 Mar 2010 21:17 Leo, Check your References make sure you have one set to the DAO x.x Object Library. Also make sure that none are MISSING. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Leo" <Leo(a)discussions.microsoft.com> wrote in message news:BB0B68F3-D4C6-4A24-9A92-A119CA21912B(a)microsoft.com... I copies and followed the instructions and installed the module from the site below: http://allenbrowne.com/ser-24.html It is not working and hangs at the very first 'Dim' statement which is Dim rs As DAO.Recordset Am I expected the modify the code here and anywhere else in the module? Please help. Thanking you in advance Leo
From: Allen Browne on 28 Mar 2010 21:26 You may need to add a reference to the DAO library. Details: http://allenbrowne.com/ser-38.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Leo" <Leo(a)discussions.microsoft.com> wrote in message news:BB0B68F3-D4C6-4A24-9A92-A119CA21912B(a)microsoft.com... > I copies and followed the instructions and installed the module from the > site > below: > > http://allenbrowne.com/ser-24.html > > It is not working and hangs at the very first 'Dim' statement which is Dim > rs As DAO.Recordset > > Am I expected the modify the code here and anywhere else in the module? > > Please help. > Thanking you in advance > Leo >
From: Leo on 28 Mar 2010 22:01 I am new to this. Could you explain a bit more and also how to do it step by step, please. Thanks Leo "Gina Whipp" wrote: > Leo, > > Check your References make sure you have one set to the DAO x.x Object > Library. Also make sure that none are MISSING. > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Leo" <Leo(a)discussions.microsoft.com> wrote in message > news:BB0B68F3-D4C6-4A24-9A92-A119CA21912B(a)microsoft.com... > I copies and followed the instructions and installed the module from the > site > below: > > http://allenbrowne.com/ser-24.html > > It is not working and hangs at the very first 'Dim' statement which is Dim > rs As DAO.Recordset > > Am I expected the modify the code here and anywhere else in the module? > > Please help. > Thanking you in advance > Leo >
From: Leo on 28 Mar 2010 22:32
Thanks Allen! The link really clarified everything! Once again thanks a million! Sincerely Leo "Allen Browne" wrote: > You may need to add a reference to the DAO library. > > Details: > http://allenbrowne.com/ser-38.html > > -- > Allen Browne - Microsoft MVP. Perth, Western Australia > Tips for Access users - http://allenbrowne.com/tips.html > Reply to group, rather than allenbrowne at mvps dot org. > > > "Leo" <Leo(a)discussions.microsoft.com> wrote in message > news:BB0B68F3-D4C6-4A24-9A92-A119CA21912B(a)microsoft.com... > > I copies and followed the instructions and installed the module from the > > site > > below: > > > > http://allenbrowne.com/ser-24.html > > > > It is not working and hangs at the very first 'Dim' statement which is Dim > > rs As DAO.Recordset > > > > Am I expected the modify the code here and anywhere else in the module? > > > > Please help. > > Thanking you in advance > > Leo > > > . > |