A awake2424 Registered User. Local time Today, 14:56 Joined Oct 31, 2007 Messages 479 Sep 22, 2014 #1 I am getting the below error on a database that previously worked. Thanks. Code: Dim rst As DAO.Recordset User-defined type not defined
I am getting the below error on a database that previously worked. Thanks. Code: Dim rst As DAO.Recordset User-defined type not defined
pbaldy Wino Moderator Staff member Local time Today, 12:56 Joined Aug 30, 2003 Messages 36,157 Sep 22, 2014 #2 What version? Typically that would mean the reference isn't checked in Tools/References.
pbaldy Wino Moderator Staff member Local time Today, 12:56 Joined Aug 30, 2003 Messages 36,157 Sep 22, 2014 #3 Uncle Gizmo said: Would you like to explain why you singled out that particular line of code? Click to expand... Probably a compile error and that's the line highlighted in yellow.
Uncle Gizmo said: Would you like to explain why you singled out that particular line of code? Click to expand... Probably a compile error and that's the line highlighted in yellow.
A awake2424 Registered User. Local time Today, 14:56 Joined Oct 31, 2007 Messages 479 Sep 22, 2014 #4 Yes it was highlighted in yellow and Access 2010 is being used. Thanks.
pbaldy Wino Moderator Staff member Local time Today, 12:56 Joined Aug 30, 2003 Messages 36,157 Sep 22, 2014 #5 In 2010 it should be referenced by default. Is the MS Office 14.0 Access database engine object checked?
In 2010 it should be referenced by default. Is the MS Office 14.0 Access database engine object checked?
A awake2424 Registered User. Local time Today, 14:56 Joined Oct 31, 2007 Messages 479 Sep 22, 2014 #6 It was just a reference. My database crashed and apparently I forgot to load the ADO reference. Thank you.
It was just a reference. My database crashed and apparently I forgot to load the ADO reference. Thank you.
pbaldy Wino Moderator Staff member Local time Today, 12:56 Joined Aug 30, 2003 Messages 36,157 Sep 22, 2014 #7 No problem (and that's DAO not ADO).
