473,320 Members | 1,876 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

attachment

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
6 1624
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Wald | last post by:
Hello group, I've got a script here that sends emails with an attachment to an email address that is retrieved from an html form. The email sending code is include below. The problem: when...
1
by: a c s | last post by:
Hi there, my problem is as follows: When emailing a file using PHP 4.0.6, the attachment received is an empty "attachment.txt" file instead of the actual file I attached. Any suggestions why...
1
by: abracad | last post by:
I'd like to add a form that will email a file attachment to me. Can anyone recommend a decent free script? Thanks
2
by: knoak | last post by:
Hi there, I've found a script at these great Google fora. a script to send emails with attachments. The script is below this message, name etc. aren't mine, but from the original post. My...
0
by: hlabbott | last post by:
Hi I'm having a problem displaying attachments correctly. I have messages with attachments stored on Exchange2000 and want to be able to click a hyperlink in my project like in OWA and see an...
0
by: Aquila Deus | last post by:
Hi all! I found an interesting way to implement strong-typed object attactment with generic: // Attachment should be a Dictionary<K,V> or some user-defined container, rather // than...
1
by: theWizard1 | last post by:
The following sends my email, but the attachment is empty. The attachment should contain the data that is in the string that was created from the xmlReader. I have a stored procedure written...
3
by: TomislaW | last post by:
I am sending word document with e-mail from asp.net 2.0 application. I read doc file like this:FileStream fs = System.IO.File.Open(docPath,FileMode.Open,FileAccess.Read,FileShare.Read); Then...
9
by: deepaks85 | last post by:
Dear Sir, I have created a simple request form which will be mailed to me. Now I want to attach files and send it through that request form. For this I am using the following script: ...
7
by: erikcw | last post by:
Hi all, I'm trying to extract zip file (containing an xml file) from an email so I can process it. But I'm running up against some brick walls. I've been googling and reading all afternoon, and...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.