Using VBA to automatically add a new date to my table?

  • Thread starter Thread starter VWP1
  • Start date Start date
V

VWP1

I would like to have my table (perhaps through a form) automatically add a
new record with the date, every 24 hours, starting at midnight, 24/7/365

How do I do that?

Also,
And how do I search my username VWP1, because I tried searching users, typed
in my VWP1 username, and no records were found?

VWP1
 
I would like to have my table (perhaps through a form) automatically add a
new record with the date, every 24 hours, starting at midnight, 24/7/365
Click to expand...
How do I do that?
Click to expand...

Why the heck should you? What purpose would that table serve? Creating new
empty placeholder records with nothing but a date field doesn't accomplish
anything that can't be done better in other ways.

What's the context? What real life problem are you trying to solve?

If you need such a table, I'd just create it with dates from now through 2025
or so, as a one-time operation. You can actually create the data using
Insert... Fill Series in Excel and copy and paste the data into your table.
But I'd assert that you do NOT need such a table.
Also,
And how do I search my username VWP1, because I tried searching users, typed
in my VWP1 username, and no records were found?
Click to expand...

The webpage search interface has been broken for ages. Try
http://groups.google.com and choose "advanced search".
 
Back
Top