Launching internet explorer or Adobe causes a datasheet list form to go to the first record

[Tim Stevens]

Hello,
This is the first time I have had to resort to posting on here, as Ive
always been able to find a solution to my problems in the past by
browsing postings by others. So, to start with I thank you all for so
much help in the past ...

To my current problem... Ive a fairly sizable application, front end
local and back end networked both on access 97. All running on NT4
worstation front ends, think the back end servers are 2000, but this
is pretty transparent to me. The front end is essentially one very
large tab form with numerous interlinked subforms. Essentially the
tabs are hierarchical and up at the top level is a datasheet subform
that controls the reference for most of the other sub forms.

The problem I am experiencing is that you'll have an item selected on
the top level and the subforms aligned to this, but then if you launch
either internet explorer or adobe the top level items resets to the
first item on the list, the sub forms remain on the old reference and
so there is misalignment between the main form and the sub forms.

The requerying of the subforms is done through code whenever a change
is made to the item selected on the top level list. So whatever is
causing the list to revert to the first item in the list does not seem
to actually trigger an access event, elsewise the subforms would get
requeried as well.

Ive had countless goes at it but don't really know where to start as
the problem appears almost to be operating system related rather than
access. Any thoughts or ideas would be very much appreciated.
(Apologies in advance that this is all pretty fred flintstone
technology)

Thanks in advance
Tim

[Larry Linson]

Could you clarify how, and from where, you are launching IE or Adobe?

There's no guarantee that someone can help, but without some detail, no one
is likely to be able to.

Larry Linson
Microsoft Access MVP
"Tim Stevens" <ti*********@yahoo.co.uk> wrote in message
news:a8**************************@posting.google.c om...

Hello,
This is the first time I have had to resort to posting on here, as Ive
always been able to find a solution to my problems in the past by
browsing postings by others. So, to start with I thank you all for so
much help in the past ...

To my current problem... Ive a fairly sizable application, front end
local and back end networked both on access 97. All running on NT4
worstation front ends, think the back end servers are 2000, but this
is pretty transparent to me. The front end is essentially one very
large tab form with numerous interlinked subforms. Essentially the
tabs are hierarchical and up at the top level is a datasheet subform
that controls the reference for most of the other sub forms.

The problem I am experiencing is that you'll have an item selected on
the top level and the subforms aligned to this, but then if you launch
either internet explorer or adobe the top level items resets to the
first item on the list, the sub forms remain on the old reference and
so there is misalignment between the main form and the sub forms.

The requerying of the subforms is done through code whenever a change
is made to the item selected on the top level list. So whatever is
causing the list to revert to the first item in the list does not seem
to actually trigger an access event, elsewise the subforms would get
requeried as well.

Ive had countless goes at it but don't really know where to start as
the problem appears almost to be operating system related rather than
access. Any thoughts or ideas would be very much appreciated.
(Apologies in advance that this is all pretty fred flintstone
technology)

Thanks in advance
Tim

[Tim Stevens]

Larry,
It happens in two circumstances:

- first if youve got the database open and then just launch internet
explorer normally or open a PDF file from windows explorer

- second, there is a activeX browser built into the database on a pop
up form, if you launch this to open a pdf then it happens again.

I guess from the lack of response that this isn't something that alot
of people have experienced, or that its just such old technology I'm
using that nobodys interested these days??

Any starting point that anyone could give would be great cos its
really got me flumoxed
"Larry Linson" <bo*****@localhost.not> wrote in message news:<bZg7d.78$x65.71@trnddc06>...

Could you clarify how, and from where, you are launching IE or Adobe?

There's no guarantee that someone can help, but without some detail, no one
is likely to be able to.

Larry Linson
Microsoft Access MVP
"Tim Stevens" <ti*********@yahoo.co.uk> wrote in message
news:a8**************************@posting.google.c om...

Hello,
This is the first time I have had to resort to posting on here, as Ive
always been able to find a solution to my problems in the past by
browsing postings by others. So, to start with I thank you all for so
much help in the past ...

To my current problem... Ive a fairly sizable application, front end
local and back end networked both on access 97. All running on NT4
worstation front ends, think the back end servers are 2000, but this
is pretty transparent to me. The front end is essentially one very
large tab form with numerous interlinked subforms. Essentially the
tabs are hierarchical and up at the top level is a datasheet subform
that controls the reference for most of the other sub forms.

The problem I am experiencing is that you'll have an item selected on
the top level and the subforms aligned to this, but then if you launch
either internet explorer or adobe the top level items resets to the
first item on the list, the sub forms remain on the old reference and
so there is misalignment between the main form and the sub forms.

The requerying of the subforms is done through code whenever a change
is made to the item selected on the top level list. So whatever is
causing the list to revert to the first item in the list does not seem
to actually trigger an access event, elsewise the subforms would get
requeried as well.

Ive had countless goes at it but don't really know where to start as
the problem appears almost to be operating system related rather than
access. Any thoughts or ideas would be very much appreciated.
(Apologies in advance that this is all pretty fred flintstone
technology)

Thanks in advance
Tim