Consulting

Page 2 of 6 FirstFirst 1 2 3 4 ... LastLast
Results 21 to 40 of 108

Thread: Concept only required

  1. #21
    Hi Ted

    The code is almost OK, but page indices start with zero, so to display Page1 you need to set Multipage.Value to zero. Decrease the values by one E.g.
    [vba]Private Sub btngenPrevious_Click()
    'instad of Employeeinduction.MultiPage1.Value = 1
    Employeeinduction.MultiPage1.Value = 0
    End Sub[/vba] (I made all necessary changes and attached the modified workbook.)

    Also, you may want to consider a pair of buttons off the multipage that would take care of all page turnings. This, too, is included in the modified workbook.

    Regards,

    Jimmy
    Last edited by JimmyTheHand; 03-23-2007 at 04:59 AM.
    -------------------------------------------------
    The more details you give, the easier it is to understand your question. Don't save the effort, tell us twice rather than not at all. The amount of info you give strongly influences the quality of answer, and also how fast you get it.

  2. #22
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,446
    Location
    Ted,

    When you have Next/Previous buttons like this, they really should be off page and applicable across the board.

    Like this

  3. #23
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,232
    Location
    Well that's a bit dissappointing..... I wasn't even close.

    Thanks Bob, I should have re read your previous post in the light of day when the brain is not so muddled.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  4. #24
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,232
    Location
    Jimmy, what you have offered is great except..... In this thread, could you only supply either a direction for me to take or an example line of code. I need to learn to code rather than borrow a working section.

    I do apprecieate your help, but I need to do the hard yards by myself where ever possible, even if it means I'm going round in circles for a few hours. (its what us bears do best)
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  5. #25
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,232
    Location
    Righto, next question. If I want to add the values of some textboxes, is it just a case of;

    Textbox5.Text = Textbox1.value+Textbox2.Value+Textbox3.Value+Textbox4.Value
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  6. #26
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,297
    Location
    Ted, if you need to go down the Access route then I will gladly help you put it together, or put it together for you.

  7. #27
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,232
    Location
    uhoh...someone mentioned the "A" word.....
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  8. #28
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,446
    Location
    Quote Originally Posted by Aussiebear
    uhoh...someone mentioned the "A" word.....
    Ignore him Ted, I think he is lost (spiritually and group)

  9. #29
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,446
    Location
    Quote Originally Posted by Aussiebear
    Righto, next question. If I want to add the values of some textboxes, is it just a case of;

    Textbox5.Text = Textbox1.value+Textbox2.Value+Textbox3.Value+Textbox4.Value
    Best to cast it

    [vba]

    Textbox5.Text = CDbl(Textbox1.value) + _
    CDbl(Textbox2.Value) + _
    CDbl(Textbox3.Value) + _
    CDbl(Textbox4.Value)
    [/vba]

  10. #30
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,232
    Location
    "cdble" is a form of declaring the variant as a double?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  11. #31
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,446
    Location
    Quote Originally Posted by Aussiebear
    "cdble" is a form of declaring the variant as a double?
    No, CDbl casts a value to a double, required as a textbox is a string.

  12. #32
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,232
    Location
    If I write it as;
    [VBA]
    Private Sub txtgenpoints_Click()
    Txtgenpoints= CDbl(txtethics.Value) + CDbl(txtreliability.Value) + CDbl(txtcommunication.Value) + CDbl(txtohs.Value)
    End Sub
    [/VBA]

    Nothing happens when the focus is shifted to textbox called txtgenpoints. If you change textboxes by using the TAB key is this the same as using the mouse and actually creating a click event?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  13. #33
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,446
    Location
    Quote Originally Posted by Aussiebear
    If I write it as;
    [vba]
    Private Sub txtgenpoints_Click()
    Txtgenpoints= CDbl(txtethics.Value) + CDbl(txtreliability.Value) + CDbl(txtcommunication.Value) + CDbl(txtohs.Value)
    End Sub
    [/vba]
    Nothing happens when the focus is shifted to textbox called txtgenpoints. If you change textboxes by using the TAB key is this the same as using the mouse and actually creating a click event?
    I would use the Change event.

    Tab will trigger the Enter event, not Click.

  14. #34
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,232
    Location
    I see my mistake. Someone take me outside and flog me with a heavy limb.


    10 minutes later.... I no longer see my mistake and its still not working.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  15. #35
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,446
    Location
    Quote Originally Posted by Aussiebear
    I see my mistake. Someone take me outside and flog me with a heavy limb.
    Sorry that is not included in the tuition fees, you will have to pay extra for such services.

  16. #36
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,232
    Location
    Might be cheaper if I just take up drniking full time...
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  17. #37
    VBAX Contributor moa's Avatar
    Joined
    Nov 2006
    Posts
    177
    Location
    Could just use the Enter event.
    Glen

  18. #38
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,232
    Location
    We have a winner.... (be back in 5)
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  19. #39
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,232
    Location
    Okay can I add the total points values from each page of the multipage in the same format as you do for each individual page or do you need to identify each page?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  20. #40
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,478
    Location
    Hi Ted,
    Can you post your book? Guidance offered only - no solutions!
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

Posting Permissions

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