I need to link attachments to each record. Some records will have multiple attachments.
I have a form with Issue_ID, description, Filepath (this is a hyperlink) and a browse button.
My problem is, the attachments are not saving.
The Attachments table is as follows:
ID (Autonumber for the attachment)
Description (memo)
Filepath (hyperlink)
Issue_ID (number)
I'm still pretty new to Access and would really appreciate if someone could help me out with this.
Thank you in advance
2  2960 
I need to link attachments to each record. Some records will have multiple attachments.
I have a form with Issue_ID, description, Filepath (this is a hyperlink) and a browse button.
My problem is, the attachments are not saving.
The Attachments table is as follows:
ID (Autonumber for the attachment)
Description (memo)
Filepath (hyperlink)
Issue_ID (number)
I'm still pretty new to Access and would really appreciate if someone could help me out with this.
Thank you in advance
Hey lrw0831, Welcome to Byte,
Since, you didn't provide a great deal of detail in order to figure out your problem, I can only give you an general answer, and that is that filepath (Hyperlink) isn't going to save the file into the table at all. It's only going to store the text that you put into it, and that's all. I'm assuming that you're wanting to put into the field, that location of a file that is assocated with the current Issue, and you can do that, but I'm not sure as to how you're wanting this information to work within the database, and/or application that you're developing?
as for dealing with addtional attachments, you would simply add another field into the table that would allow for another attachment to be store in that addtional field as well.
The other option would be is to create a sub table that would allow you to add an many attachments as you wished, based on the record ID of the parent record. That would require a bit of redesign on your part to make that happen.
If you can provide more detailed information, the more detailed answer(s) I would be able to give you.
Hope that helps,
Joe P.
The database is used to track issue that we receive from each client. We have a main issue for that is where the main information is entered. We would like another form that will link file names to each record. One record could have many attachments though.
Supposed Client X has an open issue and they sent me an email with 2 attachments and also I have created a document regarding this issue.
I need to be able to add each file name to this one issue. I would like the file name to be a hyperlink so I can click on it and open the document. Would a list box be the best way to save multiple filenames for one issue?
I have been able to figure out the "Browse" button that will open "My Computer" so I can search for documents. But once I select a document I'm not able to save it to a specific record, or multiple attachment
Everyone that is using this database knows the store the documents in a specific folder on the public folder. But i've also heard that there is a way to make a copy of it from your local machine and save it to another folder. At this point i'm not sure that we need that.
Please let me know if there is any more information that you need.
Thank you
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Peter Wullems |
last post by:
I use C# to parse incoming emails for a predefined type and structure of
message content and construct replies automatically, attach a file and place
the generated emails in the drafts folder. There I can review and decide
which ones to send.
The program was working fine the other day and then decided to stop with the
following message:
Can't create file: filename.doc. Right-click the folder you want to create
the file in, and then...
|
by: Bart Stes |
last post by:
Hey guys,
I'm try to write a very simple winform app that allows the users to send an
email. I use the System.Web.Mail MailMessage class for this.
But when it comes to adding an attachment, something appears to go wrong.
After I execute the following code, the MailMessage appears to have an
attachment (looked it up through a watch in debug mode), but when I actually
send the message, the attachment is not send along with it. So the...
|
by: Bart Stes |
last post by:
Hey guys,
I'm try to write a very simple winform app that allows the users to send an
email. I use the System.Web.Mail MailMessage class for this.
But when it comes to adding an attachment, something appears to go wrong.
After I execute the following code, the MailMessage appears to have an
attachment (looked it up through a watch in debug mode), but when I actually
send the message, the attachment is not send along with it. So the...
|
by: EdWhyatt |
last post by:
Hi all, I hope there is someone out there who can help me out - it has
to be something obvious.
I am simulating mail traffic, and want to include multiple attachments
to my mail. I have created a temporary array containing a number of
files - for now just 2.
Debugging my code, I can see that I am correctly storing the files in
the array, and then 1 by 1 adding one file at a time to the message
header.
|
by: mike11d11 |
last post by:
I'm having a problem trying to add attachments to my email from my C:\
drive. What I'm trying to do here is have my database run a bunch of
queries that gives me a report that I'm putting in the body of my email
message as HTML format using a macro Sendobject. But this doesn't
allow me to add any attachments from my machine. I'm positive this
could be done through VBA code but I know very little on the
programming side. could someone...
| | |
by: VoodooFrog |
last post by:
I am trying to run the following code as a simple test of adding an attachment through access 2007:
Dim rsJob As DAO.Recordset2
Dim rsChild As DAO.Recordset2
Dim field As Field2
Set rsJob = Me.Recordset
Set rsChild = rsJob.Fields("attachments").Value
Set field = rsChild.Fields("filedata")
|
by: Kosmos |
last post by:
I have traveled the world and the seven seas and I have yet to come up with an answer to this question....
So I'm adding an attachment to an email from access...
The following is the code:
and from here I go to the end (because the other part is in an If statement and that's in a loop...once the loop's finished, I've gathered the necessary information I would paste the full function but I already have in another place on this site and...
|
by: ScottM |
last post by:
Hi,
I am an experienced VB6 programmer but a novice when it comes to MS Access. I have a form for ECO's (Engineering Change Orders) based on the table ECO, and in it I created a subform that is linked to a table called Attachments. The attachments are files related to the ECO. I used the wizard to do the work of adding the subform. So far, so good. As I cycle through the ECO's, the subform populates with the file attachments.
What I...
|
by: lrw0831 |
last post by:
I have an Access database that is used to keep track of issues that the department receives. What we need is a way to add attachments to issues, but only by adding the path name that is a hyperlink to open the document.
More information -
I need to open a form from the main issues form (which I can do that).
The attachment form needs to have a browse button that allows the users to search through their documents to find the file. I...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
