Results 1 to 11 of 11
  1. #1
    New Lounger
    Join Date
    Nov 2003
    Location
    Maryland, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Data Missing (2003 SP2)

    I have a report using VBA code to perform calculations. When one user runs a report, the calculated data is not showing. All the other users can see the data. All users are using the same version of Access. I can't seem to reproduce this anomaly. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    See attached example.
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Data Missing (2003 SP2)

    Does the offending computer have the same references (Tools / References... ) set in the VBA that the others do?

  3. #3
    New Lounger
    Join Date
    Nov 2003
    Location
    Maryland, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Data Missing (2003 SP2)

    The database is located on a network drive (for testing) and is accessed from the same location by all users. Would the references be a factor in this case?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Report Data Missing (2003 SP2)

    Whether references work depends on what is installed on the end user's PC, not on the location of the database.

    But I doubt that this problem is caused by references - if one is missing, the user would get an error message about an undefined user-defined type.

    Unfortunately, I have no idea what could cause this problem. If you wish, you can attach a stripped down and zipped copy of the database to see if anyone can reproduce the problem and/or solve it.

  5. #5
    New Lounger
    Join Date
    Nov 2003
    Location
    Maryland, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Data Missing (2003 SP2)

    After reinstalling Access then uninstalling & reinstalling Office 2003 (SP3), this problem continues with this user. He can see the complete report when using another computer. It seems that it's his computer causing the problem since others who use his computer have the same problem viewing this report. Has anyone encountered a similar problem. Could it be a registry setting causing this problem?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Report Data Missing (2003 SP2)

    You could try the following on the problem PC:

    1) Re-register DAO:
    - Quit Access.
    - Select Start | Run...
    - Type <code>regsvr32 "C:Program FilesCommon FilesMicrosoft SharedDAODAO360.dll"</code>


    2) Reinstall MDAC - you can download it from Microsoft Data Access Components (MDAC) 2.8 SP1.

    BTW You haven't received an e-mail notification of this reply since your ISP classified it as spam. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>

  7. #7
    New Lounger
    Join Date
    Nov 2003
    Location
    Maryland, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Data Missing (2003 SP2)

    Hans,

    Thanks for your response.

    I followed the steps you indicated but got the following error:

    "Fatal Setup Error: This setup does not support installing on this operating system."

    The operating system is XP (SP2).

    Any other ideas?

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Report Data Missing (2003 SP2)

    Oops, sorry about that. Apparently the version of MDAC for Windows XP SP2 is not available for download. You could try the steps in How to Repair MDAC 2.8 Under Windows XP with SP2 Installed instead.

  9. #9
    New Lounger
    Join Date
    Nov 2003
    Location
    Maryland, USA
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Data Missing (2003 SP2)

    UPDATE: After applying the updates to repair MDAC to no avail, we gave the user a brand new docked laptop with the latest and greatest including all updates and service packs and the user STILL cannot see the data. He can logon to other laptops and see everything. This has our entire IT team stumped.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: Report Data Missing (2003 SP2)

    I'm afraid that I'm stumped too, sorry.

  11. #11
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Data Missing (2003 SP2)

    Complete shot in the dark here - when I get/hear of report problems I think of printers/printer drivers if nothing Access related can be found.

    Probably nothing but may be worth a look. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •