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

attachment

P: n/a
is it possible to attach .doc and .pdf files in an access table. if yes
then could you plz tell me how to do that.

Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
khan wrote:
is it possible to attach .doc and .pdf files in an access table. if yes
then could you plz tell me how to do that.


It is possible (OLE data type), but I wouldn't do it, instead I'd just
store the unc path of the document.

--
[OO=00=OO]
Nov 13 '05 #2

P: n/a
khan wrote:
is it possible to attach .doc and .pdf files in an access table. if yes
then could you plz tell me how to do that.


You can also use hyperlinks

Dim strDisplay As String
Dim strLink As String
strDisplay = "Bouncing Ball"
strLink = "C:\MyDocuments\BouncingBall.jpg"
Me.HyperlinkField = strDisplay & "#" & strLink & "#"

This will display
Bouncing Ball
to the user but when they click on it it opens the Jpg file.

You can extract the display and link using HyperlinkPart() function.

There are some problems that MS purposefully incorporated into
Hyperlinks. For example, they demand single clicks, not double clicks
to open the link. When the link is opened, it minimizes Access. I've
written code to defeat MS's attempts to control the developer and my
hyperlinks work the way I want. It's obvious MS developers never used
their own Access apps for opening hyperlinks.

Nov 13 '05 #3

P: n/a
right , but is it possible to link this hyperlink with another table
field, Actually I am trying to make a website, which is called
knowledge base. In that you enter the possible problems and solution
about any thing Like computer, printer etc.

Now when user will click the printer link he would find the problems
and their solutions. Now first of all is it possible I could use some
thing else instead of strLink = "C:\MyDocuments\BouncingBall.j*pg" bcz
if I changed the path of this field then every thing would messed up.
Can I specify a variable if yes then how?

I have to include some of the documents about different system and
stuff .
Can you suggest me better way to do this. I am a student and I am
assinged this task, plz help me.

Nov 13 '05 #4

P: n/a
khan wrote:
right , but is it possible to link this hyperlink with another table
field, Actually I am trying to make a website, which is called
knowledge base. In that you enter the possible problems and solution
about any thing Like computer, printer etc.

Now when user will click the printer link he would find the problems
and their solutions. Now first of all is it possible I could use some
thing else instead of strLink = "C:\MyDocuments\BouncingBall.j*pg" bcz
if I changed the path of this field then every thing would messed up.
Can I specify a variable if yes then how?

I have to include some of the documents about different system and
stuff .
Can you suggest me better way to do this. I am a student and I am
assinged this task, plz help me.

My best advice is to create a table with a hyperlink field and
experiment. Add a link. Now open the table and right click on the
field. The link has the UNC path and if the link changes you can browse
to another file. You can also change the display text.
Nov 13 '05 #5

P: n/a
can we use hyperlink field to make a link between two tables or link to
the the field of another table.

Nov 13 '05 #6

P: n/a
khan wrote:
can we use hyperlink field to make a link between two tables or link to
the the field of another table.

If you are a programmer, you can do anything...up to the limits MS
set...that you want to.
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.