Return Styles: Pseud0ch, Terminal, Valhalla, NES, Geocities, Blue Moon.

Pages: 1-

VBA Help

Name: Anonymous 2010-06-03 19:17

Alright, I asked /g/ and they don't know anything, so I'll try one of these text board things.

I need some serious help.
I'm kinda new to VBA, and I'm trying to get something to work: I have a series of images stored in a table as OLE files and a second attribute that stores the image name. In a form, I have a list that references the table, listing all the image names.

The problem here is that I'm trying to make a button that, when clicked, opens the OLE file in the table for the item selected on the list.

For example, I have a table with two columns: Image (OLE) and Name (STRING). There are three records: An image of a mouse with the string "Mouse", one of a bird with "Bird" and "Bird", and dog with "Dog".

On a form, I have a list that's listing everything under the Name attribute of the aforementioned table. There is a command button below the list that says "View Image". I want it so the user can select "Bird", click View Image, and have a Message Box pop up displaying the stored OLE file in the table.

I have no clue how to do this. Macros? VBA? Do I have to create an external connection to my own database? I really can't wrap my head around it. Someone help?

Name: Anonymous 2010-06-03 19:20

I should mention that this is being done in Access.

Name: Anonymous 2010-06-03 19:27

Read SICP.

Name: Anonymous 2010-06-03 20:32

I'm not an experienced access user, but I believe you're going to need some very simple .NET...

Name: Anonymous 2010-06-03 20:36

I don't know .NET at all.
At all.

Name: Anonymous 2010-06-03 20:39

>>5
That's not your only problem.

Name: Anonymous 2010-06-04 9:08

Go on Rentacoder and hire an Indian to do it for you. They are very cheap and polite.

Don't change these.
Name: Email:
Entire Thread Thread List