Sorry your browser is not supported!

does anyone know of a library or DLL that I'm going to be able to use within Access, at work? (i.e. I have no install privileges)

I need to be able to take some info off the database and create a simple image to be displayed on a screen, preferably with as little effort and heartache as possible.

you dont need a dll, and you dont need to install anything. If you have the image data in the database (does access store the Binary Type?) you read the data into a byte array in vba, then convert the byte array to an image, and display it in a control.

Use the Picture Box control that is part of VBA.

You know that you can draw directly with Access as well, like you could plot the data directly onto a report, look up the PSET command.

The only instance that I've used this technique was when drawing vertical lines in a report, but there's nothing stopping you from drawing the whole image with code, maybe based on a simple array.

thanks for the quick replys and I'm glad i don't have to mess around with libraries and such, I think I should have been more specific though.

The image i need to generate will be of which course modules are expected to be handed in that day, really all the image will need to be is a table, displaying like this;

Module Code | Module Name
BIOL/00127 | Human Genetics
CHEM/02344 | Medicinal Chemistry
etc | etc

as far as my understanding goes at the moment, the screens that the Uni use around the place run off a folder of images.

Either that, or a screen that is seperate from the rest of the system will need to display the information, directly off the database. I've got no experience of this area though, and it largely depends on what hardware is available.

I had hoped that i might just be able to generate a report, and then save it out as a jpg, but no luck there.

I'm having a bit of trouble concentrating right now, the office is hot and i've only had one coffee today, so sorry if this post seems a bit garbled.

cheers guys

Manic