Acc2003 need filter on always or removed (can't do)

B

BillD

In my database I have 4 forms in a tab control (Contacts, Registration,
Payment, contribution). When I open the form contacts in past databases the
last entry in the form would appear. In this database all fields in the form
are blank. I have several control buttons in the form. If I click on "First
Record" or "Last Record" nothing happens, if I click on "Previous Record" I
get a message that I can not go to that record. I know the fields are
populated as I have checked the tables to verify that.
I looked into a filter and when I went to Records on the tool bar then
opened Advance Filter/sort there is one filter there. It has the following -
Field: Inactive Contact, and Criteria: 0 and 0 and 0. In the help section it
read to clear the filter open Advance and click on "Clear Grid". I did this
and when I closed and reopened the database the filter was back.
I am trying to find out how to remove the filter or have the filter on all
the time. When I open the form and click on Filter by Form than everything
works right. I open the form and the last record entered is visible and the
control buttons work.

The only thing I can think of that is different from my other databases is
that I have two check boxes in the form "inactive Contact" and "contribution
only". I have the tab order set up so that the two check boxes are at the
begining of the tab sequence Could this have anything to do witht the filter
reappearing after I delete it and needing to be turned on. My other two
databases I don't have a check box in one and the other has a check box but
at the end of the form and I don't have a filter problem.

Please advise again I want to remove the filter permanitly or have it set to
be on all the time. Should I try rearainging the tab order so the check box
is at the end.

Thanks for the help
 
K

Klatuu

Check the properties for the form. It sounds like the Data Entry property is
set to Yes. Data Entry forms will not show any existing records.
 
B

BillD

I checked the properties for the form and Data Entry = No
Here are my Properties as listed
Record Source: tblContacts
Filter: ((tblcontacts.LastName is null))
Order By: Blank
Allow Filters: Yes
Allow Edits: Yes
Allow Deletions: Yes
Allow Additions: Yes
Data Entry: No
Record Type: Dynaset
Record Locks: No Locks
Fetch Defaults: Yes

Any other thoughts
 
K

Klatuu

This is the problem:
Filter: ((tblcontacts.LastName is null))

If a blank form is opening, there are no records that meet the filter
criteria.
Also, the normal behavior is for the first record in a form's recordset to
be displayed when opened, not the last.
 
B

BillD

While I was waiting for your response I tried deleting the Filter entry and
then closed and reopened the data base and I still did not show any records
when I opened the form, and your right once I applied the filter the first
record opened I was wrong.
So even with the filter expression removed I still have to click on apply
filter in the tool bar to get the first record to show up or to get the
control buttons to work. without filter applied when I click the control
buttons firs or last record nothing happens.

Can you please tell me how I could solve this problem I am not that much of
an expert on the inner workings of Access. Even if I can get the filter to
stay on all the time that would be acceptable.
 
K

Klatuu

Where is the filter set? If it is just in the properties dialog. just
deleting it and closing the database will not do it. You need to open the
form in design view, delete the value from the dialog and save the form. If
it comes back it means the filteris being set by code somewhere. You need to
track that down and fix it.
 
B

BillD

I opened the form in design and the form properties does not show anything in
filter anymore (I deleted that). In Advance Filter there is no Field entry or
Criteria.

I deleted all of the control buttons and the code that went with it. When
looking in the VBA for my fmsContacts there is no code for the form

I saved and closed the form and database. When I open it back up and then
open the form all the fields are empty, once I click on "Form Filter" then
click "Apply Form" the first entry in the database appears.

I don't know where else to look it is not in the form properties, Advance
Filter, or the VBA module

Any Ideas where it could be or am I stuck just having to live with running
the filter everytime I open the form.
 
K

Klatuu

Check the code where the form is opened.
If it has a Where Clause in the OpenForm, that becomes the form's filter
property.
 
B

BillD

The form opens through my switchboard. When I looked at the properties for
the switchboard in design view I saw the following:
Filter: [ItemNumber]=0 AND [Argument]= 'Default'
Data Entry: No

Could this be the problem and if it is what should I do
 
K

Klatuu

Those are properties for the switchboard form, not anything the swithcboard
form would be opening. I really don't know where else to look.
--
Dave Hargis, Microsoft Access MVP


BillD said:
The form opens through my switchboard. When I looked at the properties for
the switchboard in design view I saw the following:
Filter: [ItemNumber]=0 AND [Argument]= 'Default'
Data Entry: No

Could this be the problem and if it is what should I do
--
BillD


Klatuu said:
Check the code where the form is opened.
If it has a Where Clause in the OpenForm, that becomes the form's filter
property.
Click to expand...
Click to expand...
 
B

BillD

One last thing than I noticed that now when I open up the Advance filter now
the field is "LastName" and the Criteria reads "Is Null and Is Null"
I did not enter that the program entered it on it's own I don't know if that
means anything if it does not then I will just have to click on the "Remove
Filter" each time I open the form

Thanks for you time
--
BillD


Klatuu said:
Those are properties for the switchboard form, not anything the swithcboard
form would be opening. I really don't know where else to look.
--
Dave Hargis, Microsoft Access MVP


BillD said:
The form opens through my switchboard. When I looked at the properties for
the switchboard in design view I saw the following:
Filter: [ItemNumber]=0 AND [Argument]= 'Default'
Data Entry: No

Could this be the problem and if it is what should I do
--
BillD


Klatuu said:
Check the code where the form is opened.
If it has a Where Clause in the OpenForm, that becomes the form's filter
property.
--
Dave Hargis, Microsoft Access MVP


:

I opened the form in design and the form properties does not show anything in
filter anymore (I deleted that). In Advance Filter there is no Field entry or
Criteria.

I deleted all of the control buttons and the code that went with it. When
looking in the VBA for my fmsContacts there is no code for the form

I saved and closed the form and database. When I open it back up and then
open the form all the fields are empty, once I click on "Form Filter" then
click "Apply Form" the first entry in the database appears.

I don't know where else to look it is not in the form properties, Advance
Filter, or the VBA module

Any Ideas where it could be or am I stuck just having to live with running
the filter everytime I open the form.
--
BillD


:

Where is the filter set? If it is just in the properties dialog. just
deleting it and closing the database will not do it. You need to open the
form in design view, delete the value from the dialog and save the form. If
it comes back it means the filteris being set by code somewhere. You need to
track that down and fix it.
--
Dave Hargis, Microsoft Access MVP


:

While I was waiting for your response I tried deleting the Filter entry and
then closed and reopened the data base and I still did not show any records
when I opened the form, and your right once I applied the filter the first
record opened I was wrong.
So even with the filter expression removed I still have to click on apply
filter in the tool bar to get the first record to show up or to get the
control buttons to work. without filter applied when I click the control
buttons firs or last record nothing happens.

Can you please tell me how I could solve this problem I am not that much of
an expert on the inner workings of Access. Even if I can get the filter to
stay on all the time that would be acceptable.
--
BillD


:

This is the problem:
Filter: ((tblcontacts.LastName is null))

If a blank form is opening, there are no records that meet the filter
criteria.
Also, the normal behavior is for the first record in a form's recordset to
be displayed when opened, not the last.
--
Dave Hargis, Microsoft Access MVP


:

I checked the properties for the form and Data Entry = No
Here are my Properties as listed
Record Source: tblContacts
Filter: ((tblcontacts.LastName is null))
Order By: Blank
Allow Filters: Yes
Allow Edits: Yes
Allow Deletions: Yes
Allow Additions: Yes
Data Entry: No
Record Type: Dynaset
Record Locks: No Locks
Fetch Defaults: Yes

Any other thoughts
--
BillD


:

Check the properties for the form. It sounds like the Data Entry property is
set to Yes. Data Entry forms will not show any existing records.
--
Dave Hargis, Microsoft Access MVP


:

In my database I have 4 forms in a tab control (Contacts, Registration,
Payment, contribution). When I open the form contacts in past databases the
last entry in the form would appear. In this database all fields in the form
are blank. I have several control buttons in the form. If I click on "First
Record" or "Last Record" nothing happens, if I click on "Previous Record" I
get a message that I can not go to that record. I know the fields are
populated as I have checked the tables to verify that.
I looked into a filter and when I went to Records on the tool bar then
opened Advance Filter/sort there is one filter there. It has the following -
Field: Inactive Contact, and Criteria: 0 and 0 and 0. In the help section it
read to clear the filter open Advance and click on "Clear Grid". I did this
and when I closed and reopened the database the filter was back.
I am trying to find out how to remove the filter or have the filter on all
the time. When I open the form and click on Filter by Form than everything
works right. I open the form and the last record entered is visible and the
control buttons work.

The only thing I can think of that is different from my other databases is
that I have two check boxes in the form "inactive Contact" and "contribution
only". I have the tab order set up so that the two check boxes are at the
begining of the tab sequence Could this have anything to do witht the filter
reappearing after I delete it and needing to be turned on. My other two
databases I don't have a check box in one and the other has a check box but
at the end of the form and I don't have a filter problem.

Please advise again I want to remove the filter permanitly or have it set to
be on all the time. Should I try rearainging the tab order so the check box
is at the end.

Thanks for the help
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering a form based on a filter on an open form 2
applying concatenate filter 1
Trick filter form combo with DoCmd.OpenForm and Data Entry property 2
Form Filter will not delete 2
Remove Filter before Search 1
Filter 1
Toggle Filter On and Off 2
Navigation Buttons on Forms 2

Top