Re: Filter equivalent for Access bound form

--- "David P. Lurie" <dbase4@xxxxxxxxxxx> wrote:

> Access 2003
> pg 7.4.3
> 
> What is the recommended approach to get the
> equivalent of a filter for an
> Access bound form?
> 
> The filter property of a bound form seems to be the
> equivalent of an Access
> client-side query of SELECT * FROM form.recordsource
> WHERE form.filter. That
> would have a performance penalty.

How much testing have you done?  I have never had a
problem with this, but then, I don't have to deal with
any huge datasets.

> 
> I change the SQL of pass-through queries dynamically
> at runtime to use as
> record sources for reports. That wouldn't work for
> forms, as not updatable.
> 
> Is the best approach to use an updatable view as the
> record source, then
> change the view definition at runtime as with a
> passthrough query?

Why would you need to do this?  If you want to show
different data to different users, then you reference
the user name (e.g. current_user or session_user) in
your view definition.

> 
> Would need a unique view name for multi-user
> reasons, perhaps including part
> of a timestamp string or sequence. The original
> view's insert, update and
> delete rules should still have valid syntax except
> for the new view name, as
> only the WHERE clause and view name are changed. The
> rules could be updated
> with VBA code at the same time as the view change.

Or you could just use unbound controls.  Not really
that difficult, but a lot of coding.  Most of us are
using Access in order to avoid all of that :-)

> 
> Thanks,
> 
> David P. Lurie
> 
> 
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 



                
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx