Right-click filtering forms in runtime

[Chris v.]

I can't help but notice that the filtering (right-click on a control of a
form) is disabled in Access Runtime. There does not seem to be any way of
covering this need of filtering data to aid in "live" data analysis. As I
write applications for a non-profit that can't afford to purchase Access 2007
for all the managers this is a large problem. I appreciate how easy Access is
to learn and use, but this limitation has me questioning our choice in dbms.
Since the filtering based on a form control's data type is so well done in
Access 2007, do you see this capability being added to Runtime some time in
the future? If it is not in the plan, I strongly suggest the need to include
it.
Thanks for your consideration.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...d52a0ff221bd&dg=microsoft.public.access.forms

 

[AccessVandal via AccessMonster.com]

Please understand that not an acceptable solution to enable the filtering in
runtime. Most or all of us developers here prefer them to be disable.

You can an enable the filter in your Ribbon, go to Access Options - Current
Database - Ribbon and Toolbar Options - select the checkbox "Allow Full
Menus" and "Allow Default Shortcut Menus".

 

[Albert D. Kallal]

Since the filtering based on a form control's data type is so well done in
Access 2007, do you see this capability being added to Runtime some time
in
the future? If it is not in the plan, I strongly suggest the need to
include
it.
Thanks for your consideration.

Actually, it quite easy to add filtering ability to your runtime
applications.
Just create custom right click menu.

(I am at a loss as to why we have posters here suggesting that what you ask
for is difficult, or not needed). I think you question is a great question,
nod there is OFTEN then need for filtering as you ask.

I offer all kinds of filter options in my runtime applications.

You have MANY choices here to resolve this issue. One simple way is to build
a custom right click menu with the filter options.

How to do this is explained here:

http://office.microsoft.com/en-us/access/HA102825091033.aspx?pid=CH100621911033


For cut + edit + paste and + some filter options, your macro look like:

Macro Name Action Command
Cut RunCommand Cut
Copy RunCommand Copy
Paste RunCommand Paste
Filter by Selection RunCommand FilterBySelection
Filter By Not Selection RunCommand FilterExcludingSelection
Remove Filter Runcommand RemoveFilterSort

Save the above as a macro called MyMenu

Now, create a macro that calls the above menu macro:

eg:
Action Menu Name Menu Macro name Status Bar text
AddMenu MyRightClick MyMenu My Edit

save the above macro as say mEdit

Then, in the forms property sheet, in the "other" table, simply set the
shortcut menu as mEdit

That form will now have filtering in the runtime.

You could also create a VERY nice looking ribbon with filter options also.

So, really, in the runtime about the only limitation here is your
imagination and how you want to build and present the UI to the end user.

The runtime generally has all of the features of the full version, but you
as a developer usually have to write or build in those features that you
want in the runtime.

 

[Chris v.]

Thanks for your reply.

Access Options - Current Database - Ribbon and Toolbar Options - "Allow Full

Menus" and "Allow Default Shortcut Menus" are checked before packaging and signing the database. RUNTIME disables the menus for the controls in the application I'm distrubuting to the users. Did I miss something in your reply? (Of course those options are not available in the runtime application.)

I appreciate your interest in this matter.

 

[Chris v.]

Thank your for your reply.
I have read the article and it appears helpful. Do you think I will be able
to create filters for date fields such as "Last Quarter" or "This Year" OR
"Begins with" for text boxes using only macros? Thanks again for your
interest in this issue.

 

[AccessVandal via AccessMonster.com]

Have you considered Allen Browne's sample in your other thread? Might be
better instead of using ribbons.

Nobody's saying it's not easy create custom menus, but the matter of choice
and preferences.

Once you are more experience in designing a databse, you'll see why you
rather have it disabled in runtime and leave that to the full version.