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

Hyper link capture

P: 8
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
Feb 19 '07 #1
Share this Question
Share on Google+
2 Replies


100+
P: 1,646
... 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?
Feb 20 '07 #2

P: 8
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
Feb 21 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.