----------------
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.
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".
Chris v. wrote:
>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.
--
Please Rate the posting if helps you.
Message posted via http://www.accessmonster.com
> 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.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOO...@msn.com
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.
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.
Chris v. wrote:
>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.
--
Please Rate the posting if helps you.
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200909/1