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
2  1658 
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*********@ya hoo.co.uk> wrote in message
news:a8******** *************** ***@posting.goo gle.com... 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,
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*****@localh ost.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*********@ya hoo.co.uk> wrote in message
news:a8******** *************** ***@posting.goo gle.com... 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: james.dixon |
last post by:
Hi
I was wondering if anyone else had had this problem before (can't find
anything on the web about it).
I have three select elements (list boxes - from here on I'll refer to
them as 'the list boxes'). Users can add and remove items from the
list boxes.
When the users are adding and removing items, the list boxes are single
|
by: deko |
last post by:
I have a subform datasheet that contains a full year of records sorted by a
date field. I'm trying to programmatically move the record selector on the
datasheet to the first record that matches a particular date. For example,
the user clicks a button and the record selector moves to the first record
that matches today's date.
I was thinking something like this, but I'm not having any luck:
Dim rst As DAO.Recordset
Set rst =...
|
by: deko |
last post by:
I have a form with a subform datasheet - I need code behind the OnDelete
event of the subform:
Private Sub Form_Delete(Cancel As Integer)
'do something that depends on which record is deleted
End Sub
This works okay when only one record is selected and the delete key is
pressed (or right-click delete is selected - makes no difference). But if
multiple records are selected in the datasheet, the code runs for the first
|
by: Yuki |
last post by:
I am trying to find out if I can have a specific record that has been
selected in a list box be opened in datasheet view. I can't seem to
find where this can happen or what I need to use to make it happen?
Does anyone have any ideas? My list box is currently tied to an option
group so that they can sort the list box in order of how they want to
search for certain records. It is a maintenance form. I want the user
to be able to select...
|
by: George Kandaz |
last post by:
Steve, I posted a question to your last post almost a week ago, but
never heard from you again. Please read my last message, as follows.
Thanks.
---------------------------------------------------------------------------
Steve:
I have followed your instructions to a "T". However, I continue to
| | |
by: Apu Nahasapeemapetilon |
last post by:
Hello and thank you in advance for your help.
Can anyone think of a reason why this code would work properly on one PC,
but not another?
I've got a System.Windows.Forms.UserControl that products events which I
want to consume (sink) within Internet Explorer.
I'm following the instructions at:
ms-http://support.microsoft.com/default.aspx?kbid=313891.
|
by: Bill |
last post by:
This database has no forms. I am viewing an Access table in datasheet
view. I'd like to execute a macro to execute a function (using
"runcode"). In the function, I'll reading data from the record the
cursor was on in the datasheet at the time I executed the macro.
So, the questions are: 1) In the macro, how to I get my hands on the
record key or record data of the record the cursor was on in the
datasheet at the time I executed the...
|
by: Danny J. Lesandrini |
last post by:
-- previously posted on newsgroup :: <microsoft.public.access--
Has anyone else noticed this behavior?
Focus jumping from current cell to upper left in embedded datasheet.
If not, would you be willing to test your environment and report back?
I posted this question back in May because a client using our application
reported it. We could only reproduce it on our network if we modified the
configuration. Now, however, it's happening...
|
by: eko99312 |
last post by:
Let's say I have this form called Attendance List. The list was in datasheet form. In the list there were names and date checklist. The question is, I want to edit one of the names by double clicking on the datasheet and it will pop up Employee Form. To pop up Employee Form by double clicking on the names are easy, but the trick is I want the Employee Form shows the specific name that I wanted (or the specific name record), normally it will open...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
