Yotafan said:
I basically need to have a search box for lastnames and search a name.
Then
have name and photo populate.
Can this been done in access or would it be easier in something else.
I am a hardware networking guy bit think i can figure out enough to do
this
project with some guidance.
The following applies to Access 2003 and earlier. There have been
improvements in handling images as OLE Objects in Access 2007, but not
enough to overcome all the disadvantages, IMNSHO.
The sample imaging databases at
http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects.
For a search, if my example code (which you are welcome to use as a start...
just realize it is not, and I don't represent it to be, a complete, finished
application) does not provide all the facilities you need, you'll likely
want to have the users' names in a table (probably with a path-and-file to
the picture), and create a Combo Box to search on user's last name.
If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans'
http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.
Larry Linson
Microsoft Access MVP
