Hyperlinks in a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating an issues database and want to 'attach' a document to an issue.
The document can be a word document for issue 1, an excel document for issue
2 and maybe no document for issue 3. I have been searching online help and
am aware of the hyperlink data type, but this seems to work when you document
is always constant. As the user is entering the issue, would want them to
'attach' the document to the form at that time without going to the form
view. These are end users who are not tech savvy. Any suggestions would be
helpful. Thanks.
 
Hmm... I couldn't see any hyperlinks in the hyperlink MDB, but the forms in
the sample looked great!

I put together an applet that demonstrates the hyperlink FIELD and how to
use it inside a LISTBOX to allow endusers to doubleclick on the desired file.
The URL is here:
http://www.emrupdate.com/files/folders/al_borges/entry58232.aspx

Check it out- I use this form all the time in my office EMR ("electronic
medical record").

Al
 
My issues db seems pretty straightforward to me. I attempted to use the
applet from alborg. My form had a subform already in it - it just displayed
a listing of issues given a ssn. But for some reason I couldn't execute
the applet. So I just deleted the subform. Now I'm getting message number
-214735267 from source form_form1/cmdCreateHyperlink_Click with a description
- You Can't assign a value to this object. I have the object defined as a
hyperlink in the table. If you have any ideas, that would be much
appreciated. Thanks so much.
 
Hi Paula:

What do you mean that you "couldn't execute the applet"? Did the ZIP file
not work? Did the MDB give you an error? The thing is very simple, so the
error is likewise going to be a simple problem.

The usual culprit in the random errors are the references. Open up the file,
then click on Modules-> New-> Tools-> References. Check if any are "MISSING".
If so, uncheck them and then look up the reference version that applies to
your MS Access. For example, if the MS Office 11.0 Object Library is
"MISSING", then you might have to choose the MS Office 9.0 Object Library
(for MS Office 2000).

Cheers,
Al
 
Back
Top