Image in form..?

[Kent J]

Hi all,


I would like to put different images (my collegues) to all records and
move through in the recordset in a form.
How can I do this?
If I design a table I cannot find the appropriate datatype.
What should it be?

Kent J.

 

[Guest]

You should never embed image into your db because it will cause bloating.
Thus the 'proper' way is to simply store the path in a table. thus, Text or
Memo depending on how you tackle the problem.

Take a look at the following sample db. you can dissect them to get all the
coding...
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#images
http://www.cardaconsultants.com/en/msaccess.php?lang=en&id=0000000007#album

Check out http://www.mvps.org/access/forms/frm0030.htm for some more info.
You can also search this very forum (or Google) for more info. This one been
covered numerous times. Lots of info available, you just need to search a
bit.

 

[Arvin Meyer [MVP]]

There are several ways to work with images in Access. I prefer using the
path to an image file because it uses the smallest footprint. A sample app
that does this and demonstrates how is on my website:

http://www.datastrat.com/Download/Picture2K.zip