By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,276 Members | 1,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,276 IT Pros & Developers. It's quick & easy.

unbound hyperlink field...

P: n/a
Hello.

I've converted a bound Access 2000 form which displays data retrieved from
an Access 2000 database to an unbound form. Now my hyperlinks don't work.
I'm assuming it's because the form isn't bound anymore. I didn't even have
that field's data type as hpyerlink - just test. I did have the form
control's "hyperlink" property set to true and it worked fine in bound mode.
The fields stores paths to pdf files. How can I make the hyperlink work in
an unboud form? (Going back to bound is NOT an option).

Thank You.

Matthew Wells
MW****@FirstByte.net
Mar 29 '06 #1
Share this Question
Share on Google+
10 Replies


P: n/a
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:zy*******************@newsread3.news.atl.eart hlink.net...
Hello.

I've converted a bound Access 2000 form which displays data retrieved from
an Access 2000 database to an unbound form. Now my hyperlinks don't work.
Am I missing something here? How do you expect an unbound form to display
data? Is is bound at run-time by using VBA/SQL queries? Can you give more
info?
I'm assuming it's because the form isn't bound anymore. I didn't even
have
that field's data type as hpyerlink - just test.
Test?
I did have the form
control's "hyperlink" property set to true and it worked fine in bound
mode.
As you'd expect it to, yes.
The fields stores paths to pdf files. How can I make the hyperlink work
in
an unboud form? (Going back to bound is NOT an option).


As I say, unless I'm missing something (which is distinctly possible) it's
not gonna happen. Why do you need to have the form unbound?

Keith.
www.keithwilby.com
Mar 29 '06 #2

P: n/a
Hi, Matthew.
I'm assuming it's because the form isn't bound anymore.
Correct.
How can I make the hyperlink work in
an unboud form?
Instead of an unbound text box, use an unattached label which _can_ use
the Hyperlink functionality.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:zy*******************@newsread3.news.atl.eart hlink.net... Hello.

I've converted a bound Access 2000 form which displays data retrieved from
an Access 2000 database to an unbound form. Now my hyperlinks don't work.
I'm assuming it's because the form isn't bound anymore. I didn't even
have
that field's data type as hpyerlink - just test. I did have the form
control's "hyperlink" property set to true and it worked fine in bound
mode.
The fields stores paths to pdf files. How can I make the hyperlink work
in
an unboud form? (Going back to bound is NOT an option).

Thank You.

Matthew Wells
MW****@FirstByte.net

Mar 29 '06 #3

P: n/a
I have functions that retrieve the data and display it in the text boxes.
It's much faster.

"Keith Wilby" <he**@there.com> wrote in message
news:44**********@glkas0286.greenlnk.net...
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:zy*******************@newsread3.news.atl.eart hlink.net...
Hello.

I've converted a bound Access 2000 form which displays data retrieved from an Access 2000 database to an unbound form. Now my hyperlinks don't
work.
Am I missing something here? How do you expect an unbound form to display
data? Is is bound at run-time by using VBA/SQL queries? Can you give more info?
I'm assuming it's because the form isn't bound anymore. I didn't even
have
that field's data type as hpyerlink - just test.


Test?
I did have the form
control's "hyperlink" property set to true and it worked fine in bound
mode.


As you'd expect it to, yes.
The fields stores paths to pdf files. How can I make the hyperlink work
in
an unboud form? (Going back to bound is NOT an option).


As I say, unless I'm missing something (which is distinctly possible) it's
not gonna happen. Why do you need to have the form unbound?

Keith.
www.keithwilby.com

Mar 29 '06 #4

P: n/a
Hi, Matthew.
I have functions that retrieve the data and display it in the text boxes.
It's much faster.
Have you considered binding the form to a query that retrieves only one
record at a time, not the entire table?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:5m******************@newsread2.news.atl.earth link.net...I have functions that retrieve the data and display it in the text boxes.
It's much faster.

"Keith Wilby" <he**@there.com> wrote in message
news:44**********@glkas0286.greenlnk.net...
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:zy*******************@newsread3.news.atl.eart hlink.net...
> Hello.
>
> I've converted a bound Access 2000 form which displays data retrieved from > an Access 2000 database to an unbound form. Now my hyperlinks don't

work.

Am I missing something here? How do you expect an unbound form to
display
data? Is is bound at run-time by using VBA/SQL queries? Can you give

more
info?
> I'm assuming it's because the form isn't bound anymore. I didn't even
> have
> that field's data type as hpyerlink - just test.


Test?
> I did have the form
> control's "hyperlink" property set to true and it worked fine in bound
> mode.


As you'd expect it to, yes.
> The fields stores paths to pdf files. How can I make the hyperlink
> work
> in
> an unboud form? (Going back to bound is NOT an option).
>


As I say, unless I'm missing something (which is distinctly possible)
it's
not gonna happen. Why do you need to have the form unbound?

Keith.
www.keithwilby.com


Mar 29 '06 #5

P: n/a
Unbound forms are faster in all cases. I have calss modules that handle all
the data verification and updating.

"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote in
message news:Ar********************@adelphia.com...
Hi, Matthew.
I have functions that retrieve the data and display it in the text boxes.
It's much faster.


Have you considered binding the form to a query that retrieves only one
record at a time, not the entire table?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:5m******************@newsread2.news.atl.earth link.net...
I have functions that retrieve the data and display it in the text boxes.
It's much faster.

"Keith Wilby" <he**@there.com> wrote in message
news:44**********@glkas0286.greenlnk.net...
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:zy*******************@newsread3.news.atl.eart hlink.net...
> Hello.
>
> I've converted a bound Access 2000 form which displays data retrieved

from
> an Access 2000 database to an unbound form. Now my hyperlinks don't

work.

Am I missing something here? How do you expect an unbound form to
display
data? Is is bound at run-time by using VBA/SQL queries? Can you give

more
info?

> I'm assuming it's because the form isn't bound anymore. I didn't even > have
> that field's data type as hpyerlink - just test.

Test?

> I did have the form
> control's "hyperlink" property set to true and it worked fine in bound > mode.

As you'd expect it to, yes.

> The fields stores paths to pdf files. How can I make the hyperlink
> work
> in
> an unboud form? (Going back to bound is NOT an option).
>

As I say, unless I'm missing something (which is distinctly possible)
it's
not gonna happen. Why do you need to have the form unbound?

Keith.
www.keithwilby.com



Mar 29 '06 #6

P: n/a
That worked great!!!

Thank you.

"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote in
message news:FI********************@adelphia.com...
Hi, Matthew.
I'm assuming it's because the form isn't bound anymore.


Correct.
How can I make the hyperlink work in
an unboud form?


Instead of an unbound text box, use an unattached label - which _can_ use
the Hyperlink functionality.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:zy*******************@newsread3.news.atl.eart hlink.net...
Hello.

I've converted a bound Access 2000 form which displays data retrieved from an Access 2000 database to an unbound form. Now my hyperlinks don't work. I'm assuming it's because the form isn't bound anymore. I didn't even
have
that field's data type as hpyerlink - just test. I did have the form
control's "hyperlink" property set to true and it worked fine in bound
mode.
The fields stores paths to pdf files. How can I make the hyperlink work
in
an unboud form? (Going back to bound is NOT an option).

Thank You.

Matthew Wells
MW****@FirstByte.net


Mar 29 '06 #7

P: n/a
Hi, Matthew.
Unbound forms are faster in all cases. I have calss modules that handle
all
the data verification and updating.
And do as good a job as the database engine at handling record locks, write
conflicts, and guaranteeing referential integrity? That's a lot of coding
to gain marginally faster speed compared to retrieving a single bound record
from the table. But having a bound form open with only record isn't always
feasible in every application, so an unbound form that handles one record at
a time is a viable alternative. It's just a lot of work to get it right
when the business logic side is doing the work of the database engine.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:D8*******************@newsread3.news.atl.eart hlink.net... Unbound forms are faster in all cases. I have calss modules that handle
all
the data verification and updating.

"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote
in
message news:Ar********************@adelphia.com...
Hi, Matthew.
>I have functions that retrieve the data and display it in the text
>boxes.
> It's much faster.


Have you considered binding the form to a query that retrieves only one
record at a time, not the entire table?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:5m******************@newsread2.news.atl.earth link.net...
>I have functions that retrieve the data and display it in the text
>boxes.
> It's much faster.
>
> "Keith Wilby" <he**@there.com> wrote in message
> news:44**********@glkas0286.greenlnk.net...
>> "Matthew Wells" <MW****@FirstByte.net> wrote in message
>> news:zy*******************@newsread3.news.atl.eart hlink.net...
>> > Hello.
>> >
>> > I've converted a bound Access 2000 form which displays data
>> > retrieved
> from
>> > an Access 2000 database to an unbound form. Now my hyperlinks don't
> work.
>>
>> Am I missing something here? How do you expect an unbound form to
>> display
>> data? Is is bound at run-time by using VBA/SQL queries? Can you give
> more
>> info?
>>
>> > I'm assuming it's because the form isn't bound anymore. I didn't even >> > have
>> > that field's data type as hpyerlink - just test.
>>
>> Test?
>>
>> > I did have the form
>> > control's "hyperlink" property set to true and it worked fine in bound >> > mode.
>>
>> As you'd expect it to, yes.
>>
>> > The fields stores paths to pdf files. How can I make the hyperlink
>> > work
>> > in
>> > an unboud form? (Going back to bound is NOT an option).
>> >
>>
>> As I say, unless I'm missing something (which is distinctly possible)
>> it's
>> not gonna happen. Why do you need to have the form unbound?
>>
>> Keith.
>> www.keithwilby.com
>>
>>
>
>



Mar 29 '06 #8

P: n/a
You're welcome! Glad it helped.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:S8******************@newsread3.news.atl.earth link.net...
That worked great!!!

Thank you.

"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote
in
message news:FI********************@adelphia.com...
Hi, Matthew.
> I'm assuming it's because the form isn't bound anymore.


Correct.
> How can I make the hyperlink work in
> an unboud form?


Instead of an unbound text box, use an unattached label - which _can_ use
the Hyperlink functionality.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:zy*******************@newsread3.news.atl.eart hlink.net...
> Hello.
>
> I've converted a bound Access 2000 form which displays data retrieved from > an Access 2000 database to an unbound form. Now my hyperlinks don't work. > I'm assuming it's because the form isn't bound anymore. I didn't even
> have
> that field's data type as hpyerlink - just test. I did have the form
> control's "hyperlink" property set to true and it worked fine in bound
> mode.
> The fields stores paths to pdf files. How can I make the hyperlink
> work
> in
> an unboud form? (Going back to bound is NOT an option).
>
> Thank You.
>
> Matthew Wells
> MW****@FirstByte.net
>
>



Mar 29 '06 #9

P: n/a
Not at all. I keep a single ADO connection object open to use through the
entire system. I have scripts that create the class modules and the form
code - all of it including navigation buttons - so the form is ready to use
in two minutes. All I do is give the table name and some other basic info
and 95% of the code is done in 30 seconds. There is always a little
tweaking. The business logic is all handled in one validte function.
That's the only real code I have to write.I have a front end in Miami and a
back end in New Jersey. It was taking 5 minutes to retrieve a record, now
it takes 5 seconds. (Yes I know there's a network problem somewhere, but
this is a Johnson & Johnson comapny so I can't mess with it.)

"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote in
message news:K7********************@adelphia.com...
Hi, Matthew.
Unbound forms are faster in all cases. I have calss modules that handle
all
the data verification and updating.
And do as good a job as the database engine at handling record locks,

write conflicts, and guaranteeing referential integrity? That's a lot of coding
to gain marginally faster speed compared to retrieving a single bound record from the table. But having a bound form open with only record isn't always feasible in every application, so an unbound form that handles one record at a time is a viable alternative. It's just a lot of work to get it right
when the business logic side is doing the work of the database engine.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:D8*******************@newsread3.news.atl.eart hlink.net...
Unbound forms are faster in all cases. I have calss modules that handle
all
the data verification and updating.

"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AM> wrote
in
message news:Ar********************@adelphia.com...
Hi, Matthew.

>I have functions that retrieve the data and display it in the text
>boxes.
> It's much faster.

Have you considered binding the form to a query that retrieves only one
record at a time, not the entire table?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:5m******************@newsread2.news.atl.earth link.net...
>I have functions that retrieve the data and display it in the text
>boxes.
> It's much faster.
>
> "Keith Wilby" <he**@there.com> wrote in message
> news:44**********@glkas0286.greenlnk.net...
>> "Matthew Wells" <MW****@FirstByte.net> wrote in message
>> news:zy*******************@newsread3.news.atl.eart hlink.net...
>> > Hello.
>> >
>> > I've converted a bound Access 2000 form which displays data
>> > retrieved
> from
>> > an Access 2000 database to an unbound form. Now my hyperlinks don't > work.
>>
>> Am I missing something here? How do you expect an unbound form to
>> display
>> data? Is is bound at run-time by using VBA/SQL queries? Can you give > more
>> info?
>>
>> > I'm assuming it's because the form isn't bound anymore. I didn't

even
>> > have
>> > that field's data type as hpyerlink - just test.
>>
>> Test?
>>
>> > I did have the form
>> > control's "hyperlink" property set to true and it worked fine in

bound
>> > mode.
>>
>> As you'd expect it to, yes.
>>
>> > The fields stores paths to pdf files. How can I make the hyperlink >> > work
>> > in
>> > an unboud form? (Going back to bound is NOT an option).
>> >
>>
>> As I say, unless I'm missing something (which is distinctly possible) >> it's
>> not gonna happen. Why do you need to have the form unbound?
>>
>> Keith.
>> www.keithwilby.com
>>
>>
>
>



Mar 29 '06 #10

P: n/a
"Matthew Wells" <MW****@FirstByte.net> wrote in message
news:5m******************@newsread2.news.atl.earth link.net...
I have functions that retrieve the data and display it in the text boxes.
It's much faster.


That sounds rather beyond my field of expertise so I was indeed missing
something!

Keith.
Mar 30 '06 #11

This discussion thread is closed

Replies have been disabled for this discussion.