CarryOver problem

[alexasha]

Hi,
I used carryover function with great appreciation for last couple years.
I created a new large database and tried to replicate my success with
CarryOver function.
I tried placing either old code or updated code , but always get this error:
Compile error:
User-defined type not defined

and I have "rs As DAO.Recordset" highlighted
Is there any help with this?
Thanks

 

[boblarson]

make sure that you have a DAO reference checked in your references

If you aren't sure how to go look, see here
http://www.btabdevelopment.com/main...eckformissingreferences/tabid/71/Default.aspx

--
Bob Larson
Access MVP
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[alexasha]

What is the name of this reference?
my other database with the same code works just fine.
I think it is something very simple that I am missing.

 

[alexasha]

you were correct. it was unchecks. Everything works. Great thanks

 

[boblarson]

Glad to hear you found it.
--
Bob Larson
Access MVP
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[alexasha]

One more question
When do CarryOver I do not transfer date and time. It is possible to get
automatic current date / time without manual entrance
I tried Date() and Time() in table field properties or form field properties
but it does not work with CarryOver

 

[boblarson]

You should be able to put

=Now()

in the table in the field's DEFAULT property. But just realize that it will
only work with NEW records, it won't do it for existing records. For that
you would need to add it with code on a form, or with an update query.
--
Bob Larson
Access MVP
Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________