Finding the form property ServerFilterByForm

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Due to large amounts of data on my Oracle database table, I would like to have the user see the Filer By Form before the data is displayed. Access help file says "The easiest way to set the ServerFilterByForm property is by using a form's property sheet." When I go into the forms property sheet I see no such property. I am currently using Access 2002 SP-1. Is there a bug with this version or am I looking in the wrong place?
 
connie said:
Due to large amounts of data on my Oracle database table, I would
like to have the user see the Filer By Form before the data is
displayed. Access help file says "The easiest way to set the
ServerFilterByForm property is by using a form's property sheet."
When I go into the forms property sheet I see no such property. I am
currently using Access 2002 SP-1. Is there a bug with this version
or am I looking in the wrong place?
Click to expand...

Are you working in an MDB file or an ADP? I think the
ServerFilterByForm property is only available in an ADP.
 
----- Dirk Goldgar wrote: ----

connie said:
Due to large amounts of data on my Oracle database table, I woul
like to have the user see the Filer By Form before the data i
displayed. Access help file says "The easiest way to set th
ServerFilterByForm property is by using a form's property sheet.
When I go into the forms property sheet I see no such property. I a
currently using Access 2002 SP-1. Is there a bug with this versio
or am I looking in the wrong place
Click to expand...

Are you working in an MDB file or an ADP? I think th
ServerFilterByForm property is only available in an ADP

--
Dirk Goldgar, MS Access MV
www.datagnostics.co

(please reply to the newsgroup

I am using an mdb form. What is an ADP form
 
Connie said:
I am using an mdb form. What is an ADP form?
Click to expand...

An ADP is an Access Data Project. This type of Access application was
introduced with Access 2000. Instead of using either local tables or
linked tables, as I gather you're using with your Oracle back-end, an
Access Data Project maintains a direct connection to the back-end
database, and directly manipulates the tables, queries, and stored
procedures in the back-end. I *think* an ADP's data store has to be a
SQL Server database, but I'm not 100% sure. Anyhow, the ServerFilter
and ServerFilterByForm properties are only relevant to forms in ADPs,
not in normal Access MDB databases.

I think you're going to have to implement your own version of the
ServerFilterByForm, giving your users a filter form of some sort that
you use to set the recordsource query of your form.
 
Thank you for helping me with this. I will look further in the MS Access website to see if an ADP's data store has to be SQL Server.
 
Back
Top