This might be impossible, but I was wondering if there was a way to attach files to records on a form. I work for a marketing company and I have built a contact management database and I need to attach files such as letters and emails to records on a form. I also would like a list of files attached to that record to display also. I don't know if this makes sense or if it is possible. Any help would be greatly appreciated.
Nick
Hi,
Is it possible to attach files (word, excel, emails etc) to records in Access?
I want to build a simple contact database that will enable me to add a word document to John Smith, for example
Regards
Djuro:cool:
hello, im actually trying do design a database with attached
word files, ie the persons information and his attached cvs
i never done that before and im confused, should i attach all the cvs(words documents) to the database ie can i create a field which is a word document or i should put all the cvs in a folder outside the DB and put a link to them in the table taking into consideration that it s gonna be a big database, and if so can the user attach a file to the database using a button ie in the forms
thanks in advance
Hi Everyone,
I have a PO table. Each PO has 3 documents of multiple types (one may be Word, other may be Excel, Acrobat). When I display the PO, the attachments should be shown as Icons, which when double-clicked, will open in its own Application.
I have a pop-up screen where I enter new PO details. In this screen, I have Attach/Detach buttons for each of the Documents.
My Requirement:
When I press 'ATTACH' of Doc1, the File Selection screen should be displayed from where the user will select the file to be attached. This file should be updated into the table field "doc1".
When I press 'DETACH' of Doc1, the file in table field "doc1" must be cleared.
How can I achieve this???:mad:
Is it possible to attach a WP, Excel, or Adobe file to a form, possibly by using a control key? How?
View 6 Replies View RelatedI'm creating a simple db on shared network drive and I need to upload or attach documents into it. Mainly PDF but may need to add .doc or .xls. I cannot use hyperlink since I cannot store the files where they are easily accessed due to security issues. So my only recourse was to create a secured db. Size is not an issue due to limited use. How do I do this?
Thanks
Chuck
Please advise how to attach documents within a database. I have Office XP (2002).
View 1 Replies View RelatedI've built a database to attach pictures of people to their records. In the table it's designed as an "OLE Object". When you goto the form you can click on the box, tell it to insert object, find the file, and the picture can be displayed to the record.
I've since learned that this process inflates the database and with the recent update changes from Microsoft (removing Photo Editor) I'm trying to learn to create databases to insert pictures having the same result but won't inflat the database.
I've learned of a view method to insert pictures that are a little more complicated to create using coding. My problem with this method is you would have to type in the file location manually to get the picture to attach. I'm working in a location that needs this process to be simpler then that. I need to find a way to browse for that picture instead of having to type in the file location manually.
HELP!
Hi, I'm not even sure how to describe my problem in the proper terms in order to look it up in any faq or tutorial.
I have one table, customers. Their name, number, etc.
Another table, products: Name, id, department, etc.
And the final table being orders. Customer bought product when, etc.
However, I'm only able to attach one product to each customer per order. I need to be able to attach any number of products, and I don't know how to go about doing that.
Also, when I create a form for entering all the data to these tables, the information doesn't stick. I create a form using the order table, enter the order and customer information, and have the products as a subform. The information will stick for each table, but they won't connect to each other.
If that makes any sense...
Any pointers would be great thanks, I don't even know where to start.
Hi,
Probably an easy one, but I'm stuck!
I'm dealing with quite a complex database and trying to make use of many subforms to minimize data entry and errors. I only want certain subforms to be visible through the use of a button, since for many records, the subform will not be needed. Upon clicking the button, I would like the subform to appear and related fields to be populated. I am already aware of how to attach buttons to open a form, however, I need the related field (child field) of the subform to be populated upon opening the form and this does not seem possible merely through opening a form by way of a button.
Any help would be greatly appreciated, I'm currently at a a standstill.
A have a table with many records and each record has a hyperlink to a document. Based on some criteria i want to attach the hyperlink file to an email. Don't want to have to do this manually. Is there anyway i can write code to go and get the hyperlink file and then attach the physical file into the email? This could result in 1 file being attached, 13 files being attached, 0 files etc.
Any help would be greatly appreciated.
Cheers,
Combsie.
I'm trying to use this API in my database to be able to attach documents to my forms. [URL] .....
Do I have to put this into its own Module? I'm not familiar with how the code is defining Types and declaring Global variables.
I want to be able to attach a date field to a dropdown check box. For example, say I have a client who we submit multiple deliverables to on different dates. I want to be able to check the deliverables submittted and add the date for that deliverable (each deliverable has a different date). image which is how the drop down is currently set up.
View 3 Replies View RelatedI'm trying to work out how to attach a word doc to the attachment field of a table when I add a new Record. The following code work's fine if I add it to the On Load Event on the Form, but the doc is attach'd to the first record. When I add the code to the Add New Record button, I get the error msg: "File already part of the Multi-Valued Field" and nothing in the attachment field.
Code:
Private Sub Add_Record_Click()
DoCmd.GoToRecord , , acNewRec
Me.Description.SetFocus
On Error GoTo Err_AddImage
Dim db As DAO.Database
Dim rsParent As DAO.Recordset2
Dim rsChild As DAO.Recordset2
[Code]...
I have to write a code for my database,i have folder with files "pending Review" and a table with column "tblExcelLocation". when i run my database all the files from pending review folder goes to "tblExcelLocation" on a click of button.But,if the files already exists it should not insert those files and insert the rest.For this i tried to write a code but i think i m unable to do that .
Code:
Loop through files in folder
folderspec = "O:QA FilesQC ReportingPending Review"
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFolder(folderspec)
Set fc = f.files
[code]...
Every hour a zip file is created in an FTP folder. The zip file contains an .mdb access database file with any changes to the data since the last hours file.
What is the best method to get access to connect to the content of the zip files and pick up the changes to the data?
Hi guys.
Just a quick one, I couldn`t find anything on this or in any books I have.
I`m assuming I need to create an MDE file befire I can distribute my database for other people to use ?
Anyway, that I have done, but the question is, I`ve done this and have a select number of ppl using my database, entering LIVE data etc.
Once This has been done can I open this back up in access and make changes to the database, eg forms, reports etc etc ?
If not, is there anyway, I can pull the data out of this and import it into my origanal file, which can then be remade into an MDE ?
I hope I have made myself clear.
Thanks in advance for any help!!
Max
Hello,
Once I split up database into mde and mdb files is there a way to put them back togethere ? How can I turned linked table into table?
I would greatly appreciate your reply.
Debbie
HI I hope that someone can help me, I know it's not that hard, but I have never done it. Actually, I have a folder that has like 340 excel files. Is there a way I can write a vba code in either excel or access to get the file names in like a table or so, it's gonna take for ever to type them in manually. I only need to get the file name and they are all excel files. Please Help If You Can. Thanks.
View 6 Replies View Relatedi wanted to convert my MDB file to ADP.
the convertion went well except from on important issue, it didnt convert all mu queries to the new file, i tried another way but nothing.
please help.
all the forms and tables an d everythoing else are in the new file, although, the forms are based on all teh queries.
Is there any way to embed html type help file in an .mdb/.mde file? I have created an html type file, MS Word saves it as an .mht (Whayever that is?). Is my only option going to be to distribute this .mht with the .mde? How do you access the help file from with in Access?
What are some other relatively easy user help authoring options?
Thanks,
Ken
I have a locking file that I can't seem to remove. No one is in the database that's associated with the file but it tells me there's been a sharing violation. Can anyone tell me how to remove those files?
View 1 Replies View RelatedI'm having trouble converting my DB to an MDE file.
I'm programming in access 2003 and saving as a 2000 file format.
I opened a new DB and imported all objects etc... the saved as a 2003 format. Still won't save an MDE file.
Any suggrestions are appreciated
Damon
I was wondering if access has a log system that can log when a user connects to the database and would give date, time and username? My database is setup for multiple users.
View 2 Replies View RelatedI am doing my comptuer science coursework and one thing I need to include is "how does access stored files" and the basic description of file organisation. After some googlging around though I have found nothing, can anyone hlep me out on this?
Thanks
Chris
Hi
I am having much trouble importing csv file into access 2003
My freewebs site have a registration form
The forms are then downloaded into my pc as csv files
According to freewebs, the csv file is access friendly and can be imported into access
so I tried for about a million time and still no luck
where did i go wrong?
this is what i did
help !
regards
frontpageplanners