1.

Solve : Microsoft Access?

Answer»

Hey people,

I'm PUTTING together this applicatino at WORK using MS Access and I've got a button on there that I would like to have the image of change depending on a value in one of my tables.

Does anybody know how to do this? I have made a entry in my table Tabel1 and its a number, basically I want the image to change depeding on what number is in the value of it. The options are 0, 1 and 2.

What I'm after is something like:

IF value in Table1 = 0 THEN image of button = redlogo.bmp
IF value in Table1 = 1 THEN image of button = amberlogo.bmp
IF value in Table1 = 2 THEN image of button = greenlogo.bmp

I know the above is pretty much USELESS PSEUDOCODE but its just a guide.

ThanksI think it's something like buttonX.image = blah or buttonX.background= blah or buttonX.backgroundimage = blah. When you put the button name then the '.' a list of AVAILABLE options should pop up, scroll through that for ideas.I'd say create the button at runtime.

headstart:

http://www.vbexplorer.com/VBExplorer/vb_feature/april2000/april2000.asp



Discussion

No Comment Found