Ive been searching past postings and anyone who has ever asked this question
has been ignored. Is there anyway to prevent the database from minimizing
after the hyperlink is clicked? Is it just not a possibility or why has no
one ever had this question answered?

Hendricks97 wrote:
> Ive been searching past postings and anyone who has ever asked this question
> has been ignored. Is there anyway to prevent the database from minimizing
> after the hyperlink is clicked? Is it just not a possibility or why has no
> one ever had this question answered?

Most likely not ignored, just nobody had an answer. Like me.

--
--
Travis
MayDay Computers

I don't see the problem... I tested it, and when I closed the instance of
Access that was started with the hyperlinked db, the original db was still
there on the screen in all its glory. In fact, the original db never was
minimized.
So I'm confused as to what the problem is.

"Hendricks97" wrote:

> Ive been searching past postings and anyone who has ever asked this question
> has been ignored. Is there anyway to prevent the database from minimizing
> after the hyperlink is clicked? Is it just not a possibility or why has no
> one ever had this question answered?

maybe it has something to do with the fact that the hyperlink is directed to
another access database

"Niniel" wrote:

> I don't see the problem... I tested it, and when I closed the instance of
> Access that was started with the hyperlinked db, the original db was still
> there on the screen in all its glory. In fact, the original db never was
> minimized.
> So I'm confused as to what the problem is.
>
> "Hendricks97" wrote:
>
> > Ive been searching past postings and anyone who has ever asked this question
> > has been ignored. Is there anyway to prevent the database from minimizing
> > after the hyperlink is clicked? Is it just not a possibility or why has no
> > one ever had this question answered?

I am aware of that, and that's exactly what I tested. On a form in one db I
put a hyperlink to a db on another drive, and I was unable to replicate your
problem.

"Hendricks97" wrote:

> maybe it has something to do with the fact that the hyperlink is directed to
> another access database
>
> "Niniel" wrote:
>
> > I don't see the problem... I tested it, and when I closed the instance of
> > Access that was started with the hyperlinked db, the original db was still
> > there on the screen in all its glory. In fact, the original db never was
> > minimized.
> > So I'm confused as to what the problem is.
> >
> > "Hendricks97" wrote:
> >
> > > Ive been searching past postings and anyone who has ever asked this question
> > > has been ignored. Is there anyway to prevent the database from minimizing
> > > after the hyperlink is clicked? Is it just not a possibility or why has no
> > > one ever had this question answered?

do you have the hyperlink added through code or inserted via the menu bar?

"Niniel" wrote:

> I am aware of that, and that's exactly what I tested. On a form in one db I
> put a hyperlink to a db on another drive, and I was unable to replicate your
> problem.
>
> "Hendricks97" wrote:
>
> > maybe it has something to do with the fact that the hyperlink is directed to
> > another access database
> >
> > "Niniel" wrote:
> >
> > > I don't see the problem... I tested it, and when I closed the instance of
> > > Access that was started with the hyperlinked db, the original db was still
> > > there on the screen in all its glory. In fact, the original db never was
> > > minimized.
> > > So I'm confused as to what the problem is.
> > >
> > > "Hendricks97" wrote:
> > >
> > > > Ive been searching past postings and anyone who has ever asked this question
> > > > has been ignored. Is there anyway to prevent the database from minimizing
> > > > after the hyperlink is clicked? Is it just not a possibility or why has no
> > > > one ever had this question answered?

I used the menu command Insert Hyperlink to place the hyperlink on the form.
I also created a hyperlink field in a table and entered the path to the
other db, and that didn't close the original db either.


"Hendricks97" wrote:

> do you have the hyperlink added through code or inserted via the menu bar?
>
> "Niniel" wrote:
>
> > I am aware of that, and that's exactly what I tested. On a form in one db I
> > put a hyperlink to a db on another drive, and I was unable to replicate your
> > problem.
> >
> > "Hendricks97" wrote:
> >
> > > maybe it has something to do with the fact that the hyperlink is directed to
> > > another access database
> > >
> > > "Niniel" wrote:
> > >
> > > > I don't see the problem... I tested it, and when I closed the instance of
> > > > Access that was started with the hyperlinked db, the original db was still
> > > > there on the screen in all its glory. In fact, the original db never was
> > > > minimized.
> > > > So I'm confused as to what the problem is.
> > > >
> > > > "Hendricks97" wrote:
> > > >
> > > > > Ive been searching past postings and anyone who has ever asked this question
> > > > > has been ignored. Is there anyway to prevent the database from minimizing
> > > > > after the hyperlink is clicked? Is it just not a possibility or why has no
> > > > > one ever had this question answered?

Could it be some sort of property setting or is it due to the versions? Im
using 2000 SR-1 Premium (9.0.7616 SP-3) on Windows 2000 5.00.2195 Service
Pack 4. Im starting to get a headache trying to figure this out

"Niniel" wrote:

> I used the menu command Insert Hyperlink to place the hyperlink on the form.
> I also created a hyperlink field in a table and entered the path to the
> other db, and that didn't close the original db either.
>
>
> "Hendricks97" wrote:
>
> > do you have the hyperlink added through code or inserted via the menu bar?
> >
> > "Niniel" wrote:
> >
> > > I am aware of that, and that's exactly what I tested. On a form in one db I
> > > put a hyperlink to a db on another drive, and I was unable to replicate your
> > > problem.
> > >
> > > "Hendricks97" wrote:
> > >
> > > > maybe it has something to do with the fact that the hyperlink is directed to
> > > > another access database
> > > >
> > > > "Niniel" wrote:
> > > >
> > > > > I don't see the problem... I tested it, and when I closed the instance of
> > > > > Access that was started with the hyperlinked db, the original db was still
> > > > > there on the screen in all its glory. In fact, the original db never was
> > > > > minimized.
> > > > > So I'm confused as to what the problem is.
> > > > >
> > > > > "Hendricks97" wrote:
> > > > >
> > > > > > Ive been searching past postings and anyone who has ever asked this question
> > > > > > has been ignored. Is there anyway to prevent the database from minimizing
> > > > > > after the hyperlink is clicked? Is it just not a possibility or why has no
> > > > > > one ever had this question answered?

I don't know, sorry.

I have A 2002 SP 1 on XP Pro.

"Hendricks97" wrote:

> Could it be some sort of property setting or is it due to the versions? Im
> using 2000 SR-1 Premium (9.0.7616 SP-3) on Windows 2000 5.00.2195 Service
> Pack 4. Im starting to get a headache trying to figure this out
>
> "Niniel" wrote:
>
> > I used the menu command Insert Hyperlink to place the hyperlink on the form.
> > I also created a hyperlink field in a table and entered the path to the
> > other db, and that didn't close the original db either.
> >
> >
> > "Hendricks97" wrote:
> >
> > > do you have the hyperlink added through code or inserted via the menu bar?
> > >
> > > "Niniel" wrote:
> > >
> > > > I am aware of that, and that's exactly what I tested. On a form in one db I
> > > > put a hyperlink to a db on another drive, and I was unable to replicate your
> > > > problem.
> > > >
> > > > "Hendricks97" wrote:
> > > >
> > > > > maybe it has something to do with the fact that the hyperlink is directed to
> > > > > another access database
> > > > >
> > > > > "Niniel" wrote:
> > > > >
> > > > > > I don't see the problem... I tested it, and when I closed the instance of
> > > > > > Access that was started with the hyperlinked db, the original db was still
> > > > > > there on the screen in all its glory. In fact, the original db never was
> > > > > > minimized.
> > > > > > So I'm confused as to what the problem is.
> > > > > >
> > > > > > "Hendricks97" wrote:
> > > > > >
> > > > > > > Ive been searching past postings and anyone who has ever asked this question
> > > > > > > has been ignored. Is there anyway to prevent the database from minimizing
> > > > > > > after the hyperlink is clicked? Is it just not a possibility or why has no
> > > > > > > one ever had this question answered?

Full Story.

The use of...

Application.FollowHyperlink "Some URL"

....causes Access to minimize in Access 97 and Access 2000. It does not do
this in Access 20002 and Access 2003. There is no work-around that I am
aware of other than to shell the other application rather than using the
FollowHyperlink method.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com