Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Use Access for this?

Discussion in 'Information Technology' started by Stilla, Jul 28, 2006.

Tags:
  1. Stilla

    Stilla
    Expand Collapse
    Guest

    Hi.. I'm new Access learner... I have an opportunity to possibibly use
    Access, and this would make my learning more "real" - but I'm not sure if I'm
    thinking straight..here's what I'd like to do in a nutshell, and the doubts
    I'm having.

    Set up a "form" in Access where I can enter Interview notes relating to
    specific topic areas asked about during an interview. THEN, I'd like to set
    up a rating scheme so that those answers can be reviewed and rated on some
    criteria. Those ratings would then be stored in a table that is downloadable
    for analysis in Excel.

    Doubt#1: As I reviewed the basics, it seems that there is a limit of 225 or
    so characters for Text Boxes. Interview notes may run longer than that.
    Doubt #2: I'd like to have a top part of the form with name, company,
    date..etc. , - but can this info be displayed on a different "page" of the
    record??
    Doubt #3: Printing...if I want to print out all the info on one person
    (contact info, actual interview notes, and ratings) could this then be
    printed in one piece?

    Any insights would be greatly appreciated!

    Stilla
     
  2. Loading...


  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "Stilla" <Stilla@discussions.microsoft.com> wrote

    > Doubt#1: As I reviewed the basics, it seems
    > that there is a limit of 225 or so characters for
    > Text Boxes. Interview notes may run longer than that.


    Text Fields in a Table are limited to 255 characters; Text Boxes are not.
    Text Boxes can have a Memo Field as their Control Source, "which has a limit
    of 65,535 when entering data through the user interface; but can contain 1
    gigabyte of character storage when entering data programmatically",
    according to Access 2003 Help.

    > Doubt #2: I'd like to have a top part of the
    > form with name, company, date..etc. , - but
    > can this info be displayed on a different "page"
    > of the record??


    I'm sorry that I don't know what you mean by "displayed on a different
    'page' of the record".

    You can have a main Form with such information, and place on this a Subform
    Control which has a Form embedded to contain the detail (e.g., your notes).
    You can synchronize the related details by specifying the LinkMasterFields
    (in Record Source of the main Form) and LinkChildFields (in the Record
    Source of the Form embedded in the Subform Control).

    You could also use a Query joining the related Tables as Record Source for a
    single Form.

    > Doubt #3: Printing...if I want to print out all the info on one person
    > (contact info, actual interview notes, and ratings) could this then be
    > printed in one piece?


    Of course, you can join the various Tables in a Query and use the Report's
    Sorting and Grouping Properties to determine the hierarchy of display. Or,
    you could use a Subreport Control on the main Report, as described above for
    Form/Subform.

    Larry Linson
    Microsoft Access MVP
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Stilla wrote:
    > Hi.. I'm new Access learner... I have an opportunity to possibibly use
    > Access, and this would make my learning more "real" - but I'm not
    > sure if I'm thinking straight..here's what I'd like to do in a
    > nutshell, and the doubts I'm having.
    >
    > Set up a "form" in Access where I can enter Interview notes relating
    > to specific topic areas asked about during an interview. THEN, I'd
    > like to set up a rating scheme so that those answers can be reviewed
    > and rated on some criteria. Those ratings would then be stored in a
    > table that is downloadable for analysis in Excel.
    >
    > Doubt#1: As I reviewed the basics, it seems that there is a limit of
    > 225 or so characters for Text Boxes. Interview notes may run longer
    > than that.


    Use a memo filed. I doubt if you can write enough to fill that.

    > Doubt #2: I'd like to have a top part of the form with
    > name, company, date..etc. , - but can this info be displayed on a
    > different "page" of the record??


    I am not sure want you mean by a different page and what information you
    are talking about, but I strongly suspect that the answer is yes.

    > Doubt #3: Printing...if I want to print out all the info on one person
    > (contact info, actual interview notes, and ratings) could this then be
    > printed in one piece?


    No problem. I would suggest using a report.

    >
    > Any insights would be greatly appreciated!
    >
    > Stilla


    --
    Joseph Meehan

    Dia duit
     
  5. betwalk@gmail.com

    betwalk@gmail.com
    Expand Collapse
    Guest

    Stilla wrote:
    {snip}
    > Doubt #2: I'd like to have a top part of the form with name, company,
    > date..etc. , - but can this info be displayed on a different "page" of the
    > record??

    {snip more}

    I'll hazard a guess here and tell you that what you need could be
    satisfied with a form header. That way if you have a form that needs
    to be scrolled, the name of the person will reliably stay visible at
    the top. Or, if you use tab control pages, you can place the name of
    the person/company on the form above the tab control object so that the
    info remains always visible.
     
  6. Stilla

    Stilla
    Expand Collapse
    Guest

    BOY!! GEE!! Thanks for all the responses you guys!!! I feel smarter already!
    Maybe I'll try to tackle this after all!!

    "Stilla" wrote:

    > Hi.. I'm new Access learner... I have an opportunity to possibibly use
    > Access, and this would make my learning more "real" - but I'm not sure if I'm
    > thinking straight..here's what I'd like to do in a nutshell, and the doubts
    > I'm having.
    >
    > Set up a "form" in Access where I can enter Interview notes relating to
    > specific topic areas asked about during an interview. THEN, I'd like to set
    > up a rating scheme so that those answers can be reviewed and rated on some
    > criteria. Those ratings would then be stored in a table that is downloadable
    > for analysis in Excel.
    >
    > Doubt#1: As I reviewed the basics, it seems that there is a limit of 225 or
    > so characters for Text Boxes. Interview notes may run longer than that.
    > Doubt #2: I'd like to have a top part of the form with name, company,
    > date..etc. , - but can this info be displayed on a different "page" of the
    > record??
    > Doubt #3: Printing...if I want to print out all the info on one person
    > (contact info, actual interview notes, and ratings) could this then be
    > printed in one piece?
    >
    > Any insights would be greatly appreciated!
    >
    > Stilla
     
  7. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    Stilla <Stilla@discussions.microsoft.com> wrote:

    >Doubt #2: I'd like to have a top part of the form with name, company,
    >date..etc. , - but can this info be displayed on a different "page" of the
    >record??


    Are you thinking of a tabbed interface?

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page