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.