Susan Geller
sgeller at cce.umn.edu
Tue Jul 20 13:04:39 CDT 2004
The problem was a missing reference which I discovered thanks to other replies to my post, but Now() did work even with the missing reference. I solved the problem by unchecking the missing reference from the reference list -- it wasn't needed anyway. Thanks! --Susan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael Brosdorf Sent: Tuesday, July 20, 2004 3:12 AM To: Access Developers discussion and problem solving Subject: AW: [AccessD] Problems with Date() Try using Now() instead of Date() and set the display format of the textbox to one the built-in date formats. Michael -----Ursprungliche Nachricht----- Von: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Susan Geller Gesendet: Montag, 19. Juli 2004 23:38 An: accessd at databaseadvisors.com Betreff: [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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com