Hyperlink field trouble

B

Burton Roberts

Sorry if this is cross posted in "queries".

Using Access 2003. I have a hyperlink field in a table. I'm using the table
as part of a menu system. I want the hyperlinks to point to objects in the
database. I could do this in earlier versions of Access but can not figure
it out for Access 2003. After upgrading to 2003 the table that I have works
but I can not add new rows with hyperlinks to Access objects in the database
(or edit the old ones).

Did they change this feature in 2003?

Thanks
Burton Roberts
 
G

Guest

Hi Burton,

Very strange. I've just confirmed your observations. Access 2000 and 2002
include a button that reads "Object in this database", which is missing in
Access 2003.

I found, however, that you can enter a link to an existing object. The clue
is to convert your hyperlink field to a Text field (set to 255, before
saving, to help prevent losing any data). Do this on a copy of your table, to
help prevent any problems. In Access 2003, it looks like you can enter two
pound signs, the type of object, a space character, and then the name of the
object. Do not include any quotes. Examples for the Northwind sample database
include the following:

##Table Orders
##query Current Product List
##Form Categories
##Report Invoice


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
S

strive4peace

Thanks, Tom!

that is nice to know, I have seen this question before and wondered
myself ...

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
G

Guest

Hi Crystal,

You're very welcome.

Just to be clear, I didn't mean to imply that one needs to convert the
hyperlink field to a text field in order to enter the data...that was just so
that you could get a looksie at how Access was storing the data. One would
type the ##Object Name of object directly into the hyperlink field. Also, a
subtle point, but the object part must be singular, not plural (ie. ##table
TableName, not ##tables TableName)


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
B

Burton Roberts

Thanks everyone. This helps a lot.
Burton

Tom Wickerath said:
Hi Burton,

Very strange. I've just confirmed your observations. Access 2000 and 2002
include a button that reads "Object in this database", which is missing in
Access 2003.

I found, however, that you can enter a link to an existing object. The
clue
is to convert your hyperlink field to a Text field (set to 255, before
saving, to help prevent losing any data). Do this on a copy of your table,
to
help prevent any problems. In Access 2003, it looks like you can enter two
pound signs, the type of object, a space character, and then the name of
the
object. Do not include any quotes. Examples for the Northwind sample
database
include the following:

##Table Orders
##query Current Product List
##Form Categories
##Report Invoice


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2010 Disable Microsoft Access Security Notic 3
Hyperlink Field Problems 2
Global Hyperlink Changes 4
Where is Insert Hyperlink on 2007 1
Import Hyperlink 1
Inspect a Hyperlink field address to determine target file type 1
Hyperlink to Explorer 5
Data Access Page Hyperlinks 1

Top