Spontaneous loss of subform bookmarks

[Tim]

Hi, has anyone experienced a spontaneous loss of a subform bookmark
(i.e. resetting to the first record), when the computer is idle.

I used to have a problem in NT4 when doing a couple of specific things
outside of access (launching internet explorer or adobe) that would
cause a loss of bookmarks within access. Since our migration to XP
though my database seems to do it spontaneously whilst the computer is
idle. I guess its actually something that XP is doing below the surface
that causes the behaviour, just looks to be spontaneous.

Ive posted on here before to see if anyone had heard of things outside
of access having the ability to cause loss of bookmarks, but no answer.
I'm reposting as its becoming more than just a nuisance. Any ideas
greatly appreciated. Thanks.

Tim

[Allen Browne]

A bound form should not lose bookmarks if the server and network are stable.

It is possible to get this kind of problem if you close the default
workspace. Access opens it again transparently, but you can get strange
errors such as invalid object references to the form's RecordsetClone.

--
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.

"Tim" <ti*********@yahoo.co.uk> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Hi, has anyone experienced a spontaneous loss of a subform bookmark
(i.e. resetting to the first record), when the computer is idle.

I used to have a problem in NT4 when doing a couple of specific things
outside of access (launching internet explorer or adobe) that would
cause a loss of bookmarks within access. Since our migration to XP
though my database seems to do it spontaneously whilst the computer is
idle. I guess its actually something that XP is doing below the surface
that causes the behaviour, just looks to be spontaneous.

Ive posted on here before to see if anyone had heard of things outside
of access having the ability to cause loss of bookmarks, but no answer.
I'm reposting as its becoming more than just a nuisance. Any ideas
greatly appreciated. Thanks.

Tim

[Tim]

The network is as stable as they get. It doesn't co-incide with network
errors. I've always put it down to something happening on the local
machine.

I'm definetly not conciously causing the default workspace to close, I
guess if this were happening then it would be associated with a bunch
of error messages and that's just not happening. After its happened if
you go to the top level list and reselect the line you were working on
then the event code kicks in and causes all of the subforms to become
realigned.

Am I truly unique???

Tim

[Allen Browne]

Ah: by bookmark you are referring to the current record of the subform (not
its Bookmark property.)

Someone may correct me, but I do not believe the connection to the data file
should time out if you have a bound form open.

Is there anything else that could be triggering this?
Code in the Timer event of a form?
A Requery somewhere?
Some event procedures that trigger dependencies?
Conditional Formatting?

--
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.

"Tim" <ti*********@yahoo.co.uk> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

The network is as stable as they get. It doesn't co-incide with network
errors. I've always put it down to something happening on the local
machine.

I'm definetly not conciously causing the default workspace to close, I
guess if this were happening then it would be associated with a bunch
of error messages and that's just not happening. After its happened if
you go to the top level list and reselect the line you were working on
then the event code kicks in and causes all of the subforms to become
realigned.

Am I truly unique???

Tim

[Tim]

Allen,
Yes, that is what I mean - the current record of the subform. Im not
sure if it does or doesn't stay perpetually connected, by I read
somewhere that having a constantly open recordset onto the back end
database within a hidden form can improve performance I did this and
the performance increase was very significant. The forms are bound
though so I'm not really sure why this is.

I really can't think of anything within the database that could be
triggering it. Certainly when we were on the NT4 platform the behaviour
was confined to very specific events such as opening internet explorer
or adobe reader.

There is timer events on the main form, but only that checks the time
and then quits the database if its in the middle of the night (needed
so morning back up routine doesn't get shot away).

A large proportion of the event procedures are dedicated to keeping the
forms controls/subforms aligned on the database in repsonse to record
changes. The behaviour causes misalignment in the form controls so it
can't be en event getting triggered.

Its written in access 97 so there isn't any conditional formatting.

Tim

[Allen Browne]

Inline.

--
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.

"Tim" <ti*********@yahoo.co.uk> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

There is timer events on the main form, but only that checks the time
and then quits the database if its in the middle of the night (needed
so morning back up routine doesn't get shot away).
You could try running without the timer event, just to see if it makes any
difference.

A large proportion of the event procedures are dedicated to keeping the
forms controls/subforms aligned on the database in repsonse to record
changes. The behaviour causes misalignment in the form controls so it
can't be en event getting triggered.

Unusual. How is this done? By setting the RecordSource of one subform in the
Current event of another?

[Tim Marshall]

> Unusual. How is this done? By setting the RecordSource of one subform in the

Current event of another?

Allen, you may have suggested this already, but does Tim have any on got
focus events that requery anything?

The other thing that comes to mind, though he didn't mention it, is the
question of whether this database is using linked tables - in some ODBC
set ups using linked tables against Oracle, for example, there is a
definite timing out period. I don't know if Jet linked tables can be
set up with a time out mechanism.

Just to throw out a couple of things to help or confuse... 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Tim]

I tried running with the timer event off and no difference.

The alignment in the subform controls is just about requerying controls
that are based on queries. i.e. At the top level the oncurrent event
will copy the index of the selected record onto a hidden control which
is used as a query parameter for the next level down. So the next level
down subform just needs requerying to align its records to the top
level. The main form is a large tab control with each level on a
seperate tab. It means that the 70% of the whole database is contained
on a single form with a lot of interdependency.

I guess this is pretty inelegant. In my defence I inherited the
database to look after, I didn't create it. Although that said it was
actually created by a software consultant.

Tim

[Tim]

Ive just checked it and there are no got focus events in the database
at all.

The back end of the database is linked tables to another access
database on a server. There are a few users on the back end.

[Allen Browne]

Bet that requerying is the issue.

--
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.

"Tim" <ti*********@yahoo.co.uk> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...

I tried running with the timer event off and no difference.

The alignment in the subform controls is just about requerying controls
that are based on queries. i.e. At the top level the oncurrent event
will copy the index of the selected record onto a hidden control which
is used as a query parameter for the next level down. So the next level
down subform just needs requerying to align its records to the top
level. The main form is a large tab control with each level on a
seperate tab. It means that the 70% of the whole database is contained
on a single form with a lot of interdependency.

I guess this is pretty inelegant. In my defence I inherited the
database to look after, I didn't create it. Although that said it was
actually created by a software consultant.

Tim