I have created a database with a form containing a logo from my current company. The database can be used in other companies.
How can I change the logo without going to the design view.
I have created a database with a form containing a logo from my current company. The database can be used in other companies.
How can I change the logo without going to the design view.
Put the logo in a table. I have a tConfig table and a OLE field. Paste the logo here.
then different companies can have their logo in there.
You can change the logo on many events such as when you open the form of when a user clicks a button. Or even when a record open that is related to a specific company. The possability's are limetless.
Just insert your logo's in the forms design view, you can place them over each other if desired.
For example the on_click event of a button :
Code:me.YourLogoName1.visible = true me.YourLogoName2.visible = false
If you use an image control on the form for your logo, you can just set the image control's Picture property to the path of the picture file of the logo. You can do this programmatically and change the logo based on the condition(s) you desire:
Me![image control].Picture = "C:\My Pictures\logo1.jpg"
If Me![company name]="ABC" Then Me![image control].Picture = "C:\My Pictures\logo2.jpg"
Me![image control].Picture = "" 'No picture
Image control has a ControlSource property. The control can be bound to attachment field of table or have an expression that concatenates file path string and field that contains image name or set programmatically to reference path of external file. I have never used the Picture property. It would have been necessary to use it in Access 2003 and earlier because ControlSource property was added with Access 2007.
I have never used OLEObject field type and control for dynamic display of images, tried but gave issues. Have better results with attachment field and Image control.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you guys for the replies, I will try all.