Runtime program - Filter by form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Malcolm P - 27 Jun 2005 12:09 GMT

I invested in Access 2003 and Visual Studio Tools for Office 2003 (which
includes the Access 2003 Developer Extensions).

Now I have a run time program...................but.......................
I want to do a Filter by Form. The runtime menue item Records lists the
following options: Apply filter/sort and Remove filter/sort. When I select
Apply Filter/Sort the runtime version performs a sort based on the criteria
that exsisted in the original Access program when I converted it into the
runtime version. I can not find a way to enter a new criteria.
Help!

Reply to this Message

Rick Brandt - 27 Jun 2005 12:43 GMT

> I invested in Access 2003 and Visual Studio Tools for Office 2003
> (which includes the Access 2003 Developer Extensions).
[quoted text clipped - 8 lines]
> enter a new criteria.
> Help!

In a Runtime app you must build and supply custom replacements for all menu bars
and toolbars. On those you can include options for applying and changing
filters. However; you will not be able to use Filter-By-Form as that is not
supported in the Runtime.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Malcolm P - 27 Jun 2005 14:38 GMT

Question: If runtime does not support Filter-by-Form then.............
why does it have the menue item Records which lists the following options:
Apply filter/sort and Remove filter/sort.

Reply to this Message

Rick Brandt - 27 Jun 2005 15:42 GMT

> Question: If runtime does not support Filter-by-Form
> then............. why does it have the menue item Records which lists
> the following options: Apply filter/sort and Remove filter/sort.

There are lots of ways to set, apply, and remove filters. Filter-By-Form is
only one of them. Are you sure you know what "Filter-By-Form" is? It is
not a generic term for filtering a form. It is a specific filtering tool
wherein an image of your form is produced on the screen only instead of
being tied to your data tables it is only used to apply filter criteria.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Malcolm P - 27 Jun 2005 17:23 GMT

Are you sure you know what "Filter-By-Form" is? It is

> not a generic term for filtering a form. It is a specific filtering tool
> wherein an image of your form is produced on the screen only instead of
> being tied to your data tables it is only used to apply filter criteria.

Please bear with me and let me try to explain my
problem........................
When using Access (not the runtime version), I open a form. There is an
icon that says Filter by Form. I click onto the icon and then I can fill in
a criteria under one of the columes. Then I click onto the icon Apply
Filter. Then I get a result if there are any records that match the
criteria. Then I click onto the icon Remove Filter.

When I convert the Access application to a runtime version, I open the
form. There is no icon now. There is however menue items: File, Edit,
Insert, Records, Windows, Help. I click onto Records. I get a drop down
menu: Apply Filter/Sort, Remove Filter/Sort, Refresh. When I click onto
Apply Filter/Sort I expected to be able to fill in a criteria, but I can not.
Why does it give me this menu item, "Apply Filter/Sort" and not let me use
a criteria????????? Why does it even list this menu item, Apply
Filter/Sort" if it not functional?????????????

Reply to this Message

Rick Brandt - 27 Jun 2005 18:09 GMT

> Please bear with me and let me try to explain my
> problem........................
[quoted text clipped - 3 lines]
> the icon Apply Filter. Then I get a result if there are any records
> that match the criteria. Then I click onto the icon Remove Filter.

Okay so far...

> When I convert the Access application to a runtime version, I open
> the form. There is no icon now.

That is right. That specific filtering interface called "Filter By Form" is
not supported in the Runtime. That specific interface though is not the
only way to build or apply a filter.

> There is however menue items:
> File, Edit, Insert, Records, Windows, Help. I click onto Records.
> I get a drop down menu: Apply Filter/Sort, Remove Filter/Sort,
> Refresh. When I click onto Apply Filter/Sort I expected to be
> able to fill in a criteria, but I can not.

Those menu items are used to "apply" or "remove" a filter that has already
been defined. They do not expose an interface for defining the filter. The
usual methods for defining a filter (except Filter-By-Form) can all be used
in the Runtime environment providing that you provide access to those
methods. As stated previously, when building a Runtime app the onus is on
you, the developer, to build and provide all Menus and Toolbars for the
interface. Almost none of the Menus and Toolbars that you see in the
full-blown Access product will be available in the Runtime.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message