get time and date??

are there any functions to get time and date in vb and set it to variables for storing it into database like access?

Time()
Date()

you have date() and time()

if you want to write this away in a database you can do it with:

you can use date() and time()

if you want this to write it away in a database, then you must do this:
Date = rst!FIELD.Fields("datum")
Time = rst!FIELD.Fields("tijd")

I hope this helps you;)