Results 1 to 6 of 6
  1. #1
    AAAndy is offline Advanced Beginner
    Windows 7 64bit Access 2013 32bit
    Join Date
    Aug 2016
    Posts
    68

    Thumbs up Is there any vba code that will detect when print icon is hit in the menu bar of access?


    Is there any vba code that will detect when print icon is hit in the menu bar of access? Image attached to show print icon.

    Click image for larger version. 

Name:	print.jpg 
Views:	23 
Size:	64.4 KB 
ID:	25742

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    There may be a way to detect it. However, the easy answer is, no. A conventional approach would be to hide the Ribbon or make a custom Ribbon. Then you can control what the user does and when.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Perhaps it would help if you tell us what you hope to accomplish with this.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    AAAndy is offline Advanced Beginner
    Windows 7 64bit Access 2013 32bit
    Join Date
    Aug 2016
    Posts
    68
    I want to track the number of times this is printed

  5. #5
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    I suspect that ItsMe's advice is right on the mark...basically:

    1. Hide all native methods of printing
    2. Provide your own method of printing
    3. Have a Table with a Record for each Report
    4. Have a Numeric Field in the Table for 'times printed'
    5. Increment that number each time a Report is printed

    A lot of work to do this...I hope your need is worth the effort!

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  6. #6
    AAAndy is offline Advanced Beginner
    Windows 7 64bit Access 2013 32bit
    Join Date
    Aug 2016
    Posts
    68
    I will do that, thanks for everyone's help

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

Similar Threads

  1. Replies: 1
    Last Post: 11-07-2015, 12:07 PM
  2. Print Preview Custom Shortcut Menu
    By Swatskeb in forum Modules
    Replies: 2
    Last Post: 05-22-2014, 08:02 PM
  3. Access Icon Size?
    By WhiskyLima in forum Access
    Replies: 2
    Last Post: 11-28-2013, 05:20 AM
  4. VBA Code to Print MS Access Reports to PDFCreator
    By NeilIrving in forum Programming
    Replies: 3
    Last Post: 11-20-2012, 07:08 AM
  5. How to retrieve my Access icon?
    By djclntn in forum Access
    Replies: 8
    Last Post: 08-07-2012, 08:14 AM

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