Results 1 to 10 of 10
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Corrupted Report? (2003)

    In the attached mdb, when I try to open the RTriannual report in design view, Access shuts down. Is the report corrupted?
    Attached Files Attached Files

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

    Re: Corrupted Report? (2003)

    When I open the report in design view in Access 2002, I first get a dialog that the report has been formatted for Acrobat PDFWriter (which is not installed on my home PC). If I allow Access to format the report for my default printer, the report opens in design view without problems. I can't open it in preview mode, of course, since you didn't include the record source in the database.

    Have you tried to compact and repair the database (in Tools | Database Utilities)?

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupted Report? (2003)

    Thank you Hans, yes, I have compacted and repaired it to no avail; can you please post the report formatted for the default printer?

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

    Re: Corrupted Report? (2003)

    Here you go.
    Attached Files Attached Files

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupted Report? (2003)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

  6. #6
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupted Report? (2003)

    Hans, could you please do me a favour and convert the attached reports as well so that I can open them in design view?
    Attached Files Attached Files

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

    Re: Corrupted Report? (2003)

    See attachment. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Attached Files Attached Files

  8. #8
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupted Report? (2003)

    Hans
    What did you do to make the report point to a default printer instead of a specific one?
    I tried to work out differences using the first report you converted but I can't see any.
    Thanks
    Silverback
    Silverback

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

    Re: Corrupted Report? (2003)

    When I open the report in Giorgio's database in design view, I get the warning displayed below. I click OK, then save the report. From then on, the warning will not be displayed any more.
    Attached Images Attached Images
    • File Type: png x.png (8.8 KB, 0 views)

  10. #10
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington, Cheshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupted Report? (2003)

    Silly me. <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30> I tried doing that but all the save options were greyed out and I wasn't asked if I wanted to save changes. I've just realised that the DB was marked read only so no changes are allowed. Once I unpacked it and changed properties, it worked as you describe.
    Thanks
    Silverback
    Silverback

Posting Permissions

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