(Msg. 1) Posted: Thu Jul 03, 2008 8:25 am
Post subject: Weird Filtering Problem?? Archived from groups: microsoft>public>access (more info?)
I have a database which has suddenly developed a weird problem.
When the user opens a form it is blank although there are many records in
the data source. This is a form which has been in production for a couple of
years. No changes have been made to it. There are no filters on it but if
you click Form Filter, do not enter any criteria, then apply filter, all the
records show up. There are no saved filters on the underlying form or in the
code. This has happened five times to different forms over the last three
weeks. One of which is in a separate FE connected to the back end and this
FE was not touched at all. Another occasion happened in the development/test
environment attached to a testing BE.
Any ideas on what is causing this and how to fix it? Was there a recent
Office update which may have caused this?
(Msg. 2) Posted: Thu Jul 03, 2008 11:57 pm
Post subject: Re: Weird Filtering Problem?? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
If this is Access 2007, open the form in design view and set the
FilterOnLoad property to No.
If that's not what's going on, ask Access what's happening. Open the
Immediate Window (Ctrl+G), and ask it things like:
? Forms!Form1.Filter
? Forms!Form1.FilterOn
? Forms!Form1.RecordSource
? Forms!Form1.DataEntry
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"AlienzDDS" <AlienzDDS.TakeThisOut@discussions.microsoft.com> wrote in message
news:EFA93B30-9C0A-46D0-B5CF-D8AE77A78BE9@microsoft.com...
>I have a database which has suddenly developed a weird problem.
>
> When the user opens a form it is blank although there are many records in
> the data source. This is a form which has been in production for a couple
> of
> years. No changes have been made to it. There are no filters on it but
> if
> you click Form Filter, do not enter any criteria, then apply filter, all
> the
> records show up. There are no saved filters on the underlying form or in
> the
> code. This has happened five times to different forms over the last three
> weeks. One of which is in a separate FE connected to the back end and
> this
> FE was not touched at all. Another occasion happened in the
> development/test
> environment attached to a testing BE.
>
> Any ideas on what is causing this and how to fix it? Was there a recent
> Office update which may have caused this?
>
> Thanks - Ali.
(Msg. 3) Posted: Thu Jul 03, 2008 11:57 pm
Post subject: Re: Weird Filtering Problem?? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I should have mentioned that one of the times this happened it was a query
not a form. This query is in a separate front end and is auto-emailed to a
group on a scheduled task. It suddenly emailed empty the day after the
problem surfaced in the main FE.
For this reason I do not think that the form settings are relevant.
"Allen Browne" wrote:
> If this is Access 2007, open the form in design view and set the
> FilterOnLoad property to No.
>
> If that's not what's going on, ask Access what's happening. Open the
> Immediate Window (Ctrl+G), and ask it things like:
> ? Forms!Form1.Filter
> ? Forms!Form1.FilterOn
> ? Forms!Form1.RecordSource
> ? Forms!Form1.DataEntry
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html > Reply to group, rather than allenbrowne at mvps dot org.
>
> "AlienzDDS" <AlienzDDS.DeleteThis@discussions.microsoft.com> wrote in message
> news:EFA93B30-9C0A-46D0-B5CF-D8AE77A78BE9@microsoft.com...
> >I have a database which has suddenly developed a weird problem.
> >
> > When the user opens a form it is blank although there are many records in
> > the data source. This is a form which has been in production for a couple
> > of
> > years. No changes have been made to it. There are no filters on it but
> > if
> > you click Form Filter, do not enter any criteria, then apply filter, all
> > the
> > records show up. There are no saved filters on the underlying form or in
> > the
> > code. This has happened five times to different forms over the last three
> > weeks. One of which is in a separate FE connected to the back end and
> > this
> > FE was not touched at all. Another occasion happened in the
> > development/test
> > environment attached to a testing BE.
> >
> > Any ideas on what is causing this and how to fix it? Was there a recent
> > Office update which may have caused this?
> >
> > Thanks - Ali.
>
>
(Msg. 4) Posted: Fri Jul 04, 2008 3:12 pm
Post subject: Re: Weird Filtering Problem?? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I don't understand what you are doing.
Filtering a form that isn't a form, with no data, and no records show up.
Perhaps you could start a new thread explaining the question, and leave this
thred to die a natural death.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"AlienzDDS" <AlienzDDS.TakeThisOut@discussions.microsoft.com> wrote in message
news:A846A3A0-2A4E-4C9A-94E3-3F6D977F8F8C@microsoft.com...
>I should have mentioned that one of the times this happened it was a query
> not a form. This query is in a separate front end and is auto-emailed to
> a
> group on a scheduled task. It suddenly emailed empty the day after the
> problem surfaced in the main FE.
>
> For this reason I do not think that the form settings are relevant.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other