[AccessD] Problems with Date()

A long while ago I had an MDAC issue that showed the same syptoms and the fix was tyo somply install the latest MDAC.  The workaround was to create a funciton like the following:

Public Function GetDate2() as Date
	GetDate2 = Date()
End Function

Then in every calling place use Find and Replace to change Date() to GetDate2().  If it's the same issue then a VBA call to it worked while the calls from a textbox did not.

-Chris Mackin

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Geller
Sent: Monday, July 19, 2004 3:38 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Problems with Date()


I have a bunch of reports which are really letters and I want them to
have today's date on them when it's run. No problem.  I put a textbox on
the report and set the control source as "=Date()".  Works fine on my
machine.  Doesn't work on other machines.  I have a very different set
up than the other machines so I don't even know where to look. Any ideas
on what might be causing the report to pop up with a dialogue box saying
"Enter Date" (as if I was asking for an input parameter) when I run the
report?    Note:  Office XP, 2002 file format.

--Susan

Susan B. Geller
Office of Information Systems
College of Continuing Education
University of Minnesota
306 Wesbrook Hall
77 Pleasant Street SE
Minneapolis, MN 55455
Phone:  612-626-4785
Fax:  612-625-2568


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com