ms access data

[supernerd101]

I am trying to setup a database (budget), I am wanting to set the
transactions to repeat say every 2 weeks or every month. Is there a way to
do this in access.

 

[June7 via AccessMonster.com]

Would require a combination of instruments to accomplish this. First, code in
Access that will cause the transactions module to run at specified times (or
based on some value provided to the procedure). This code would have to be in
a module that runs when the project opens (such as a login or main menu form).
Then if you want the project itself to automatically open according to a
schedule, try using Windows Task Manager or even Outlook calendar (VBA coding
in Outlook might be needed, perhaps this code could pass value to the Access
code that runs the transactions module or directly execute the module). I
have never done any of this, just what I have gleaned by reading other
postings. Good luck!

 

[supernerd101]

Thanks, I'm trying to get to something ms money did where you put the
transactions in and it automatically put the transactions for future
transaction in the register.

 

[John W. Vinson]

Thanks, I'm trying to get to something ms money did where you put the
transactions in and it automatically put the transactions for future
transaction in the register.

How many? For the rest of the year? Until December 31, 9999AD (the limit for
Access dates)? Selectable?

You'll need to run an Append query to do this; it's handy to have an auxiliary
table named Iotas, with one long integer field Iota with values from 0 through
10000 (or some larger number than you'll ever want). You can use this in
conjunction with the DateAdd function and query criteria to specify what dates
and how many of them to add.