How to stop screen flicker with Access 07 and jpeg

I have a Asset Locator DB in which I have hundreds of jpegimages, each image is tied to a asset number. Whenever I go through the db either to change something or to add a new asset the screen flickers, how can I stop this.
I read that maybe by changing the images all to bmp format that this would stop it, but it didnt work either. All of the images are in the same file location as the db is as well.
Any help or suggestion is greatly appreciated.
Engtech05Asked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
Not sure perhaps this is just a function of how Attachment fields move from image to image.
Your DB is 11MB with only 11 records, so this tells me that this images are fairly large.
Any chance of you using lower resolution images and see if this helps?

Any particular reason why you are storing the images "In" the DB instead of linking to them?
What happens if the image need to be updated?
What happens when you need to get the image "Out" of the DB?

In your case if the DB gets corrupted all your images may be lost forever... Is this OK with you?
You also have to delete the existing attachment and add another one if the image needs to be updated.
You also have to employ some fairly complex code when you need to save the attachment out of the DB as a file...

For all of these reason most developers use a "Linking Method" so that all my images are stored on a "Server" (Central access, RAID, Redundant backup, Secure, ...etc)

Here is a very basic sample
Try it and see if you still get "Flicker"...
I linked to a 10MB bmp and a 2MB jpg, and expirenced no flicker when moving form record to record.
...and the DB was only 300K!

JeffCoachman


Access-BasicLinkFormReportImages.mdb
0
 
Mike EghtebasDatabase and Application DeveloperCommented:
Does if flicker when you move mouse around? If so, what events like mouse move etc.you have?

Could you post a sample database you have to be checked?

Mike

0
 
Engtech05Author Commented:
It only flickers when I press the next record button or the previous button.
I can post but it will take a few minutes.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Engtech05Author Commented:
If you need the images I can post those as well
Asset-Locator-Test.accdb
0
 
Engtech05Author Commented:
Ok, so all I have to do is replace the image box and reset some code, sounds good to me. I am still laughing at some of the code 'bow to rmbonds' what a riot. I will start to work on this today.
0
 
Engtech05Author Commented:
Working wonderfully, learn something new everyday. I will have to remember this.
0
 
Jeffrey CoachmanMIS LiasonCommented:
<I am still laughing at some of the code 'bow to rmbonds' what a riot.>
LOL
Yeah, it was a sample I created for another Q a while ago, so I just grabbed it from there.
(I had forgotten about the "Custom text")
I'll should really modify that to be a bit more "Generic" I guess...
;-)

Glad I could help...

BTW, I was in no way saying that you should never use Attachment fields.
There are sometimes when embedding a file is useful. (Simple graphics needed in the DB as logos, file "SnapShots",..etc)
The new attachment datatype does a great job of reducing the file size.

But from what you posted, it looks like you were displaying reference images, so file size, extraction and updates are a real possibility.
It is easier to "manage" these types of files from a central location (files stored on a server and "linked" into the database.)

Just something to keep in mind.

;-)

JeffCoachman
0
 
Engtech05Author Commented:
Thanks again for the help Jeff, I did change one line of code because it kept taking me back to the first record, original code was:
    'DoCmd.GoToRecord , , acFirst
I commented that out and replaced it with DoCmd.GoToRecord , , acNext. It achieves the same thing but now I don't have to jump through records to see the image.
Again thanks for the help.
0
 
Jeffrey CoachmanMIS LiasonCommented:
I now "Bow" to you...

;-)

Jeff
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.