Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    SorenIX's Avatar
    SorenIX is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2011
    Posts
    15
    I thought this could be interesting :



    Code:
    Private Sub Command4_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Me.Command4.Width = 7 * 567
    End Sub
    
    Private Sub Form_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Me.Command4.Width = 3 * 567
    End Sub
    It works, but not correctly.

    EDIT :

    This one is really glitchy but it does what I want it to do :

    Code:
    Private Sub Command4_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Me.Command4.Width = 7.1 * 567
    Me.Command5.Width = 6.52 * 567
    Me.Command6.Width = 6.52 * 567
    Me.Options.Width = 6.52 * 567
    End Sub
    
    Private Sub Command5_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Me.Command4.Width = 6.52 * 567
    Me.Command5.Width = 7.1 * 567
    Me.Command6.Width = 6.52 * 567
    Me.Options.Width = 6.52 * 567
    End Sub
    
    Private Sub Command6_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Me.Command4.Width = 6.52 * 567
    Me.Command5.Width = 6.52 * 567
    Me.Command6.Width = 7.1 * 567
    Me.Options.Width = 6.52 * 567
    End Sub
    
    Private Sub Options_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Me.Command4.Width = 6.52 * 567
    Me.Command5.Width = 6.52 * 567
    Me.Command6.Width = 6.52 * 567
    Me.Options.Width = 7.1 * 567
    End Sub
    
    Private Sub OLEUnbound13_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Me.Command4.Width = 6.52 * 567
    Me.Command5.Width = 6.52 * 567
    Me.Command6.Width = 6.52 * 567
    Me.Options.Width = 6.52 * 567
    End Sub
    I will upload the form.

  2. #17
    SorenIX's Avatar
    SorenIX is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2011
    Posts
    15
    I solved the MouseMove Event problem!

    Code:
    Private Sub Command4_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    If Me.Command4.Width < 7.1 * 567 Then
       Me.Command4.Width = 7.1 * 567
    End If
    End Sub
    
    Private Sub Command5_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    If Me.Command5.Width < 7.1 * 567 Then
       Me.Command5.Width = 7.1 * 567
    End If
    End Sub
    
    Private Sub Command6_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    If Me.Command6.Width < 7.1 * 567 Then
       Me.Command6.Width = 7.1 * 567
    End If
    End Sub
    
    Private Sub Options_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    If Me.Options.Width < 7.1 * 567 Then
       Me.Options.Width = 7.1 * 567
    End If
    End Sub
    
    Private Sub MenuBackground_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    If Me.Command4.Width > 7.1 * 567 Then
       Me.Command4.Width = 6.52 * 567
    End If
    If Me.Command5.Width > 7.1 * 567 Then
       Me.Command5.Width = 6.52 * 567
    End If
    If Me.Command6.Width > 7.1 * 567 Then
       Me.Command6.Width = 6.52 * 567
    End If
    If Me.Options.Width > 7.1 * 567 Then
       Me.Options.Width = 6.52 * 567
    End If
    End Sub
    Hope it will be useful for someone else!

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 02-20-2011, 08:22 PM
  2. export query to fixed width text
    By eladz949 in forum Import/Export Data
    Replies: 1
    Last Post: 02-08-2011, 07:28 AM
  3. export query to fixed width text
    By eladz949 in forum Import/Export Data
    Replies: 5
    Last Post: 01-01-2011, 03:28 PM
  4. Bring in numeric text field to access from excel
    By Sck in forum Import/Export Data
    Replies: 1
    Last Post: 12-13-2010, 04:07 PM
  5. Replies: 2
    Last Post: 03-28-2010, 04:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums