Solved

change logo in ms access 2010 database

Posted on 2012-03-21
13
255 Views
Last Modified: 2012-08-13
I have one fronted and several backend databases, i know how to switch the backen from one company to an other, but i would also like to change the company picture(s) throughout the database.

i could make a subform, and use an attachment or ole object but then i have to do it for all forms.

anny suggestions or solutions. ??
0
Comment
Question by:timohorn
  • 6
  • 3
  • 2
  • +1
13 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
Comment Utility
Best way is to not embed the pictures from the start.  They should be linked from a file that is stored somewhere it is not likely to be deleted or moved from.  

The way I do this is in applications startup procedure, I check for the existence of a specific picture on a specific path.  If that picture doesn't exist, I ask the user if they would like to select a corporate logo to use throughout the application.  If so, I allow them to select to the logo file, which I then copy and rename to my selected path.  If they choose not to add a logo, I use mine.  This will also significantly reduce the size of your application, as you won't have pictures embedded on multiple forms and reports.
0
 

Author Comment

by:timohorn
Comment Utility
can you give me an example of the code ? please ;-)
because this sounds just as a solution to me .
0
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
It would be good to have more information about your database and how your pictures are stored and displayed.

A solution we have used to a similar issue is to have consistent names between projetcs (or in your case compnies) for any logos/images displayed throughout the database.

We have a table, tblPaths which stores paths to various project specific 'things' we might need to lookup:

tblPaths
_________
ID    (AutoNumber)
Resource (Text - specify type of thing, such as Image Files, Web Path, PDF Files, ETC)
Path  (Memo - specifies the path)

The record in this table for Images might look like:

ID:  12
Resource:  Image Files
Path:  "z:\ProjectName\Files\ImageFiles\"

This table holds project (or company) specific information, and is populated according to the location where the database is deployed.


Any time we need to use something like a logo we would look up its path, and then specify the standard filename as follows:

strPathToMainFormLogo = DLookup("Path","tblPaths",  "Resource = 'Image Files'") & "MainFormLogo.jpg" 

Open in new window

0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
When you say 'throughout' ... can you give some examples?

mx
0
 

Author Comment

by:timohorn
Comment Utility
in access 2010 you can "set" a company logo, and when us create a new form you can show that logo.
so i would like to be able to change that default logo.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
Comment Utility
Sorry, I'm not familiar with this "default logo" aspect of Access 2010.
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

Author Comment

by:timohorn
Comment Utility
That's a pitty, but if can do it with code then it would be fine ;-))
0
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
Hang in there... there are undoubtedly people  out there with 2010 who can check into this.  Ive never used that feature either but will look into it when I get home if nobody else has responded.
0
 

Author Comment

by:timohorn
Comment Utility
thanxs
0
 
LVL 61

Expert Comment

by:mbizup
Comment Utility
I'm browsing around in Access 2010, and don't see any specific "Logo" options, and am guessing this is somehow based on a standard image control.

Are you able to upload a sample database (with no sensitive data) - just enough of a sample to show us what you are trying to describe?
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
Comment Utility
Can you post a screen shot of this 'option' ?
If nothing else, take a blank form, embed an image (ico, gif or jpg, not bmp) . This form becomes your 'image logo holder'.  Then, use it as a subform/subreport on any Form/Report, in the head section.  Down the road, if you have to change the image - you only have to change it in one place.

mx
0
 

Author Comment

by:timohorn
Comment Utility
Yes i will do so today
0
 

Author Closing Comment

by:timohorn
Comment Utility
you're right there's no common icon :-(
so your solution works the best
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

743 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

15 Experts available now in Live!

Get 1:1 Help Now