Page 1 of 2 12 LastLast
Results 1 to 15 of 26
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tabbed vs MultiPage (Access 2003)

    I
    Cheers,
    Andy

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

    Re: Tabbed vs MultiPage (Access 2003)

    What is the objection to using the Tab key?

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

    Re: Tabbed vs MultiPage (Access 2003)

    If, as I suspect, it is not acceptable to use Tab instead of Page Down, you can try this:

    1) Set the Key Preview property of the form to Yes. This means that all keystrokes will be passed to the form's event handlers before being passed to the active control's event handlers.

    2) Create the following event procedure for the On Key Down event of the form:

    Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    Select Case KeyCode
    ' Did the user press Page Down?
    Case vbKeyPageDown
    ' Adjust the treshold value as needed
    If Me.ActiveControl.Top > 10000 Then
    ' Change PageDown to Tab
    KeyCode = vbKeyTab
    End If
    End Select
    End Sub

    You will have to find a suitable value for the treshold (10000 in the code above) either by inspecting the value of the Top property of the last page break and converting it to twips (1 inch = 1440 twips) or by trial and error.

  4. #4
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tabbed vs MultiPage (Access 2003)

    Hans,

    It's not every day I get to measure something with a twip. The possibilities are endless. Pun intended.

    Seriously, thank you again for your near instantaneous help. Apparently sitting at my computer when we have guests for dinner is not considered to be the social thing to do. Especially if I want to wake up tomorrow morning. Which, by the way, will be the first chance I get to try this out.

    Thanks again,
    Cheers,
    Andy

  5. #5
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Tabbed vs MultiPage (Access 2003)

    I use Tabbed pages a lot, and avoid this problem by not using Windows themed controls , and usually using Attached labels with text boxes.

    What is your objection to attached labels?

    If your objection only relates to the form building process, you could build the form with unattached lables, then when you have finished attach the labels to get rid of the flicker.

    To attach an unattached label: select label, Cut, select textbox, Paste. It will now be atached.
    Regards
    John



  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Tabbed vs MultiPage (Access 2003)

    I once had to create a long form with 6 pages. I could only fit 5 downwards before I reached the maximum form length so page 6 had to be next to page 1 but offset to the right by a bit more than a screen width.

    To navigate around I had 6 command buttons. Each had a number on it to say what page it went to , and a keyboard shortcut set so that Alt & Number took you to that page.

    For pages 1 to 5 the event was just Me.GoToPage 4 etc

    For Page 6 it was Me.GoToPage 1, offset where offset was a constant that specified how many twips wide the screen was. The effect of this was to go back to page 1, then scroll to the right by a screen width.
    Regards
    John



  7. #7
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tabbed vs MultiPage (Access 2003)

    Hans,

    Good Monday Morning to you!

    Your suggestion worked "right out of the box" with no adjustments needed. And here I was all excited about getting to play with my twips.

    Thanks again,
    Cheers,
    Andy

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

    Re: Tabbed vs MultiPage (Access 2003)

    You could give the twips to your grandchildren... <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

  9. #9
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tabbed vs MultiPage (Access 2003)

    John, thanks for responding. I have no real objections to using attached labels other than the fact it was easier to just throw on and manipulate a text box. Needless to say with the
    Cheers,
    Andy

  10. #10
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Tabbed vs MultiPage (Access 2003)

    But when you just "throw on a text box", don't you get an attached label automatically? I always do.

    Do you know that if you click any tool in the toolbox, then look at the properties box, you are looking at the properties of any new control of that type.
    Amongst the many format properties of a the default text box is one "auto label", which controls whether a label is created.

    I don't like colons after labels, and for years I used to take them out, then I found out how to stop them being put there is the first place.
    Regards
    John



  11. #11
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tabbed vs MultiPage (Access 2003)

    We had a problem with having multiple tabbed pages from several queries loading slowly so we changed the entire form to use a series of command buttons that were arranged to look like tabs and when you clicked the command buttons it would just change the subform it was showing. This eliminated the problem of the form loading slowly and made a very neat single page form. Probably too much work for you to change now but I found the technique worked very well

    Carla

  12. #12
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tabbed vs MultiPage (Access 2003)

    Hans,

    I may have heard them calling me a Twip on occasion, but not sure.

    Anyway, back at the multi-page form.

    As I mentioned in my previous post to you, your code worked on my screen perfectly
    Cheers,
    Andy

  13. #13
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tabbed vs MultiPage (Access 2003)

    Hi Carla,

    Thanks for jumping in to help. I totally agree with your approach with respect to the buttons and the subforms. The trick right now is to attempt both yours and John
    Cheers,
    Andy

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

    Re: Tabbed vs MultiPage (Access 2003)

    I can't explain that. However, it won't take very long to determine a value that works.

  15. #15
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Tabbed vs MultiPage (Access 2003)

    >>>I don't like colons after labels, and for years I used to take them out, then I found out how to stop them being put there is the first place.<<<

    How do you do that?

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
  •