473,320 Members | 1,580 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Image database

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
5 6393
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
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
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
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
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Ester | last post by:
Instead of drag and drop image button from Toolbox and name the image button id on the properties box, I would like to load image button ID from database. I created a database table that stores...
1
by: John Scott | last post by:
I am storing an image in an SQL database and have one field as an image datatype. I am also using a webservice to transport data. I want to be able to resize the image and pass back a thumbnail...
6
by: bissatch | last post by:
Hi, I am currently writing a news admin system. I would like to add the ability to add images to each article. What I have always done in the past is uploaded (using a form) the image to a...
6
by: Rudy | last post by:
Hello all! I am amazed how many posts I have read to store an image in SQL, and just as many against it. So I learned how to store an image in a SQL db and retrieve the image. A little tricky,...
13
by: Neo Geshel | last post by:
I have examined about 80+ different upload scripts on the 'net, both in VB and C#, and none seem to do what I need them to do. Perhaps someone here can point me somewhere that Google hasn't...
35
by: Stan Sainte-Rose | last post by:
Hi, What is the better way to save image into a database ? Just save the path into a field or save the image itself ? I have 20 000 images (~ 10/12 Ko per image ) to save. Stan
7
by: lgbjr | last post by:
Hello All, I¡¯m using a context menu associated with some pictureboxes to provide copy/paste functionality. Copying the image to the clipboard was easy. But pasting an image from the clipboard...
3
by: den 2005 | last post by:
Hi everyone, Here is code working on..Trying to insert record with a column with Image or VarBinary datatype in sql database from a existing jpeg image file, then retrieve this image from...
7
by: eholz1 | last post by:
Hello Group, Perhaps you can help me. I have a mysql db, that holds images. Images are encoded using base64_decode/encode, etc. Image data seems fine. I have a view.php page that is supposed...
10
by: Nathan Sokalski | last post by:
I am using ASP.NET 2.0, and need to know how to save and use an image that is stored in an SQL Server image datatype. How can I do this using ASP.NET? Thanks.
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.