Hyper link capture

[AlanHill1965]

Hi All,

I have developing a database system for the last couple of weeks and got stuck on one part of the functionality. I have posted this question over at MSDN, but no joy, perhaps they got upset about the fact I had posted to the wrong area (VBE not VBA...).

Anyway The problem I have is in capturing the hyperlink used to open an MS Access database.

The database (Access 2000) is used to gather the results of tests then compare them and produce a score. If the score indicates a fail then the operator has the option to send an email with an embedded hyper link to the person that deals with that area.

The hyperlink I understand can contain parts seperated by hashes, If there is a way of capturing the link information, I can utilise this to automatically log in the user, or direct them to the correct page of information, within the database.

The database opened is the same from which the hyperlink was sent, so this is a multiuser database, there passwords and level of access is all set and done, the hyperlink utilises a full UNC path, thus no mapping of the shared drive is required. This so far all works, the problem I have is knowing where the refering hyperlink, if available, is so that I can capture it and utilise this to guide the user to the correct place.

Any ideas ... TIA

Alan Hill

[willakawill]

... the problem I have is knowing where the refering hyperlink, if available, is so that I can capture it and utilise this to guide the user to the correct place.

Hi Alan,
Can't quite get my head around this sentence. Can you word it differently?

[AlanHill1965]

Ok,

Step 1 , I have a database, which has a button
Step 2 , The button creates an email to send to a person.
Step 3 , The email arrives
Step 4 , The email link opens the same database
Step 5 , In the hyperlink you can have extra information which is split by the hash mark (#).
Step 6 , As the database opens the hyperlink used to open it is captured into a variable.
Step 7 , Using the variable from above (Step 6), manipulate the use to the correct item in the database.

I think thats as clear as mud, sorry about the the convoluted gibberish before, once an idea gets in sometimes (most) I just waffle.

The Idea came from an early development idea on this database when I was using a shortcut with the addition of the '/CMD' switch. This allows extra commands to be passed to the database as it opens I can grab the extra information using the 'command()' function.

I was just wondering if it was possible to do the same with hyperlinks?

Alan Hill