Attaching Documents
Jun 7, 2007Please advise how to attach documents within a database. I have Office XP (2002).
View RepliesPlease advise how to attach documents within a database. I have Office XP (2002).
View RepliesI'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'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
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
I'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.
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:
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 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]...
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 need to be able to scan documents into individual records in access and I was wondering if this could be done.
View 2 Replies View RelatedIs there anyway to scan documents and save them in an Access table? As of now we scan them and save them to a folder on the network. Then go into Access form to add them into the tables. Would like to automate this process all from Access but have know idea how to go about this. Any suggestions?
View 4 Replies View RelatedHi all,
Sorry but I'm really new to Access and trying to make sense of all the useful advice on here!
I'm trying to programme a button in one of my forms to open up a word document as read-only. I've written the code to open up the Word application (before I found the button which did it for me! :( ) but I think I need to add one or two more lines so that word knows where the document is I want and opens it up - any ideas what these lines are?
Real sorry for the trouble - any help would be most appreciated! Thanks guys and girls.
I'm new to Access and I'm trying to figure out how to use Access to populate documents. I assume I would create a form asking for information, and then Access would populate document(s) using the information.
For example, I need this information plugged into multiple Word Documents (or I guess I could combine all the word documents into a single PDF)
Name: John Smith
Project Number: 12345
Duration: 120 Days
Summary: This work would include...
...etc.
And then the program would use the information from the form to fill in an already created template, sometime using the same piece of information more than once:
_____________________ has a project number of _________________________. _________________________ has a duration of _______________________. The duration of ____________________ includes days associated with project number ____________________. The summary is __________________________________________________ _____________.
The template may go on for hundreds of pages, but the information from the form would still be used throughout most of the pages.
Is it possible to scan documents directly in to MS Access and store them in a field in a table please??
If so how??
Thanks for your help
I have a simple database for my rv rental business, I want to be able to import an existing form into access and then use the data in my dbase to fill in the forms to print and have the customer sign the contract etc. I use 2003 how would I go about doing this?
thanks
Jim
As a basic user and relatively new user of Access, I have designed a database which holds the data for several word documents that I use for mailmerges. I want to be able from the "switchboard" link the word documents so that users can easily access the letter/form required and print them. Ive tried many things - just not working!!!! Time to shout for help!
View 1 Replies View RelatedHi all..
I am new to Access and currently implementing a small company database.
Is it possible to link Access to Word documents?
I wish to create a button on a form that when clicked it opens the word document according to what have been selected in the combo box in the form.
thanks :o
Because of certain design considerations and the amount of data I'm maintaining, I have chosen to use tabbed documents rather than floating windows or subforms.
The hierarchy is supposed to be a person who is categorized as either a client, family member, donor, etc. Further, a client may use one or more services. In the example, our client uses Specialized Home Care. However, the tabs are intuitively out of order: the people tab is left-most, followed by the Specilaized Home Care tab, and lastly the Client tab. It should be People, People:Client, People:Client:Service. If a person uses a lot of our services, there will be separate People:Client:Service tabs and the People:Client tab will scroll off to the right. I'd like Access to order them properly but see no way to do it.when the forms are opened, it's people first followed by the high-level classification (i.e. Client), and the lastly the specific Client:Service tabs. I would expect Access to open and display them left to right, but, as you can see, it doesn't.
I was wondering if there is an awesome way out there somewhere to take a record and export it into a word document, like a template and have the fields go where you want them to?
View 13 Replies View RelatedHere is my function :
Private Sub Commande4_Click()
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim qdf As DAO.QueryDef
Dim BaseSQL As String
Dim strSQL As String
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("SELECT DISTINCT [Dealer/Distributor Number] FROM Query_Active_Dealer_List_Update")
Set qdf = dbs.QueryDefs("Query_Active_Dealer_List_Update")
BaseSQL = qdf.SQL
With rst
Do Until .EOF
strSQL = Left(BaseSQL, Len(BaseSQL) - 3) & " WHERE [Dealer/Distributor Number] =" & ![Dealer/Distributor Number]
qdf.SQL = strSQL
DoCmd.OutputTo acOutputReport, "Main_Report", "RichTextFormat", "C:Documents and SettingslarocmaDealer_Scorecards" & ![Dealer/Distributor Number] & ".doc"
.MoveNext
Loop
.Close
End With
qdf.SQL = BaseSQL
Set qdf = Nothing
Set rst = Nothing
Set dbs = Nothing
End Sub
The problem is in the line containing : strSQL = Left(BaseSQL, Len(BaseSQL) - 3) & " WHERE [Dealer/Distributor Number] =" & ![Dealer/Distributor Number]
If I let ![Dealer/Distributor Number] this way I get an error and no report generated. But if I put "[Dealer/Distributor Number]" in a parameter, and I enter the dealer numbers by hand, I get good working reports. Dealer/Distributor Number are not nul. Main_Report is a report containing many sub_reports grouped by Dealer/Distributor Number. The query I linked to the function is the query I use on the main report to get the information about each dealership.
Customizing the form with the following code
Code:
Public Declare Function LoadImage Lib "user32" _
Alias "LoadImageA" _
(ByVal hInst As Long, _
ByVal lpsz As String, _
ByVal un1 As Long, _
ByVal n1 As Long, _
ByVal n2 As Long, _
ByVal un2 As Long) _
As Long
[code]...
I can load the little icon on the left on CaptionBar.It works very well on overlapping mode but no on Tabbed documents. How to works with tabbed documents mode?