Access Database Access within code

11 Apr 2006 8:43 PM

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

11 Apr 2006 9:14 PM

Jeff Dillon

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

Jeff
Show quoteHide quote

"Stephen E. Weber" <s*@webersystems.com> wrote in message
news:uBMkZiaXGHA.2376@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
>
>

12 Apr 2006 2:59 PM

Stephen E. Weber

thanks, I musta been napping!

all set now

steve

Show quoteHide quote

"Jeff Dillon" <jeffdil***@hotmail.com> wrote in message
news:%23N1DnzaXGHA.4248@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" <s*@webersystems.com> wrote in message
> news:uBMkZiaXGHA.2376@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
>>
>>
>
>