Pictures in a Access 2002 Form

[John]

I have developed a form to where i scan my pictures
in a file and then they are displayed onto my access 2002
form. They were in .bmp format but the pics were very
distorted so I changed them to .jpg know they look fine..

1.Which format is best ?
2.Why did the pictures change when I changed the format?
3.How do I connect the right picture with the current
record
that I will be entering?
4.Also since I changed the file ext. to .jpg the import
picture box flashes up when I scroll through the pictures
i have in there,
5. How do I get this not to show up on the screen when
scrolling through the Pics??
6.Also I want to add knew records with pics and delete do
I do a cmd box for this procedure if so do you know of
any code examples for this?? or how I can achieve this on
my form?

 

[Adrian Jansen]

Look on http://www.lebans.com for info on handling pictures in Access,
there is a *lot* of info there.


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

> I have developed a form to where i scan my pictures

> in a file and then they are displayed onto my access 2002

> form. They were in .bmp format but the pics were very

> distorted so I changed them to .jpg know they look fine..
> 1.Which format is best ?

> 2.Why did the pictures change when I changed the format?

> 3.How do I connect the right picture with the current

> record

> that I will be entering?

> 4.Also since I changed the file ext. to .jpg the import

> picture box flashes up when I scroll through the pictures

> i have in there,

> 5. How do I get this not to show up on the screen when

> scrolling through the Pics??

> 6.Also I want to add knew records with pics and delete do

> I do a cmd box for this procedure if so do you know of

 

[John]

Mr. Jansen I looked at the lebans site downloaded a few
things it didnt help with any of my questions it just
told me thing I have already done...any other suggestions?

>-----Original Message-----

>Look on http://www.lebans.com for info on handling

pictures in Access,

>there is a *lot* of info there.




>Adrian Jansen

>J & K MicroSystems

>Microcomputer solutions for industrial control

>>> I have developed a form to where i scan my pictures

>> in a file and then they are displayed onto my access

2002

>> form. They were in .bmp format but the pics were very

>> distorted so I changed them to .jpg know they look

fine..

>> 1.Which format is best ?

>> 2.Why did the pictures change when I changed the

format?

>> 3.How do I connect the right picture with the current

>> record

>> that I will be entering?

>> 4.Also since I changed the file ext. to .jpg the import

>> picture box flashes up when I scroll through the

pictures

>> i have in there,

>> 5. How do I get this not to show up on the screen when

>> scrolling through the Pics??

>> 6.Also I want to add knew records with pics and delete

do

>> I do a cmd box for this procedure if so do you know of

>> any code examples for this?? or how I can achieve this

on

>> my form?

[/QUOTE]

 

[Adrian Jansen]

There are lots of code examples to handle pictures, both on Stephen Lebans
site, and on http://www.mvps.org/access and also
http://www.datastrat.com/DataStrat2.html

You can also do a search within the Google archive, and get lots of example
code, just enter 'image' or 'picture' in the search within this newsgroup:


http://groups.google.com/groups?hl=...eta=group=microsoft.public.access.formscoding

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

> Mr. Jansen I looked at the lebans site downloaded a few

> things it didnt help with any of my questions it just

> told me thing I have already done...any other suggestions?


pictures in Access,









> >
2002
fine..

format?



pictures


do
on

[/QUOTE]

 

[Stephen Lebans]

You're asking a lot of questions at one time. First you need to take a
few minutes to look at the following URLs.:

Handle/Display images in forms/database
http://www.mvps.org/access/forms/frm0030.htm

Larry's samle MDB:
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.

Answeres to your orignal questions inline.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

> Mr. Jansen I looked at the lebans site downloaded a few

> things it didnt help with any of my questions it just

> told me thing I have already done...any other suggestions?


pictures in Access,

There is no best format. Since the images are being stored externally
most people orignally use Jpeg due to filesize and network bandwith
considerations. THese days with 100+ GB Hard Drives and 100Mbit or
higher bandwith for networks you can store the images in whatever fiel
format you desire.

format?

Certain versions of Access have trouble with displaying BMP files when
you ask the Image control to display them at a SizeMode other than Clip.
This issue has to do with the case of the filename extension and whether
Acces uses its internal graphics filters or those of MS Office to load
the images. See:
http://www.lebans.com/image_faq.htm

Again, look at the sample KB articles and Larry's site for examples.
It's not rocket science. You generally store the filename of the Image
in a field for each row of your table.


Use the Registry solution here:
http://www.mvps.org/access/api/api0038.htm
If you using WinXp Pro then you may have to apply the reg fix to more
than one area depending how you are logging on to your system.

on my form?

See the example at Larry's site mentioned above.