Automatically generate a record in a table

Scallebe

Board Regular
Joined
Feb 4, 2016
Messages
59
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 ...:rolleyes:

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
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,212,927
Messages
6,110,703
Members
448,293
Latest member
jin kazuya

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top