We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Advance filtering with run-time Access

schmir1
schmir1 asked
on
Medium Priority
361 Views
Last Modified: 2008-03-06
I would like to give my users, who don't have the full Access 97 package on their computer, the ability to do advance filtering.  I've given them right mouse press short cut menu but the "Advance Filter/Sort" and the "Filter by Form" don't work.  Do I need to include a library or something?

robert.schmitt@medtronic.com
Comment
Watch Question

Author

Commented:
Edited text of question
Seasons greetings,

Do you want to grant access to advanced filter from a form? Did you set the form-filter-option to Standard or Always? Will the user be able to set up a filter from a particular control? Did you set the control-filter-option to Standard or Always? Did you create your own contextual (right mouse button) menu? Otherwise, did you set the Start-up option 'Use contextual menus' to true? Has the user got access to the built in menus? If you did create your own contextual menus, did you enable/disable some menu-items?

Imagine!

Commented:
Does the right-mouse menu appear in runtime access??(I think NO but I'm not sure)
If you have your own toolbar just add the fileter buttons to this toolbar. Of course you also have to set allowfilter props to YES for the form.
perove
Hi.... in Access 2 I found that in runtime I had to allow the datasheet view before I could use the find function (right click). You could try this on your runtime version of your form.

The other option is to find out the shortcut key for bringup the filter sort box.... and call it in code (by a button) in ver 2 I would use a Sendkeys command.

SendKeys definitely won't work because Access 97 disables all
the "dangerous" menu items (like File | Open). The online help indicates that RunCommand can be used but it always generates an error with /runtime.

Author

Commented:
>Did you set the form-filter-option to Standard or Always?
I set the "Allow filters" property for the form to yes.  Is
there more I need to do?

>Did you set the control-filter-option to Standard or Always?
Don't know how to do this.

>Did you create your own contextual (right mouse button)
>menu? Otherwise, did you set the Start-up option 'Use
>contextual menus' to true? Has the user got access to the
>built in menus? If you did create your own contextual menus,
>did you enable/disable some menu-items?
I did create my own contextual menu and the run-time users
do see it when they press the right mouse button.  All menu
items are active (not grayed).  It's just that clicking on
"Filter by Form" doesn't do anything.  Also, making any
entry in the "Filter for" box will only work for simple
stuff.  Operators such as "Between ### and ###"  do not do
any filtering.  The form remains just as it was
(unfiltered).  works fine on PC that have the full Access97
package.

>If you have your own toolbar just add the fileter buttons
>to this toolbar.
I did create a toolbar but it does not show up for run-time
users. That's another issue.  I think I need to write code
to attach it at startup.

>>> Bob <<<

Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
You will probably start implementing "Filter by Form" before me since my priority is on another project for a while.  Let me know how it works out for you.  One problem that I see is that it will double the number of forms in the system.  I already have a bunch.  I may only implement it on certain forms.  I am also interested in doing "Advance filtering".  Let me know if you come across that in your endeavors.

>>> Bob <<<

Author

Commented:
I did try it and it works.  Still would like to find a way to do "Advanced filtering" also.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.