Alpha Video Training
Results 1 to 8 of 8

Thread: Layout design format

  1. #1
    Member
    Real Name
    Stephen Sammon
    Join Date
    May 2008
    Posts
    11

    Default Layout design format

    I want to design a form & report to include multiple test questions from one of my tables. The form is set up like a test. All test questions are aligned on the left corresponded by their answer fields on the right.
    In order to accommodate all test questions, this would include approx. 20 print pages. How can I accomplish this task when the vertical layout on the form / reports extends to a maximum of 23” (2-3pages)?
    Any help on this matter would be appreciated.

    Steve

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Layout design format

    Sounds like you need a tabbed object on the form for the questions and answers. Not sure what your issue is with the report.

  3. #3
    Member
    Real Name
    Stephen Sammon
    Join Date
    May 2008
    Posts
    11

    Default Re: Layout design format

    When I am in the report form in the design mode, I can only scroll down 23," I do not have enough space to put all of the drag-drop answer fields in the detail section.

  4. #4
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    5,986

    Default Re: Layout design format

    Reports: How many questions do you have? It would not normally take 1" per question? how much space do you need per question. Do you intend to print a 23" long sheet of paper?

    Alternately: Could you print on the reports following each other and make the reports shorter? In other words, if you have 90 questions, could you put 30 on each report?

    You can set a report up to use a columns where there would be questions and answers on the left and also on the right.

    Forms: Stan gave you the clue with tabs and alternately, you could use conditional objects.

    Will await the questions of how many and how big???

    .
    Dave Mason
    dave@aldaweb.com

    Skype is dave.mason46

  5. #5
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Layout design format

    You may have to rethink your table design. Instead of one record with hundreds of fields you might have to use multiple records with only a few fields.


    Id-Question-Answer

    and link the id back to a parent table in a set.

    The report on this set would allow each record to be a detail line in a report and the detail section would continue as long as you wish.

    On a form the Id-Question-Answer table would display in a browse on a form based on the set.

  6. #6
    Member
    Real Name
    Stephen Sammon
    Join Date
    May 2008
    Posts
    11

    Default Re: Layout design format

    I have about 200 questions in this report. I have a header & footer included to print with each page. I am new to Alpha Five and having trouble figuring out how to set this up to work. I thought it would be simple, simply type each question on the report/form and drag the appropriate fields on the detail section of the report until all of the questions were completed.
    I must be looking at this setup the wrong way.

    Steve

  7. #7
    Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,625

    Default Re: Layout design format

    Quote Originally Posted by sammyss View Post
    I have about 200 questions in this report
    ....
    I must be looking at this setup the wrong way.
    Yup.

    Stan gave you the answer. Make each question be a record. You're trying to do it the analog way - not really appropriate for a db.

  8. #8
    Member
    Real Name
    Stephen Sammon
    Join Date
    May 2008
    Posts
    11

    Default Re: Layout design format

    Thank you all for your help, I will look into your suggestions and
    attempt to implement them properly

    Steve

Similar Threads

  1. Design and layout
    By lkatz1 in forum Alpha Five Version 5
    Replies: 2
    Last Post: 06-12-2007, 04:31 PM
  2. Database design - Form Design
    By Larpup in forum Alpha Five Version 8
    Replies: 2
    Last Post: 06-11-2007, 11:45 AM
  3. Layout
    By Bill@TrackerSystems.com in forum Alpha Five Version 5
    Replies: 2
    Last Post: 04-10-2004, 07:09 AM
  4. layout not open in design mode
    By urbanski in forum Alpha Five Version 5
    Replies: 1
    Last Post: 12-24-2003, 01:10 PM
  5. Form Design layout, can it re-open as was saved?
    By BDennis in forum Alpha Five Version 4
    Replies: 12
    Last Post: 03-30-2002, 09:00 AM

Bookmarks

Posting Permissions

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