Results 1 to 15 of 15
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Best method (2003)

    I'm creating a form, <post#=576,049>post 576,049</post#> and would like some extra advice on the best way to approach it. I have sorted all the fields out (whether they need to expand or not), and created a couple of subforms which are needed. I'm using an image of each page of the original document as a template to get the control sizes as near as possible. The problem is, when I've finished it will be one long continuous form. I tried using tabs, but when I sent the image to the back, instead of sending it to the back of the controls of the form, it sent it to back of the tab controls (which I suppose it would). If anyone could suggest a better method of creating this form, I would be greatful.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Best method (2003)

    As I noted in <post:=576,199>post 576,199</post:>, tab controls are not suitable for printing. Only the active tab page will be printed.

    And I repeat that you should create a report, not a form.

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Best method (2003)

    The end result will be a report, not a printed form. The form is to collect the information. The report will be six pages similar to the image I posted. I just don't know the best way to approach the form. The report will be another problem, being six different pages with a similar layout to the form.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Best method (2003)

    Management may not like it, but I would not attempt to make the data entry form look exactly like the paper form. If people need to enter data from the paper form into the Access form, you should keep the order of the items the same, but there is no point in duplicating the entire design.

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Best method (2003)

    Tried with one long form but reached the end. Have to look at another method.

  6. #6
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Best method (2003)

    Okay, the long continuous form didn't work, so I'm trying tabs. I created a new form with tab control. I cut and pasted some controls from the long form and pasted them onto page 1 of the tab. I cut and pasted more controls from the long form and pasted them onto page 2. Unfortunately these controls appear on both pages. Is this method wrong? Both forms are based on the same table.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Best method (2003)

    Make sure that you click the tab of the page you want to paste on; this should make little black squares appear round the border of the tab page. You will then paste into that page. If you don't see the black squares, you will not paste into the tab page, so the controls will be visible on all pages.

  8. #8
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Best method (2003)

    I've got the forms and reports sorted how we want them. What I'm not sure how to do it, insert the reports as sub-reports, and force a new page, etc. I have 6 reports, which I want to turn into a 5 or 6 page document. I've inserted the second document into the main document, but only part of it is being displayed.
    So basically, if there is enough room for the subreport, it prints out, if not forces a new page. Hope this all makes sense.

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Best method (2003)

    Could you try again? I don't understand what your problem is and what you're asking.

  10. #10
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Best method (2003)

    Sorry, I rubbish at explaining. I have 6 seperate 1 page reports, all tied to the same query. What my boss wants is.... if page 1 is half empty (using can grow/shrink controls), the report no 2 will be added to the space thats left,with the remainder going on to page 2....and so on and so on, until all one page reports are merged. Hope this is a little clearer. I'm only trying to achieve what's been requested.

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Best method (2003)

    If you want each subreport to be kept on one page:
    Put each of the subreports in a separate section, for example a group header or footer for a dummy group (based on an expression such as =1), and set the Keep Together property of the section to Yes.

  12. #12
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Best method (2003)

    For the time being, I'm keeping the pages so they follow on from each other, but I have made another copy using your advice. The structure of the whole thing doesn't seem right, although it seems to work. If you could take a look at it for me, it would be greatly appreciated. I realise this thread is getting long, but appreciate your time and patience.

  13. #13
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Best method (2003)

    Which report should I look at, and what is wrong with it as it is now?

  14. #14
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Best method (2003)

    Report STS_Main. It brings all the others in, but asks for the log No several times. I think its because of the way I have the queries set up.

  15. #15
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Best method (2003)

    The main report is based on STS_Main Query; this has a parameter [Log No ]
    Two of the subreports (rptFinishing and rptFoundry are also based on this query, so they ask for the parameter too.
    Try the following:
    - Open STS_Main Query in design view.
    - Remove the parameter [Log No ]
    - Use File | Save As to save the query under another name, say as STS_Main Query2.
    - Set the Record Source property of rptFinsihing and rptFoundry to STS_Main Query2.
    Since the subreports are linked to the main report on Log No, this shouldn't be a problem.

Posting Permissions

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