Wortz, Charles
CWortz at tea.state.tx.us
Tue Mar 25 07:35:49 CST 2003
Barbara, There is no datatype of Date in Access. It is just an alias for the DateTime datatype, which of course has time included. You can mask out the time portion in your reports. As to your printer problem, please start a new thread about that and include more details so we can help you. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us -----Original Message----- From: Barbara Ryan [mailto:BarbaraRyan at cox.net] Sent: Tuesday 2003 Mar 25 06:52 To: Access List Subject: [AccessD] Problem with Date type variable I am encountering a problem with date type variables in Access 97. When I create a date type variable (e.g., "Dim dtDate as Date") , the variable has a default value of 12:00:00 AM. I don't remember this happening before. I recently did a "cleanup" on my PC, removing software I no longer use. Could I have removed a needed driver(s)? I ask that question because I am also having a problem with my printer (HP IIP Plus) not printing lines on reports (which it was doing fine last week). Any thoughts? Thanks, Barb Ryan -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030325/c7aea92c/attachment-0001.html>