Detecting Changues in Date

[joseluisbz]

Hi Everyone...

I am using Database Controls, but my Database is growing quickly. I think to use other Database by Day(One per Day).

I build a Database in running time with Name using Date and Time... I.E. 20010725183045.mdb (Date July 25 of 2001 and Time 6:30:45pm)

I need (Event or other thing) to detect when changues the Day...

How to detect increments of Day when Pass of 20010801235959.mdb to 20010802000001.mdb ?

Thanks...

joseluisbz@bigfoot.com

[cksiow]

first way, use a timer of resolution 1 second, and in the timer event read the date to figure out if the day change.

second way, in the database update function (where you add record), check the date first before updating record. if it is new day, close old file, create new file.



HTH

cksiow
http://vblib.virtualave.net - share our codes