This causes embedded subform datasheets to requery, forcing the cursor into
the first cell of the first row of the datasheet. However, this only happens
when the form was opened with a filter criteria passed in the DoCmd.OpenForm
method.
Microsoft has examined the problem and said we should rewrite the application
and remove all code that opens forms with a filter criteria. I just don't believe
it has to be that way, but I can't find a solution.
Has anybody ever seen this sort of behavior before, and if so, how can you
prevent a form from being required every 5 minutes by events outside of Access?
--
Danny J. Lesandrini
dlesa...@hotmail.com
http://amazecreations.com/datafast
--
Wayne
If you feel this answer has been useful please check the "was this post
helpful" so I get some feedback. Thanks.
I appreciate the effort, but I don't even understand what you wrote.
I'm not a network guy, and don't understand group policies at all. My first
suggestion was to relax the policy, but that's not going to happen. I was
just hoping that a fellow Access developer has run across this and found
a solution to the problem.
Refreshing group policies forces Access to requery subforms on filtered
parent forms. This doesn't make sense to me, but I've reproduced it, and
so has Microsoft.
In a perfect world, someone will tell me which Registry entry to set to zero,
and the problem will go away. Alternatively, I'll be redeisgning this program
to avoid setting filter criteria when opening any form.
--
Danny J. Lesandrini
dlesa...@hotmail.com
http://amazecreations.com/datafast
"Wayne-in-Manchester" <WayneinM...@discussions.microsoft.com> wrote ...
DO you lose your filter criteria? or is it just a plain requery without
losing your filter?
Gary Townsend
Spatial Mapping Ltd.
"Danny J. Lesandrini" <dlesa...@hotmail.com> wrote in message
news:e9Tvb2Ge...@TK2MSFTNGP03.phx.gbl...
The filter criteria isn't lost and nothing else changes. Users noticed this when
they were typing in the Zoom box for memo fields, and the policy refreshed,
moving the cursor to the first field of the datasheet, which was a limit-to-list
drop down box. Inserting a memo-field's worth of text into it made for some
unhappy users.
Here is the DOS command I execute to force the group policy.
gpupdate /target:user /force
Thanks for your thoughts. I know this is an odd one. I'm in the process of
redesigning the app to avoid filters, but that seems hokey.
--
Danny J. Lesandrini
dlesa...@hotmail.com
http://amazecreations.com/datafast
"Gary Townsend (Spatial Mapping Ltd.)" <garytNA...@spatialmapping.com> wrote ...
Gary Townsend
Spatial Mapping Ltd.
"Danny J. Lesandrini" <dlesa...@hotmail.com> wrote in message
news:u$9CLpIeG...@TK2MSFTNGP04.phx.gbl...
Thanks for taking an interest. To test if you have the issue, simply
open a filtered form with a subform that has a couple of records.
Place the cursor in row 2, column 3 and leave it overnight. When you
come in the next morning, if the cursor is in row 1 column 1, then
your group policy refresh caused the same issue.
What makes this a problem is the network admin's insistance that
the policy be reapplied/refreshed every 5 minutes. It probably
does happen to apps of yours that are on networks with such group
policies, but if it doesn't happen while you're editing a record, you
would never notice it.
--
Danny J. Lesandrini
dlesa...@hotmail.com
http://amazecreations.com/datafast
"Gary Townsend (Spatial Mapping Ltd.)" wrote ...
>This causes embedded subform datasheets to requery, forcing the cursor into
>the first cell of the first row of the datasheet. However, this only happens
>when the form was opened with a filter criteria passed in the DoCmd.OpenForm
>method.
Interesting. Can you use the WhereConditions instead? I've hardly
ever used the filter criteria.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Danny J. Lesandrini
dlesa...@hotmail.com
http://amazecreations.com/datafast
"Tony Toews" <tto...@telusplanet.net> wrote ...