ogl.dll for Lebans' graphics

[Petr Danes]

No, I guess I didn't explain it properly. That's what I thought was going on, when I tested it at the customer's site, and when I started the thread.

What's actually happening is I'm loading the image from an OLE object field into a Ribbon Command Button. The button initialization callback routine getImage retrieves the image from a table, and returns it to the getImage routine, using this code:

Public Function getIconFromTable(strFilename As String) As Picture
Dim LSize&, arrBin() As Byte, rst As DAO.Recordset
Set rst = DBEngine(0)(0).OpenRecordset("tblBinary", dbOpenSnapshot)
With rst
.FindFirst "[FileName]='" & strFilename & "'"
If .NoMatch Then Stop ' Programátorská chyba, nemìlo by se stát.
LSize = .Fields("binary").FieldSize - 1
ReDim arrBin(LSize)
arrBin = .Fields("binary")
Set getIconFromTable = ArrayToPicture(arrBin)
.Close
End With
Set rst = Nothing
End Function

The function ArrayToPicture is what I'm using to convert the OLE object to its usable form for a button icon.

[June7]

The example db's were built as mdb files. mdb structure is very different from accdb. It's nice they still run in Access 2007 and 2010. I do not have 2013 and probably never will.

The fact no one else has jumped in by now is an indicator that finding answer through forum is unlikely. I certainly have nothing else to offer except Good Luck.

[Petr Danes]

Okay, thanks for trying. Here's the site that set me onto this in the first place:

http://www.accessribbon.de/en/?Acces...ontrols#basGDI

You'll notice that it is meant for .accdb, not .mdb, since that format came with 2007 - ribbon controls didn't exist prior to that. But apparently something else has changed between in 2013. It still works okay in 2010, and runs on both 32- and 64-bit machines.

[June7]

I am familiar with Avenius site. It helped me build custom ribbon. I didn't need any custom icons.

[Petr Danes]

Unfortunately, I did need them. I looked all through the built-in ones I could find - it would have made this a lot easier, but what I needed just wasn't there.

But I'm confused - since you're familiar with this site, why did you mention .mdb files? I'm doing ribbon icons, and even Lebans' last activities on his site postdates the arrival of 2007 and the .accdb format by several years.

This all has to do with moving images, not Access' internal file format.

[June7]

The downloads I found from Lebans site were mdb files. They didn't deal with customizing menu or ribbon.

[Petr Danes]

Yeah, Lebans did most of his development back in the .mdb days. Pity he dropped out of the game - he wrote some insanely useful stuff. Would have been nice if Microsoft had incorporated it into their newer releases, especially after he quit. But everything of his that I've used so far, including this, has worked fine in the new format, which is a remarkable feat in itself, and a testament to the quality of his code.

Something else is wrong here - not Lebans' code - that was a mistake on my part, thinking that was where the problem was. The problem is loading the ribbon icon images, which has nothing to do with Lebans' code, except that those buttons then call some of his routines when the user presses them. And it's a problem in 2013, not 2007 or 2010, so the .accdb format has nothing to do with it. It's a problem locating and using that pesky graphics .dll, whatever it has become in the 2013 release.

But again, thanks for trying - I'll post back in this thread if I ever get it figured out.

[Petr Danes]

Well, I got it. Wrote the guys at Avenius directly. Unbelievable response - I wrote them Friday evening, actually after midnight Friday night. When I woke up Saturday morning, a working solution from them was waiting in my Inbox.

They call GDIPlus.dll, instead of OGL.dll. I thought that was one of the variations I tried when working on this problem myself, but apparently I either did it wrong, or there is something else in the code that I'm missing. I will have to put the routines up side by side and see what they did.

In any case, I can't praise these these guys enough. Here is one of their sites, for anyone else reading this: http://www.ribboncreator2013.de/en/ Crammed full of useful information and great software. If you have ribbon problems or questions, try them first.