Automatically generate a record in a table

[Scallebe]

Hi specialists,

I have a small table (jaren) with different seasons like 2012-2013, 2013-2014, 2014-2015, ...
I use this table for a combobox in a small form to set the parameters in a query. I open the form, select the season I want and then I click a button to open the report.

works perfectly

.

My question if it's possible ...

I would like to generate a new record in that table every 1st of september because e

very season begins 1st of september.

So this year it would be 2018-2019

And the next time I open the database after 09/01 Access should not create the record because it's already there.

Now I have to create the new season myself, no problem of course, but it would be great if it goes automatically.


Is this possible? With VBA?


Thanks

Greetz

Pascal
​

​

 

[Joe4]

Cross-posted: http://www.accessforums.net/showthread.php?t=71267

We don't mind if you Cross-Post on this site, we just ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

Thanks

 

[Scallebe]

Joe4,

I'm sorry, I realy thought it was a different forum. I just wanted to expand my options.

It will not happen again.

Greetz

Pascal

 

[Joe4]

I'm sorry, I realy thought it was a different forum.

It is, but that is precisely the issue - posting the same question to multiple forums.
Read this and you will understand: https://www.excelguru.ca/content.php?184

 

[Scallebe]

Joe4,

I understand what you mean. I respect what you guys are doing here.
Again, I'm sorry, next time I will post a link.

Greetz

Pascal

 

[welshgasman]

In the startup of your database, test for the date.
If after 09/01 then look for the required record using DLookup.
If not there, create the record.

HTH