AutoFillNewRecordFields

[Guest]

I have found the article on how to use this function online - however when I
try to DIM an object as DAO.Recordset in Access 2003, I am getting an error
"User-defined type not defined." Does anyone know why I am getting htis error?

Larry

 

[SusanV]

Missing reference - open the VBA editor and tools>>References, add the
Microsoft DAO library.

 

[Guest]

You probably have a missing reference...

Choose Tools/References from the menu and set a refrence to the DAO 3.6
library (or whatever version you have).

Steve

 

[Guest]

You need to establish a reference to that dll in order for you application to
recognize it. Open any code module, and go to Tools/References and find and
check the box for Microsoft DAO 3.6 Object Library. You code should then be
able to create the recordset.