Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Input box, Customize (Access 2000)

    Can you customize the form button or positioning on a input box? If not, how can you get the code to break while the focus goes to another form (which would act as an input button).?

    Thanks

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

    Re: Input box, Customize (Access 2000)

    I'm sorry; I don't understand. It's too hot here today, so I'm sure it's me, but could you try to explain what you want more clearly?

    What is a form button? And what is an input button?

  3. #3
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Input box, Customize (Access 2000)

    The function inputbox (you know, the one like msgbox, (but you can enter one value) I was wondering if you can customize the two default buttons that come with the function (OK and Cancel) in terms of visibility and position. If you can't, I would make a form that would popup like an inputbox. The only thing is when I call that popup form, and set the focus on it, I would like to stop the execution of the code on the page that I was just at, until the user enters a value in the popup form and the focus returns to the main form [img]/forums/images/smilies/smile.gif[/img] I am not sure how to halt my code.

    Thanks

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

    Re: Input box, Customize (Access 2000)

    <P ID="edit" class=small>(Edited by charlotte on 19-Jul-03 08:42. Additional information was posted while this post was being composed.)</P>If you are talking about the dialog that pops up with you use something like this:

    varParamValue = InputBox(prompt[, title] [, default] [, xpos] [, ypos] [, helpfile, context])

    There are optional arguments for the X and Y position of the input box relative to the upper left corner of the screen, measured in twips. You cannot do anything about the buttons.
    Charlotte

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

    Re: Input box, Customize (Access 2000)

    Charlotte has already posted a reply about InputBox.

    If you design a custom input form, call it with a WindowMode argument (the sixth argument) acDialog. This will pause the calling code until the user has closed the custom input form. Example:

    DoCmd.OpenForm FormName:="frmMyInputForm", WindowMode:=acDialog

    or

    DoCmd.OpenForm "frmMyInputForm", , , , , acDialog

  6. #6
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Input box, Customize (Access 2000)

    Awesome, the acDialog was what I was looking for [img]/forums/images/smilies/smile.gif[/img]

    Thanks

Posting Permissions

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