convert images to bitmap

[Guest]

Hi
I have a database with a field in a table for 'employee photo'. i have a
folder on my server with maybe 200 JPG photo's which i want to link to the
database. I have read up various ways of doing this on the internet, and the
way i would like to try is by converting these files all to BITMAP files. I
will need these pictures to show up in the forms and reports.

Is this the best way for me to do this. It did mention using VBA code to use
less space, but I am not educated in VB. Please could someone tell me if i am
going to be okay doing it this way, and if so, how do i go about it?, or if i
should do it another way?

Thank you in advance
Kind Regards
Rigby

 

[Guest]

Hi,
You do NOT want to store images in your application. It create massive bloat
and should be avoided. Rather store the path to the image in a text field and
then use it at runtime to display your image on the form or report. There is
no real need to convert your images to bitmaps as long as you and your users
have the Office Graphic Filters installed, if not then have a look at Steph
Lebans: http://www.lebans.com/loadjpeggif.htm
Furthermore have a look at this tutorial:
http://www.databasedev.co.uk/bound_image_form.html
You could also take a look at the northwind sample database as the employee
form is very similar to what you are trying to achieve.
Last but not least Candace Tripp has a great sample on how to include images
in a database as well:
http://www.candace-tripp.com/pages/access_downloads.aspx
This should get you started and give you an idea.
HTH
Good luck

 

[Guest]

Hi
I have downloaded a trial piece of software to help with my placing employee
photo's on my forms and reports. it is called "DBPix 2.0 Control". It seems
to work quite well and its almsot doing what i want it to do.
I have managed to create a pretty big form (with 7 tab control pages) which
i know is a lot with so many controls on each page, but this company requires
masses of information on each individual. My form is working fine, until I
add my 'tImages' Table to the Form's Record Source. Then it suddenly won't
allow me to edit, add or do anything else with my form.
I have had trouble with this for a couple days now, but have narrowed it
down to this problem. How can I go about avoiding it, yet at the same time, I
still need to add the image control to the form??

Please Help!!!
Thank you
Rigby

 

[Guest]

Hi,
You most likely create a non updateable recordset.
There are many reasons for a recordsource to become non updateable here are
a couple:

1. Improper join
2. Aggregate functions
3. Multiple non-hierarchial 1-many relationships
4. Security
5. No primary key on a linked table.
All these things will result in a source which is non updatable. Most likely
it is a relationship issue.
I am not familiar with the additional control you purchased, but as
mentioned before it is not such a big deal to add pictures to your database.
HTH
Good luck