Help with Pictures

[coolcatkelso]

Hiya

Anyone able to help with pictures?

I have a table and form called My Company Information
But would like the user to add a logo which will then be placed on Quotes, INvoices etc

Have no idea how to do this.. Have tried it with OLE Object, but al it displays is the file name?

Any help would be good

I have googled for this, but not 100% how to run it in the DB and get it working.. Still a newbie when it comes to some DB stuff as you can tell

Any help much appreciated

Cheers
________
HOT BOX VAPORIZER

 

[RuralGuy]

See if these examples from Larry Linson give you some ideas.

 

[Mike375]

I have some very limited experence with this.

Like you I found the same with pictures and OLE.

However, GIF files will paste into an OLE field althouh if animated they are not animated in the OLE field. I think that needs some hookup with the internet. I just pasted one below and it is animated in the post I am making but would be still in an OLE

However, the code I use to embed Word or PDF would not work for GIF. But if the GIF file is opened and then saved as BMP the code will embed the BMP in the OLE field.

If the GIF is pasted in then double clicking wont open it. It does for the BMP and code I use also opens the BMP but the proplem in either case is it opens in Paint. However I do't think that is a problem because the idea is the image is small enough that it can be fully dispayed in the field.

However, you would need to find a GIF that has a transparent background otherwise the image will be see in a white surround, which of course is no problem if the field background is white. But if you change the field background to match the form background colour then the white box shows.