Access Database Access within code

[Stephen E. Weber]

I have an access database with an "item number" and a filespec for a JPG
with the image for the item and a filespec for a HTM document with the
description and specifications. I use a List Box and defined a DataSource
Link with postback to reference the access database, all works ok for
browsing the access file.

Now after the user selects the item in the list box I want to display the
image and htm document on the screen. I can set the ImageURL property of the
Image control to point to the image, but how can I access the data in the
list box or access file to determine the filespec of the image to display?
The List box has the correct file record, but only displays the item number
and not the filespec, although the access file has this info, this is by
design, so I think im gonna have to do some sort of lookup on the database
table, although I am not sure.

For the second part, is there a control where I can open and display the
contents of a HTM file to the screen, in a docked window, or just on the
screen, I dont want a floating window.

Thanks
Steve

[Jeff Dillon]

You can put a complete class object in the listbox too you know, not just
the file record id.

Jeff
"Stephen E. Weber" <[e-mail]> wrote in message
news:uB**************@TK2MSFTNGP03.phx.gbl...

I have an access database with an "item number" and a filespec for a JPG
with the image for the item and a filespec for a HTM document with the
description and specifications. I use a List Box and defined a DataSource
Link with postback to reference the access database, all works ok for
browsing the access file.

Now after the user selects the item in the list box I want to display the
image and htm document on the screen. I can set the ImageURL property of
the Image control to point to the image, but how can I access the data in
the list box or access file to determine the filespec of the image to
display? The List box has the correct file record, but only displays the
item number and not the filespec, although the access file has this info,
this is by design, so I think im gonna have to do some sort of lookup on
the database table, although I am not sure.

For the second part, is there a control where I can open and display the
contents of a HTM file to the screen, in a docked window, or just on the
screen, I dont want a floating window.

Thanks
Steve

[Stephen E. Weber]

thanks, I musta been napping!

all set now

steve


"Jeff Dillon" <je********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...

You can put a complete class object in the listbox too you know, not just
the file record id.

Jeff
"Stephen E. Weber" <[e-mail]> wrote in message
news:uB**************@TK2MSFTNGP03.phx.gbl...

I have an access database with an "item number" and a filespec for a JPG
with the image for the item and a filespec for a HTM document with the
description and specifications. I use a List Box and defined a DataSource
Link with postback to reference the access database, all works ok for
browsing the access file.

Now after the user selects the item in the list box I want to display the
image and htm document on the screen. I can set the ImageURL property of
the Image control to point to the image, but how can I access the data in
the list box or access file to determine the filespec of the image to
display? The List box has the correct file record, but only displays the
item number and not the filespec, although the access file has this info,
this is by design, so I think im gonna have to do some sort of lookup on
the database table, although I am not sure.

For the second part, is there a control where I can open and display the
contents of a HTM file to the screen, in a docked window, or just on the
screen, I dont want a floating window.

Thanks
Steve