increase a number by 1 in a field on the same day each year automatically

[ssanfu]

@Micron,


I have Access 2010.
If I try to add a reference to the "Microsoft DAO 3.6" library, I get an error: "Name conflicts with existing module, project of object library".
Sometimes I get compile errors (sometimes on built in functions, as in Mid or Left); I then have to add reference(s) to: "Microsoft Office 14.0 Object Library" and/or "Microsoft Office 14.0 Access database engine Object Library". (one or both)


IIRC, "Microsoft DAO 3.6" has been superseded/replaced by "Microsoft Office 14.0 Object Library" and/or "Microsoft Office 14.0 Access database engine Object Library"...... At least for A2010 and later.


EDIT:
Whoops!!
Tried compiling Micron's code with the reference "Microsoft Office 14.0 Object Library".... choked on the line "Dim db As DAO.Database".
The error is "Compile Error: User-defined type not defined"


ridders52 is correct. I set a reference for "Microsoft Office 14.0 Access database engine Object Library" and the code compiled OK.

[June7]

I have used transaction but not with DAO workspace. Example:

Dim cn As ADODB.Connection
Set cn = CurrentProject.Connection

...

cn.BeginTrans

...

cn.CommitTrans

...

cn.RollbackTrans

[isladogs]

Allen Browne has an article about this very reference in the different versions of Access
http://allenbrowne.com/ser-38.html
I use the Access database engine reference in all my databases for 2010 onwards

P.S. Hope Santa can also fix his own laptop

[Micron]

Well, I'm back at a keyboard after shelling out $$$
Will be several days before I get any Office software up and running - I need to pull k's of files off the old drive.
I guess I'll just have to hang on for the OP to try your suggestions.
Y'all have to note that I am/was using 2007 so I plead the 5th (maybe I'll just drink it instead and try to forget about the expense).

[jetanotherone]

Hi everyone,
I hope you all had a great Christmas and wish you a fantastic New Year and thank you to all for your help and information. I have learnt a lot in the last week and still have a lot more to learn but will close this thread with a (SOLVED)......
This is how I solved it....

Here is the link to the updated version.... https://schoolsnsw-my.sharepoint.com...3a54%3a20.000Z
Thank you again for your help!!