Software

Ask something
Discussion Locked

Microsoft Access 97

0 helpful
5 replies

by parier 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a table with the following fields:
First Name
Last Name
SSN
photo path
license number
employee number

Employee number is my primary key. photo path is a path to the location of the license photo. I want to have a report that asks for the employee number and when typed in and user continues, it will show the picture. I can do everything except make the photo display, nothing displays (as far as the picture goes) What should the table filed be and what do I need to do to the form to make the picture display. There are about 12,000 records.

5 replies

by dklippert

The photo field s/b an OLE Object Data Type.
The photo will not show in the table (You'll see "Bitmap Image". You can see an example in the Northwind.mdb sample. Look at the Employees table and the Employees form.

by parier

The file for the employees, names and all is in a spreadsheet, when its in Acces, the path for the pics are a text field, when I change it to OLE, the path disappeard and it does not say BMP, the photos are BMP though, what am I doind wrond? Can I send you the *.xls file (a small version) and tyou can send me back the MDB so I can see how you did it?

by archimede

Insert an Image Object (Linked Type) and, from code, set it's Picture property (for example in the On Current Event). Something like:

Me.Image1.Picture = Me.photopath

HTH.

Alessandro

This discussion is closed to new replies.