Share via

dynamic filtering on reports in Access Runtime mode

Anonymous
2020-05-01T13:16:25+00:00

I've created a rpeort in an Access db I made and the user can right click on any of the report fields and filter the data shown on the rpeort. This works great when access is in ormal mode but I distribute this app to my users in .accdr Runtime mode and the right click to filter on the rpeort does not seem to work in runtime mode. ;-( Is there any way around this?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2020-05-01T13:33:01+00:00

    Yes I know, isn't that a PITA?

    You will have to create those menus yourself. There is a way to do that via macros, and another way via commandbars. For a nice donation, this tool takes the hard work away: 

    http://dev-soln.com/access-shortcut-right-click-tool/

    Was this answer helpful?

    0 comments