Re: Unwanted time showing up in date fields

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: PJ (pj.krueger_at_erols.com)
Date: 12/30/04

  • Next message: Graham Payton: "Re: VB.Net, Crystal Report, Dataset, Stored Procedure, impending insanity....." 
    Date: Thu, 30 Dec 2004 18:29:09 -0500

    The first thing that comes to mind, is that this report is using the default
    date format.

    If all other reports have date fields formatted to date only they will work
    no matter what the system default is. If some machines default the date to
    date time, this would be a problem.

    The two choices would be to change the system default on the machines with
    the problem or format the date fields in the report.

    HTH,
    PJ

    "laurenh" <laurenh@gmail.com> wrote in message
    news:1104441870.413023.102490@z14g2000cwz.googlegroups.com...
    I have a VB6(SP5) application using CR 8.5 (SP3) to print reports from
    a DAO Jet data source. It's installed on about 100 workstations at
    remote sites. On about one out of 25 workstations that I deploy to,
    all of the dates in one report print as MM/DD/YY HH:MM:SS, when only
    the date part should be displayed. On the other reports and the other
    24 machines, it's no problem.

    Suspecting a .DLL version problem, I have checked all of the .DLL files
    that I can think of (crviwer.dll, craxdrt.dll, craxddrt.dll,
    p2smon.dll, craxdui.dll, and a few others), and the versions seem to be
    the same between the PCs that don't have the problem and those that do.

    During early testing, I had exactly this problem on 3 out of 5 test
    machines. As I recall, I fixed it by making a change in the VS
    Installer: setting DAO350.DLL to self-register.

    I could fix this by converting all of those date fields (about 80) to
    strings before handing them to CR, but the app is already deployed and
    since it overwhelmingly works I'd really prefer not to.
    Can anyone think of anything else I'm missing?

  • Next message: Graham Payton: "Re: VB.Net, Crystal Report, Dataset, Stored Procedure, impending insanity....."

    Relevant Pages

    • Re: Bug in Access 2002 Reports
      ... from within the Detail Section format event ... This will give the report a feeling of being "to scale", when you look at it you can see there are smaller, larger or equal intervals. ... Access will format the section but it will remember the last placement of the controls. ...
      (microsoft.public.access.reports)
    • Re: Emailing a Report
      ... "What do you suggest for making sure text on the report is not overlapping, missing, and or out of order? ... I always add icons to my toolbars to make it easier to format forms and reports... ... Align Right -- must have>1 control selected to be enabled ... on the report -- when it generates the reports, if a User_ID has 2 reminders, are they now both showing up on the report? ...
      (microsoft.public.access.modulesdaovba)
    • Re: Rowsource of unbound object
      ... That is because the Format function returns a string. ... This works in a query, not sure how it will work for your Gantt Chart ... The report events are Open, Close, Activate, Deactivate, No Data, ...
      (microsoft.public.access.modulesdaovba)
    • Re: Converting decimal time into hh:nn:ss time in ACCESS
      ... around this issue by changing the format from 'mmmm yyyy' (this is how ... decimal field and it gives me the entire month total for each employee. ... I create a report to bring in all of the ... reformat the decimal time to hh:nn:ss with no problem as long as it is ...
      (microsoft.public.access.formscoding)
    • Re: Problems with exporting controls with borders to .rtf
      ... > With a report, you can use subreports to represent the ... >>Report after it's exported you may want to try exporting ... >>"Microsoft Security Announcement: Have you installed the ... >>editable format such as .rtf, ...
      (microsoft.public.access.reports)