[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • Last Modified:

change logo in ms access 2010 database

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
timohorn
Asked:
timohorn
  • 6
  • 3
  • 2
  • +1
1 Solution
 
Dale FyeCommented:
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
 
timohornAuthor Commented:
can you give me an example of the code ? please ;-)
because this sounds just as a solution to me .
0
 
mbizupCommented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
When you say 'throughout' ... can you give some examples?

mx
0
 
timohornAuthor Commented:
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
 
Dale FyeCommented:
Sorry, I'm not familiar with this "default logo" aspect of Access 2010.
0
 
timohornAuthor Commented:
That's a pitty, but if can do it with code then it would be fine ;-))
0
 
mbizupCommented:
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
 
timohornAuthor Commented:
thanxs
0
 
mbizupCommented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
 
timohornAuthor Commented:
Yes i will do so today
0
 
timohornAuthor Commented:
you're right there's no common icon :-(
so your solution works the best
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 6
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now