Link to home
Start Free TrialLog in
Avatar of kdschool
kdschool

asked on

Access 2010 no longer has FileDateTime Function

We have a program that uses this feature in access 2003.  The reports person is saying that Access 2010 no longer has this function. Is there something else in 2010 or a way to create this using VBA code?
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

What function?

Jim.
If you're trying to get the current date and time the function now() should work for you.

ab
Also, if you can provide the section of code that is causing the error that will help all of us out ;-)

thanks!

ab
Avatar of kdschool
kdschool

ASKER

FileDateTime Function
SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I was told it was not working in 2010 by the person doing the coding.  Can you direct me to a valid site that talks about using this in access 2010.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I realize I did not ask this correctly the first time and tried to reward you all.  It put the points in.  The query and sandbox are the issues and these links help a lot.
...Glad we were able to help...
;-)