Access database with a Word-attachment...

[Annemarie]

Hi,

I am hoping someone can help me.

I have build a database in Access but have only one thing that I can't do. Its a database for work which contains both personal and work-related info.

I need to attach a Word doc to every employee entered in the database. Only problem is, for every employee it has to be a different document.

Also there has to be a button with which the person filling the database can search for the right document and add that without any trouble.

Then there has to be a button for the person looking at the information in the database to either put in another document (if necessary), and open the word document and alter that.

Does anyone know if this is possible and if so, how do I do this?

Annemarie

[ADezii]

Hi,

I am hoping someone can help me.

I have build a database in Access but have only one thing that I can't do. Its a database for work which contains both personal and work-related info.

I need to attach a Word doc to every employee entered in the database. Only problem is, for every employee it has to be a different document.

Also there has to be a button with which the person filling the database can search for the right document and add that without any trouble.

Then there has to be a button for the person looking at the information in the database to either put in another document (if necessary), and open the word document and alter that.
Does anyone know if this is possible and if so, how do I do this?

Annemarie

How about a button that opens a standard Office File Dialog Box from which you can select a file and store its Absolute Path internally then another button that will actually Open the File for Viewing/Editing if so desired. If this is what you are requesting, let me know and I'll start work on the coding. It may, however, be a little involved. The other option would be to store the actual Word Documents in an OLE Object Field which would initiate its own set of problems given what you would like to achieve.

[Annemarie]

How about a button that opens a standard Office File Dialog Box from which you can select a file and store its Absolute Path internally then another button that will actually Open the File for Viewing/Editing if so desired. If this is what you are requesting, let me know and I'll start work on the coding. It may, however, be a little involved. The other option would be to store the actual Word Documents in an OLE Object Field which would initiate its own set of problems given what you would like to achieve.

This is exactly what I want :) One button for the one filling in the database and one for the one viewing the database.

If you could find the coding for me I would be most grateful.

Annemarie

[lordcenon]

Hi,

I am hoping someone can help me.

I have build a database in Access but have only one thing that I can't do. Its a database for work which contains both personal and work-related info.

I need to attach a Word doc to every employee entered in the database. Only problem is, for every employee it has to be a different document.

Also there has to be a button with which the person filling the database can search for the right document and add that without any trouble.

Then there has to be a button for the person looking at the information in the database to either put in another document (if necessary), and open the word document and alter that.

Does anyone know if this is possible and if so, how do I do this?

Annemarie

I have done this in VB, but I am sure this would work the same in MS Access no matter what the version.

1) In your table, create a new field as Text with 255 length as maximum or to your desired len if you are sure. This field would contain the path for the MS Word document field.

2) Create a button that once pressed will ask you to input the path and filename of the Word document

3) Another button that will launch the MS Word application program with the path and filename as its parameter

This is one of the method. If this is what I understand to your problem, let me know, I may have additional method to do it.

So everytime a new person is displayed on screen, you can specify, modify or call MS Word application to open up a given path and filename of the document.

Regards.

[ADezii]

This is exactly what I want :) One button for the one filling in the database and one for the one viewing the database.

If you could find the coding for me I would be most grateful.

Annemarie

'Must set a Reference to the Microsoft Office XX.X Object Library and
'must be working with at least Access 2002
 
'Set up the File Dialog Box
With Application.FileDialog(msoFileDialogFilePicker)
  With .Filters
    .Clear
    .Add "Word Documents", "*.doc"
  End With
   .AllowMultiSelect = False    'only 1 File allowed to be selected
   .Title = "Select a Document For Form Entry"  'can change
   .ButtonName = "Open Document"                'can change
   .InitFileName = vbNullString                 'can change
   .InitialView = msoFileDialogViewDetails      'can change
 
     'if the Show Method returns True, the User selected a File
     If .Show = True Then
       For Each varFile In .SelectedItems
         Me![txtDocument] = varFile     'place the Absolute Path of the selected fileinto the [txtDocument]
                                        'Field. Set its Control Source to a Field [TEXT] in the underlying
                                        'Table
       Next
     Else
       MsgBox "No Document was selected", vbExclamation, "No File Found"
     End If
End With

Decided to go the simple route rather than the more complex one. In the Click() Event of a button named Load Document next to you Document Field (let's say [txtDocument], place the following code. Once you have entered Documents into the Database, and you have successfully opened them, this Field should be locked for obvious reasons.

Dim varRet As Variant
 
'If there is no value in the the [txtDocument] Field
If IsNull(Me![txtDocument]) Then
  MsgBox "There is no Document to Load", vbExclamation, "No Document Listed"
    Exit Sub
End If
 
Does the File and Path stored in the Database actually exist on the Local/Network Drive?
If Dir$(Me![txtDocument]) <> "" Then    'File does physically exist
  'Default location of the Microsoft Word executable, change if necessary
  varRet = Shell("C:\Program Files\Microsoft Office\Office\winword.exe " & Chr(34) & Me![txtDocument] & Chr(34), vbMaximizedFocus)
Else    'File does not physically exist
  MsgBox Me![txtDocument] & " does not exist in the specified Directory", vbCritical, "File Not Found"
End If