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

Image Problems (AutoRepeat and Crash Control)

P: n/a
Hello

I am in the early stages of my project development, and want to make
sure that I am approaching the issue of image display correctly.

Access2000. I have one table and a bound single form. I would like to
have one image (.bmp 100k or .jpg 30k) displayed on the form for each
record. I am using an ImageFrame to display my image, and the
following code to link the image to the display:

'In the InCurrent property of the form.
If Not (IsNull(Me.txtPhotoPath.Value)) Then
Me![imgFrame].Picture = Me![txtPhotoPath]
End

The problem I'm having is the AutoRepeat capability of the lower
NavigationBar becomes disabled if a record containing a (.jpg) is
encountered. It has been established that the "LoadingImage"
dialog that Access automatically pops up is causing this. I noticed
that this does not occur if the image displayed is a (.bmp).

I'm sure that many developers are frustrated by this issue and I'm
wondering what my options are, considering that I want to distribute my
application to many sites that are single user and network based and
need to avoid options that will complicate this goal.

1- Since the LoadingImage dialog has not popped up with (bmp) files and
the AutoRepeat does work, should I commit exclusively to .bmp files???
Also, is it safe to say that I will not crash Access on a fast scroll
thru all the records (200 to 700) over a network when committed to bmp
files??? Or, must I somehow control the scroll speed or resort to a non
autorepeat scroll???

2-Since my image is displayed in a ImageBox, would it work better if I
used a Bound or Unbound OleBox???

3-Changing the registry is NOT an option because I plan to distribute
the application and this would require a registry modification to all
units before the app can be run. Is there a solution or concept of
displaying one image per record as described, using Access exclusively,
without 3rd party stuff???

4-It would be nice to accomplish my objective to include .jpg files
since they are very common! Are there any solutions that would include
this consideration as well???

ThankYou
Greg

Dec 24 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
When it comes to rendering images, in Access as in other software, "patience
is a virtue." There is more processing to be done, apparently, when
rendering an image from a JPG than from a BMP, but the JPG takes less space
to store. You can check MVP Stephen Lebans' site for an approach to
converting an image to BMP separately before displaying it, but that will
take time, too.

Larry Linson
Microsoft Access MVP
<Ap******@gmail.comwrote in message
news:11**********************@a3g2000cwd.googlegro ups.com...
Hello

I am in the early stages of my project development, and want to make
sure that I am approaching the issue of image display correctly.

Access2000. I have one table and a bound single form. I would like to
have one image (.bmp 100k or .jpg 30k) displayed on the form for each
record. I am using an ImageFrame to display my image, and the
following code to link the image to the display:

'In the InCurrent property of the form.
If Not (IsNull(Me.txtPhotoPath.Value)) Then
Me![imgFrame].Picture = Me![txtPhotoPath]
End

The problem I'm having is the AutoRepeat capability of the lower
NavigationBar becomes disabled if a record containing a (.jpg) is
encountered. It has been established that the "LoadingImage"
dialog that Access automatically pops up is causing this. I noticed
that this does not occur if the image displayed is a (.bmp).

I'm sure that many developers are frustrated by this issue and I'm
wondering what my options are, considering that I want to distribute my
application to many sites that are single user and network based and
need to avoid options that will complicate this goal.

1- Since the LoadingImage dialog has not popped up with (bmp) files and
the AutoRepeat does work, should I commit exclusively to .bmp files???
Also, is it safe to say that I will not crash Access on a fast scroll
thru all the records (200 to 700) over a network when committed to bmp
files??? Or, must I somehow control the scroll speed or resort to a non
autorepeat scroll???

2-Since my image is displayed in a ImageBox, would it work better if I
used a Bound or Unbound OleBox???

3-Changing the registry is NOT an option because I plan to distribute
the application and this would require a registry modification to all
units before the app can be run. Is there a solution or concept of
displaying one image per record as described, using Access exclusively,
without 3rd party stuff???

4-It would be nice to accomplish my objective to include .jpg files
since they are very common! Are there any solutions that would include
this consideration as well???

ThankYou
Greg

Dec 24 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.