Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Orientation of A Continuous Form (Access 2002 SP3)

    Here is something I've never thought of trying before.
    Changing the order of display of continuous forms to something like the following:
    Has anyone tried this or have suggestions?

    Regards
    Catharine
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Orientation of A Continuous Form (Access 2002 SP3)

    I'm not sure what you're talking about, Catharine. Do forms A, B, etc. represent subforms or records? If they represent records, then Hans's answer has already covered it. If they represent subforms, I'm still confused about what you are trying to indicate.
    Charlotte

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Orientation of A Continuous Form (Access 2002 SP3)

    No, they represent records. Could you repeat a subform like that? And have it view separate (sequential) records?

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: Orientation of A Continuous Form (Access 2002 SP3)

    You can do this in reports (select "Across, then Down" in the Columns tab of File | Page Setup), but not in forms.

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

    Re: Orientation of A Continuous Form (Access 2002 SP3)

    As far as I know, you can only do that in a report, not in a form.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Orientation of A Continuous Form (Access 2002 SP3)

    What are you trying to accomplish, Catharine? Forms don't really go by "pages" and columnar layout is for reports. You couldn't repeat a subform, although you can have multiple subforms, but it would be a horrible mess to maintain and I see no purpose in it.
    Charlotte

  7. #7
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Orientation of A Continuous Form (Access 2002 SP3)

    Well I'm trying to set up a transfer of "widgets" between outstanding orders. If I subtract the widgets from one order I want to be able to add them to an existing order that also uses the same type of widget.
    I was visualizing something like this, but I suspect I'm trying to tie this too tightly to a paper based system.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: Orientation of A Continuous Form (Access 2002 SP3)

    But such order records need not necessarily be consecutive, do they? You could use side-by-side subforms in single form view, but trying to do this with continuous subforms would be very difficult to maintain, as Charlotte indicated.

  9. #9
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Orientation of A Continuous Form (Access 2002 SP3)

    No, not consecutive.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: Orientation of A Continuous Form (Access 2002 SP3)

    A continuous subform wouldn't be suitable, then, even if it were possible to create one with the layout you described. You could place two subforms in single form view next to each other, and use code (behind a command button for example) to transfer widgets from one to the other.

  11. #11
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Orientation of A Continuous Form (Access 2002 SP3)

    Do you have to see the whole order? If not, a pick list might be useful. You can find links to several different demos in the thread that starts with <post#=434432>post 434432</post#>.
    Charlotte

  12. #12
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Orientation of A Continuous Form (Access 2002 SP3)

    But even with side by side subforms another wrinkle pops up. (Oh yeah, something else I didn't tell you).
    I am creating records - not searching for information.
    You can't (or I can't) use the subforms to add two new records on the same form.

    Was that clear?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: Orientation of A Continuous Form (Access 2002 SP3)

    I can add records in two subforms bound to the same form, but each subform won't "see" new records created in the other one until it's requeried. But I'm confused now, I thought you wanted to transfer widgets from one record to another; I don't see why you would want to create new records and then transfer widgets between them.

  14. #14
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Orientation of A Continuous Form (Access 2002 SP3)

    I don't want to amend the current records, but create a new records showing the stock movements....
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: Orientation of A Continuous Form (Access 2002 SP3)

    I'm sorry, you've lost me.

Page 1 of 2 12 LastLast

Posting Permissions

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