Results 1 to 7 of 7
  1. #1
    ashu.doc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2012
    Posts
    124

    Button on report page

    Hi
    Is there anyway to put a cmd button on report page itself to print the report?

    thanks

  2. #2
    chris.williams is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Posts
    94
    Yes. Be sure to set the Display When option to Screen Only otherwise it will print out on the page. The easiest way is to assign a Macro to the On Click event of RunMenuCommand/PrintObject.

  3. #3
    ashu.doc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2012
    Posts
    124
    I have created a button on report page, with a macro event on click which will save the report as pdf, but what I meant was, the user cannot use that button on report page when screen only option is selected.

  4. #4
    chris.williams is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Posts
    94

    Button on report page

    Strange. I took a or existing report added a button and the "On Click" event and set the command bottom to be visible and display on on screen. It worked as expected.

    You might want to try with a new test report to validate basic functionality without any unknowns in preexisting reports.

  5. #5
    ashu.doc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2012
    Posts
    124
    HI
    SO you mean the button is actually working on the page of report? when I open a report it only shows zoom cursor report page.

  6. #6
    chris.williams is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Posts
    94
    Yes - I created a test report page from scratch and it worked correctly. It displayed on the report (screen) but did not on the printout.

  7. #7
    ashu.doc is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jul 2012
    Posts
    124
    Ok Chris, I found it what I was doing wrong, I was trying to see the button in print view, not the report view.
    Thanks a lot.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 09-11-2011, 05:19 AM
  2. Replies: 3
    Last Post: 08-07-2011, 09:22 PM
  3. Replies: 1
    Last Post: 07-07-2010, 11:06 AM
  4. Page break on report inserts empty page between
    By Galadrielle in forum Reports
    Replies: 0
    Last Post: 07-07-2010, 04:18 AM
  5. Replies: 1
    Last Post: 05-22-2010, 08:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums