Question Automatically creating rows in Access

[netsukemonkey28]

Hi all,

I realise this might be quite a complex exercise but i want to achieve the following.

I have designed a database to log monthly publications my company receives. Now what I need to do is trigger an event that at the end of the year creates a new set of publication records for that year to be created.

e.g - 1) current state

'Magazine' 'Date' 'In/Out'
Company Magazine 01/11/2008 Y
Company Magazine 01/12/2008 N

2) Trigger event

'Magazine' 'Date' 'In/Out'
Company Magazine 01/11/2008 Y
Company Magazine 01/12/2008 Y

once the final publication for the year is checked in I want Access to automatically create 12 more records dated from 01/01/2009 to 01/12/2009 (ad infinitum). Is this possible?

Thanking you in advance!

 

[Guus2005]

Yes it is.

I wish all questions where that easy to answer.

HTH

Oh, you wanna know more?

You can trigger this event by starting up the application or when the application experiences the year change you could create a form with a timer event and hide it. Let the timer check each millisecond (timer=1) the actual computer time. When it says 01-01-2009 00:00, the timer event is activated and you can do whatever it is you are willing to be doing at that time. Note that checking each millisecond slows everyting on your computer. You probably want to have a larger time frame like 60000 (each minute).

Again, HTH

 

[The_Doc_Man]

Rethink what you are doing. Whether you happen to believe this or not, you don't want to do it this way. Access does better than this for date manipulation, including the ability to group ordinary dates by months if you wanted a monthly report. The report wizard can help you do that.