Hyperlink field trouble

  • Thread starter Thread starter Burton Roberts
  • Start date Start date
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
 
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
__________________________________________
 
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
*
 
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
__________________________________________
 
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
Type mismatch error - Setting Hyperlink Base property 2
Global Hyperlink Changes 4
Create a hyperlink in Access Table to Word Doc 2007 2
Hyperlink 1
Where is Insert Hyperlink on 2007 1
Find & Replace in hyperlink field 2

Back
Top