Date format wrong

From: Jean (Jean_at_NoSpam.com)
Date: 11/10/04

  • Next message: martin: "RE: Reports works on one way but not the other" 
    Date: Wed, 10 Nov 2004 13:19:09 -0800

    I have an Access 2000 program that reads the date in d/m/yy instead of m/d/yy
    on one customer's pc.

    The program is running Access 2000 runtime on a WinXP Prof. OS with Office
    2000 Small Business installed. The appl first opens to a window that contains
    the MSCal activex control. The control is set to default to the current date
    on open (using the Now function); however, it opens to the wrong date. i.e.
    Today is 11/10/04. The calander opens set to 10/11/04.

    Then when the reports are run, the data on the report shows the dates in
    d/m/yy format also but the dates are not being read correctly. i.e. I select
    today's date on the calander for the date range of data to report. It tells
    me there are no records. However, if I select the date range 1/1/04 thru
    today, the report displays the data but data for today shows 10/11/04 on the
    report.

    I have checked the regional settings on the pc and everything looks ok
    there. Any suggestions where to look next? 

    -- 
Jean
  • Next message: martin: "RE: Reports works on one way but not the other"

    Relevant Pages

    • RE: Importing Data for use in report
      ... A report record source is based on the name ... you now have a Macro (or will with the additional info ... I am importing .TXT files....and for this particular database they will ... opens the report using my sample Test.txt. ...
      (microsoft.public.access.reports)
    • Re: Sorting, filtering, wrapping
      ... As it happens this particular database is for employee ... When I have parameters for a report I prefer ... > open the report rather than the parameter form. ... > opens the parameter form: ...
      (microsoft.public.access.formscoding)
    • RE: Tracking Log In and Log Out times of Users
      ... Set rst = CurrentDb.OpenRecordsetin the code you gave me for the ... A Report module is the same, except it is specific to that report. ... corner and then went to properties for the form then to Load event and did ... I have a start-up form that opens when the database opens. ...
      (microsoft.public.access.modulesdaovba)
    • RE: Why cant I open a report using VB?
      ... know that the query is fine, and so is the data that the report is based on. ... is to check that the control that you refer to to populate the variable ... intTestID = Forms!frmDrive!Text35.Value ... opens the report, or have you stored it in your variable intTestID? ...
      (microsoft.public.access.modulesdaovba)
    • RE: Tracking Log In and Log Out times of Users
      ... box for the Load event. ... I have a start-up form that opens when the database opens. ... form or report that will write an entry to an audit log table. ... I have a audit log tabel, however what fields should I put in this table. ...
      (microsoft.public.access.modulesdaovba)