Search results

  1. J

    Resizing a form based on screen resolution

    Thanks for the replies! I just saw indeed that its not for VBA.I found the code here: http://www.dreamincode.net/forums/index.php?showtopic=34776 Does anyone know how to do this in VBA ?
  2. J

    Scroll bar with scroll wheel on mouse

    Thanks for your replies! I found the code here: http://www.dreamincode.net/forums/index.php?showtopic=34776 I just saw indeed that its not for VBA.Does anyone know how to do this is VBA ?
  3. J

    Resizing a form based on screen resolution

    My form is called "insertionform". I changed the name and I keep getting the following message: [invalid inside procedure] on this code: Private Type Control Index As Integer Name As String Left As Integer Top As Integer width As Integer height As Integer End Type...
  4. J

    Scroll bar with scroll wheel on mouse

    My form has a scroll bar and I would like it to respond and scroll down (or up) when I use the mouse scroll wheel. I'm sure this is probably easy but I just started using VBA. Does anyone have any suggestions ? Thank you!
  5. J

    Resizing a form based on screen resolution

    I have a form that is pretty long (700) and I want it to re-size depending on the user's screen. I have found this code online but I don't think I'm using it right since it is not working for me. if someone has an easier way to do this or has any suggestions please share it. THANKSSS...
  6. J

    Disable a checkbox after a certain date

    Thank you!! I tried this code and it's working. If The_Date.Value > #3/17/2010# Then Early_Bird_Discount.Value = False And Early_Bird_Discount.Enabled = False MsgBox "Sorry, this promotion has expired. " End If One thing though; you have to click twice on "OK" when the msgbox appears to...
  7. J

    Disable a checkbox after a certain date

    Hi, I have a userform with which clients can order stuff. There is a discount that applies for people who order before the deadline (04/13/2010). The discount is named Early Bird Discount and there is a check box that users can click to receive the discount. But I want the check box to get...
Back
Top Bottom