Solved

How to stop screen flicker with Access 07 and jpeg

Posted on 2011-09-30
9
439 Views
Last Modified: 2012-08-13
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.
0
Comment
Question by:Engtech05
  • 5
  • 3
9 Comments
 
LVL 33

Expert Comment

by:Mike Eghtebas
ID: 36892954
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
 

Author Comment

by:Engtech05
ID: 36892972
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
 

Author Comment

by:Engtech05
ID: 36893049
If you need the images I can post those as well
Asset-Locator-Test.accdb
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 36894304
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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:Engtech05
ID: 36903238
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
 

Author Closing Comment

by:Engtech05
ID: 36903242
Working wonderfully, learn something new everyday. I will have to remember this.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36904719
<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
 

Author Comment

by:Engtech05
ID: 36905196
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36906265
I now "Bow" to you...

;-)

Jeff
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Importing table data from 1 access database to another? 5 36
vba DCount with 2 criteria 3 33
data analyst 3 48
MS Access Order Smallest to Biggest Query Help 13 40
This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now