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
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.
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
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.
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:
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]...
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 recently upgraded a DB from 2003 to 2013 and ran into the following problem.
I have a button that opens a file dialog box and allows the user to upload a file to a predetermined location (and store the address as a hyperlink). I borrowed this code from someone else on here and modified it slightly.
In any case, the button still works, but now when it opens it doesn't have an option for "All files" under file types. So I can upload MS Office files, text files, etc., but not PDF files which are by far the most common types my users upload.
Private Sub Command35_Click()
Dim dd As Integer
Dim fileDump As FileDialog
Set fileDump = Application.FileDialog(msoFileDialogOpen)
dd = fileDump.Show
Dim Yourroute As String
Dim yourrouteName
Yourroute = fileDump.SelectedItems(1)
yourrouteName = StrReverse(Yourroute)
yourrouteName = StrReverse(Mid(yourrouteName, 1, InStr(yourrouteName, "") - 1))
FileCopy Yourroute, "us170fp00dataWBO_Tool_RoomDrawings" & yourrouteName
Me.Drawing_Link = yourrouteName & " # us170fp00dataWBO_Tool_RoomDrawings" & yourrouteName
End Sub
I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.
Please download the attached file !
If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.
Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.
Secondly, I click 'Insert Word Field' -> select 'Next Record'.
In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.
I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:acc_tables and thats where i browsed to (obviously) when i set up the linkage.
One of the users does not wish (for whatever goddamn reason) to create a C:acc_tables file to stick the tables file in , and wants the tables file in some other folder.. Unfortunately this user does not have the skills to delete the existing links and re-link to the tables file after putting it in the folder he wants.
Where in the file that holds the forms and and queries do i find the path setting to the tables linked file? Can it be changed without deleting links and then re-linking?
hello,
I would like to automate something presently done on a one-by-one basis. Here: a number of text files(containing data) are to be exported into an MS Excel file, with each text file to occupy a different worksheet. Presently, the idea is to use the Data/import external data/import data feature of MS Excel for importing the text files one-by-one into newly created worksheets(within the same workbook).
I would appreciate some advice on how to go about creating a useful MS Access application to achieve the above. I have checked the available Macros in MS Access, but I could not find one to suit my purpose. can anyone pls assist, on how I can get started?
Tokunbo
Question: Is it possible, using VBA, to determine the actual Excel file type without opening the file?
I receive data files from other departments. Seems like every time someone changes their download structure, I end up with file types that do not match the download extension (example: xlm file with a xls extension). The files can't even be opened because of this. I think I can fix it if I could figure out how to determine what the file type really is.
I'm using Office 2010.
i had a database that allowed me from a form to store a file location for a record on a form, so i any time i could access the record, and then open the file, usually a pdf, it wasnt stored as a hyperlink, but as long text
i made the mistake of not copying the files for safe keeping when i got a permanent position..i am now back self employed, i need to recreate the database.
I recently upgraded a DB from 2003 to 2013 and ran into the following problem.
I have a button that opens a file dialog box and allows the user to upload a file to a predetermined location (and store the address as a hyperlink). I borrowed this code from someone else on here and modified it slightly.
In any case, the button still works, but now when it opens it doesn't have an option for "All files" under file types. So I can upload MS Office files, text files, etc., but not PDF files which are by far the most common types my users upload.
Here's my code and a screenshot is attached.
Private Sub Command35_Click()
Dim dd As Integer
Dim fileDump As FileDialog
Set fileDump = Application.FileDialog(msoFileDialogOpen)
dd = fileDump.Show
[Code] ....
I am using the following code to select files using Microsoft Office's file dialog:
Public Function fTestFilePicker() As String
Dim fdFileSelection As Office.FileDialog, lstrFileName As String
Const kInitialFile = "F:TestbedTest.txt"
Set fdFileSelection = Application.FileDialog(msoFileDialogFilePicker)
With fdFileSelection
.AllowMultiSelect = False
[Code] .....
When I execute it, the file picker goes to the right folder but does not highlight the file test.txt even though that file name shows in the File name text box. Is there any way to correct this?
hello everyone, i really need some detailed help as the deadline is approaching and I need to find a solution for this. Any help would be greatly appreciated
I currently have a batch file that ftps a text file from a Red Hat Linux Server to my W2k C:. I would like to make another command in the batch file that imports this text file into an existing access table. I would like the text file to repopulate the table everytime it is imported. I do not want the data added on to the existing data in the table.
Thank you for your time and insight.!!!:)
I'm using Access 2000. When I click the File menu to go to a recently used file, the entire path is shown. With my file system, the File drop down widow is about 50 characters too short to show the entire path all the way out to where I keep my database. Is there a way to shut off the viewing the entire path "feature?"
View 2 Replies View RelatedI have a button in the form of the current access file. What I want to do is when the user click on the button,
triggered the vba to backup current access file. But since the file is currently open, is this possible? If yes, may I know how to do it with vba?
I have tried two methods but failed:
1) Use copytofile method, but I get permission denied due to file open;
2) Use dbengine.compactdatabase method, but it also has problem if the file is open.
How do I make an accdr file out of an accde file?
View 9 Replies View Related