By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,762 Members | 1,838 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,762 IT Pros & Developers. It's quick & easy.

Image database

P: n/a
I was wondering if any one of you have some tips on how to display my images
when I browse each record in a form.

I have the following data structure on my access database:

ImgID: text
ImageDir: text
Description: memo
Note: memo

The full path of each image is the following:

<$ImgDir>\<$ImgID>.JPG
I'd like to be able to add, delete, modify any of the info
in the Form View as well as view the image in the form.

Please advise. Thanks
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Open your form in design view. Click on the Toolbox button in the toolbar at the
top of the screen. Select Image Control. Move your cursor down to the form and
draw the control about 2" x 2".Name the introl "MyImage". Put the following code
in the OnCurrent event of your form:

Me!MyImage.Picture = "C:\" & Me!ImgDir & "\" & Me!ImgID & ".jpg"
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com

"Artco News" <DE******************@verizon.net> wrote in message
news:Wl*****************@nwrdny02.gnilink.net...
I was wondering if any one of you have some tips on how to display my images
when I browse each record in a form.

I have the following data structure on my access database:

ImgID: text
ImageDir: text
Description: memo
Note: memo

The full path of each image is the following:

<$ImgDir>\<$ImgID>.JPG
I'd like to be able to add, delete, modify any of the info
in the Form View as well as view the image in the form.

Please advise. Thanks

Nov 12 '05 #2

P: n/a
There are example databases for Access 97 and for Access 2000 and later that
you can download from http://accdevel.tripod.com -- they illustrate three
approaches to handling images in Access, including the one you apparently
want to use (the external file approach). The path and filename are not
stored in separate pieces, but concatenating text strings with the &
operator isn't a big deal.

Larry Linson
Microsoft Access MVP
"Artco News" <DE******************@verizon.net> wrote in message
news:Wl*****************@nwrdny02.gnilink.net...
I was wondering if any one of you have some tips on how to display my images when I browse each record in a form.

I have the following data structure on my access database:

ImgID: text
ImageDir: text
Description: memo
Note: memo

The full path of each image is the following:

<$ImgDir>\<$ImgID>.JPG
I'd like to be able to add, delete, modify any of the info
in the Form View as well as view the image in the form.

Please advise. Thanks

Nov 12 '05 #3

P: n/a
I did what you suggested but when I Select Image(or ImageDO or ImageMgrData
Control) and put them in the canvas, it gives me error
" The Operation on the OLE object failed...."

Thanks
"PC Datasheet" <sp**@nospam.net> wrote in message
news:aA**************@newsread2.news.atl.earthlink .net...
Open your form in design view. Click on the Toolbox button in the toolbar at the top of the screen. Select Image Control. Move your cursor down to the form and draw the control about 2" x 2".Name the introl "MyImage". Put the following code in the OnCurrent event of your form:

Me!MyImage.Picture = "C:\" & Me!ImgDir & "\" & Me!ImgID & ".jpg"
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com

"Artco News" <DE******************@verizon.net> wrote in message
news:Wl*****************@nwrdny02.gnilink.net...
I was wondering if any one of you have some tips on how to display my images when I browse each record in a form.

I have the following data structure on my access database:

ImgID: text
ImageDir: text
Description: memo
Note: memo

The full path of each image is the following:

<$ImgDir>\<$ImgID>.JPG
I'd like to be able to add, delete, modify any of the info
in the Form View as well as view the image in the form.

Please advise. Thanks


Nov 12 '05 #4

P: n/a
How would you do that in Access 2002?

Much appreciated

"Larry Linson" <bo*****@localhost.not> wrote in message
news:Vn***************@nwrddc03.gnilink.net...
There are example databases for Access 97 and for Access 2000 and later that you can download from http://accdevel.tripod.com -- they illustrate three
approaches to handling images in Access, including the one you apparently
want to use (the external file approach). The path and filename are not
stored in separate pieces, but concatenating text strings with the &
operator isn't a big deal.

Larry Linson
Microsoft Access MVP
"Artco News" <DE******************@verizon.net> wrote in message
news:Wl*****************@nwrdny02.gnilink.net...
I was wondering if any one of you have some tips on how to display my

images
when I browse each record in a form.

I have the following data structure on my access database:

ImgID: text
ImageDir: text
Description: memo
Note: memo

The full path of each image is the following:

<$ImgDir>\<$ImgID>.JPG
I'd like to be able to add, delete, modify any of the info
in the Form View as well as view the image in the form.

Please advise. Thanks


Nov 12 '05 #5

P: n/a
"Artco News" wrote
How would you do that in Access 2002?


Same way you'd do it in Access 2000. Open the Access 2000 sample database in
Access 2002 and Convert.

There was a difference in the way string storage was defined between Access
97 and later versions of Access -- that's why there are two examples. String
storage is handled identically in Access 2000, 2002, and 2003, so no
revision to the Access 2000 example was necessary.

Larry Linson
Microsoft Access MVP
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.