Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Insert graphic in a cell - Want to use as DB (2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> hobkirk

    OK you can not store a graphic file into a cell. You can place the graphic on the worksheet, but that is different.

    I suggest you use MS-Access 2000 with its memo or OLE Object field to store these items. Make a nice Userform Interface to please your "very non-PC-technical" user and ease maintenance .

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Boston suburb (Acton), Massachusetts, USA
    Posts
    109
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Insert graphic in a cell - Want to use as DB (2000)

    Thank you!

    It really did seem that I should be able to figure it out or find out via help & books if it was possible. But it really seemed that it "should" be possible.

    Oh well... I'm off to see the wizard, the wonderful wizard of Access...

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Boston suburb (Acton), Massachusetts, USA
    Posts
    109
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Insert graphic in cell - use as DB (can't be done)

    When I insert a graphic into a cell in Excel, it appears to be using the cell as an anchor and the picture covers cells to the right and below. When I do the same in other applications (Word, WYSIWYG web programs, etc.) they expand the table cell to accomodate a graphic when I move it in.

    I am trying to create a simple DB for a web site. Each "record" representing one item for sale will have a fixed number of text and JPEG's in the cells of one row. In an ideal world I would have the option of having the JPEG's be visible or not - several of them are 640 wide so my 21" screen gets too small very quickly!

    I have Fox Pro Visual and Access 2000 although I am essentially a virgin to both. I am willing to learn either. But I think Excel might be better in this case because this DB will be maintained by someone who is very non-PC-technical but feels comfortable with Excel. The DB will have one to three records replaced and maybe a couple of "fields" updated each week - in other words, it's not a high-maintenance isue.

    PS - I LOVE this forum because the quality of responders.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •