Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Ms access

  • 02-05-2019 03:35PM
    #1
    tritriagain
    Registered Users, Registered Users 2 Posts: 1,191 ✭✭✭


    I have a bit of a weird one here. I have a database which is working fine and all my forms are opening maximised no problem. However when I open a report maximised (docmd.Maximise) the report opens maximised but no data is shown. I accidentally clicked on the open report and where I clicked data appeared. Tried it again in a different area and same thing happened. Any one any ideas. Probably something simple but it has me baffled.


Comments

  • #2
    Seth Brundle
    Moderators, Politics Moderators, Paid Member Posts: 44,087 Mod ✭✭✭✭Seth Brundle


    If you close access completely and reopen and then manually reopen the report is it ok?
    What code are you using to oepn your report? Are you using Docmd.OpenReport...
    Is the report set to open in preview mode rather than print mode?
    Is the report filtered within your application?


  • #3
    tritriagain
    Registered Users, Registered Users 2 Posts: 1,191 ✭✭✭tritriagain


    Seth Brundle wrote: »
    If you close access completely and reopen and then manually reopen the report is it ok?
    What code are you using to oepn your report? Are you using Docmd.OpenReport...
    Is the report set to open in preview mode rather than print mode?
    Is the report filtered within your application?

    I used a command button and used the wizard to select open report from a form that requires a date. The report works fine if I don't try and maximised it.
    When I open the report manually in print view it works but not in report view.


  • #4
    Seth Brundle
    Moderators, Politics Moderators, Paid Member Posts: 44,087 Mod ✭✭✭✭Seth Brundle


    Try it on a different PC and see if the issue repeats itself.
    Sometimes weird things like this resolve themselves by recreating the report (even via a Save As)


  • #5
    tritriagain
    Registered Users, Registered Users 2 Posts: 1,191 ✭✭✭tritriagain


    Seth Brundle wrote: »
    Try it on a different PC and see if the issue repeats itself.
    Sometimes weird things like this resolve themselves by recreating the report (even via a Save As)

    Thanks for help. I created a new button and ran code instead of using wizard and it's working fine now.


  • #6
    Seth Brundle
    Moderators, Politics Moderators, Paid Member Posts: 44,087 Mod ✭✭✭✭Seth Brundle


    Cool.
    I presume that you've compiled your code also!


  • Advertisement
  • #7
    tritriagain
    Registered Users, Registered Users 2 Posts: 1,191 ✭✭✭tritriagain


    Seth Brundle wrote: »
    Cool.
    I presume that you've compiled your code also!

    Yeah working fine. I'm sure I'll run into more problems so keep an eye on this threadðŸ˜ðŸ˜. Thanks again for your help


Advertisement