Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Location
    Dallas, Texas, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    RANGE OF CELLS (Access 97)

    How do I put a range of cells into a form? I have small tables (most are 5 by 5 cells) I would like to incorporate into form pages but I am having trouble making a subform without losing my formatting in sm tables. I have considered hyperlinks. Sm tables were created in excel 97 and each table (in its own worksheet) has a cell that is identical with main table in Access. Ideas, thoughts?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: RANGE OF CELLS (Access 97)

    Working with Excel data, Access still treats the data as a record, and that means that you get one row at a time. In order to present multiple rows you would need to use continuous forms, which display data in a tabular format. In Excel you can create relationships between cells in different rows, but Access does support that kind of relationship (except in the case of self-joins, which is a very special case). Hope this makes sense to you - the transition between Excel and Access can be kind of daunting.
    Wendell

Posting Permissions

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