Another newb

[peterbowles]

Hi all two things please

1) I have a form that displays information about employees each employee has a picture I would like a button on a form to open a specific folder on my machine (C: Images) and then place the picture with that record.

Thanks in advance

2) i have an excel spreadsheet with name and other information how do you automaticall put that spreadsheet into the correct table and also send the data in that table back to excel and in an email

Any help would be great

 

[Graham T]

Peter

To display images:

How to include a bound picture on form:

While it's possible to actually store the images within the database itself as OLE objects, normally it's not the preferred way. When you embed an OLE object in a table, you're storing a lot of overhead as well. This overhead is the information about the object (such as it's parent application) that Access needs to store in order to render the object properly.

The preferred way to display images is to store the complete path and filename to the actual files themselves within a table, and then use the Image tool (in Access 97/2000) to update the display.

The following example shows you how to display Windows bitmap images on a Microsoft Access form without storing the images in a Microsoft Access table.

Creating the Table to Store File and Path Data:


Create a new table that is named Imagetable and then add a text field that is named ImagePath.

Open the Imagetable table in Datasheet view and then add the path and the name of a bitmap file to each record. The following examples show how the records might look:
c:\windows\circles.bmp
c:\windows\waves.bmp
c:\windows\tiles.bmp
c:\windows\bubbles.bmp

Displaying Images in a Form :


Use the AutoForm: Columnar Wizard to create a new form that is based on the ImageTable table.

Open the Imageform form in Design view and then add an image control to the form by using the Image tool in the toolbox. You are prompted to select an image to insert. Select any image available on your computer. Name the control ImageFrame.

Set the OnCurrent property of the Imageform form to the following event procedure:
Private Sub Form_Current()
On Error Resume Next
Me![ImageFrame].Picture = Me![ImagePath]
End Sub

Set the AfterUpdate property of the ImagePath text box to the following event procedure:

Private Sub ImagePath_AfterUpdate()
On Error Resume Next
Me![ImageFrame].Picture = Me![ImagePath]
End Sub


Open the Imageform form in Form view. Notice that the form displays the corresponding bitmap for each record.

Note: You may need to amend the file paths and image names to correspond with images stored on your system.

You could solve your spreadsheet problems by linking the spreadsheet to the database.

Look at File >> Get External Data >> Link.

HTH

Graham