在Access表单中使用鼠标滚轮滚动到备忘录框或组合框

huangapple
go评论92阅读模式
英文:

Using Mouse Wheel into the Memo Box or Combo Box in Access Forms

问题

我有一个名为“NewStaff”的Access表单，其中包含一个备忘录框。当我点击其中时，滚动鼠标滚轮会导致退出该字段，并且不会放置在备忘录框内的文本上。最后，我将以下代码放在表单的鼠标滚轮事件上，现在我可以通过滚动鼠标滚轮来移动备忘录框的行。

  1. Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long)
  2.     Dim i As Long
  3.     Dim s As String
  4.     If Me.ActiveControl.Name = "NewStaff" Then
  5.         If Count > 0 Then
  6.             For i = 1 To Count
  7.                 s = s & "{DOWN}"
  8.             Next i
  9.         Else
  10.             For i = 1 To -Count
  11.                 s = s & "{UP}"
  12.             Next i
  13.         End If
  14.         SendKeys s
  15.     End If
  16. End Sub

问题在于光标会跳跃三行到三行，最终离开该字段！

是否有一种逐行移动并保持在备忘录框内的方法？...谢谢

英文:

I have an Access form named "NewStaff" that contains a Memo box. When I clicked inside it, rolling the mouse wheel would cause an exit to this field and it would not be placed on the text inside the Memo box. Finally, I put the following code on the MouseWheel Event form and now I can move the Memo box lines by rolling the mouse wheel.

> Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long)
> Dim i As Long
> Dim s As String
> If Me.ActiveControl.Name = "ُNewStaff" Then
> If Count > 0 Then
> For i = 1 To Count
> s = s & "{DOWN}"
> Next i
> Else
> For i = 1 To -Count
> s = s & "{UP}"
> Next i
> End If
> SendKeys s
> End If
> End Sub

The problem is that the cursor has jumping three lines to three lines and finally leaves the field!

Is there a way to go line by line and stay in Memo box for the cursor? ... Thanks

答案1

得分: 2

使用SendKeys UP/DOWN来滚动文本不够灵活 - 用户不一定希望光标移动，只需要文本滚动。另外，你提到的“突然退出”效果。

很久以前，我找到并适应了这个解决方案。将所有代码粘贴到一个模块中，并按照注释中所示进行调用。

  1. Option Compare Database
  2. Option Explicit
  4. Private Const WM_VSCROLL = &H115
  5. Private Const SB_LINEUP = 0
  6. Private Const SB_LINEDOWN = 1
  8. Public Declare Function SendMessage Lib "user32" _
  9.    Alias "SendMessageA" _
  10.    (ByVal hWnd As Long, _
  11.    ByVal wMsg As Long, _
  12.    ByVal wParam As Long, _
  13.    lParam As Any) _
  14.    As Long
  15.    
  16. Private Declare Function apiGetFocus Lib "user32" _
  17.         Alias "GetFocus" _
  18.          () As Long
  19. '
  21. ' 用鼠标滚轮滚动多行文本框。文本框必须具有焦点。
  22. '
  23. ' 在包含多行文本框的表单的MouseWheel事件中调用此子例，如下所示：
  24. '
  25. ' Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long)
  26. '    Call MouseWheelScroll(Count)
  27. ' End Sub
  28. '
  29. ' 来源
  30. ' http://www.access-programmers.co.uk/forums/showthread.php?t=195679
  31. ' http://www.extramiledata.com/scroll-microsoft-access-text-box-using-mouse-wheel/
  33. Public Sub MouseWheelScroll(ByVal Count As Long)
  35.     Dim LinesToScroll As Integer
  36.     Dim hwndActiveControl As Long
  37.     
  38.     If Screen.ActiveControl.Properties.Item("ControlType") = acTextBox Then
  39.         hwndActiveControl = fhWnd(Screen.ActiveControl)
  40.         For LinesToScroll = 1 To Abs(Count)
  41.             SendMessage hwndActiveControl, WM_VSCROLL, IIf(Count < 0, SB_LINEUP, SB_LINEDOWN), 0&
  42.         Next
  43.     End If
  45. End Sub
  47. ' 来源: http://access.mvps.org/access/api/api0027.htm
  48. ' 代码由 Dev Ashish 提供
  50. Private Function fhWnd(ctl As Control) As Long
  51.     
  52.     On Error Resume Next
  53.     ' 我们只在Screen.ActiveControl中使用此函数，因此这不是必要的。
  54.     ' 我记不清是否在某些情况下发现它有害。
  55.     ' ctl.SetFocus
  56.     
  57.     fhWnd = apiGetFocus
  58.     On Error GoTo 0
  59.     
  60. End Function

希望这能帮助你。

英文:

Using SendKeys UP/DOWN to scroll is clunky - users don't necessarily want the cursor to move, only the text to scroll. Plus the "sudden exit" effect you noticed.

A long time ago I found and adapted this solution.
Paste all the code into a module, and call it as shown in the comments.

  1. Option Compare Database
  2. Option Explicit
  4. Private Const WM_VSCROLL = &amp;H115
  5. Private Const SB_LINEUP = 0
  6. Private Const SB_LINEDOWN = 1
  8. Public Declare Function SendMessage Lib &quot;user32&quot; _
  9.    Alias &quot;SendMessageA&quot; _
  10.    (ByVal hWnd As Long, _
  11.    ByVal wMsg As Long, _
  12.    ByVal wParam As Long, _
  13.    LParam As Any) _
  14.    As Long
  15.    
  16. Private Declare Function apiGetFocus Lib &quot;user32&quot; _
  17.         Alias &quot;GetFocus&quot; _
  18.          () As Long
  19. &#39;
  21. &#39; Scroll multi-line textboxes with the mouse wheel. The textbox must have the focus.
  22. &#39;
  23. &#39; Call this sub in the MouseWheel event of the form(s) containing multi-line textboxes, like this:
  24. &#39;
  25. &#39; Private Sub Form_MouseWheel(ByVal Page As Boolean, ByVal Count As Long)
  26. &#39;    Call MouseWheelScroll(Count)
  27. &#39; End Sub
  28. &#39;
  29. &#39; Sources
  30. &#39; http://www.access-programmers.co.uk/forums/showthread.php?t=195679
  31. &#39; http://www.extramiledata.com/scroll-microsoft-access-text-box-using-mouse-wheel/
  33. Public Sub MouseWheelScroll(ByVal Count As Long)
  35.     Dim LinesToScroll As Integer
  36.     Dim hwndActiveControl As Long
  37.     
  38.     If Screen.ActiveControl.Properties.Item(&quot;ControlType&quot;) = acTextBox Then
  39.         hwndActiveControl = fhWnd(Screen.ActiveControl)
  40.         For LinesToScroll = 1 To Abs(Count)
  41.             SendMessage hwndActiveControl, WM_VSCROLL, IIf(Count &lt; 0, SB_LINEUP, SB_LINEDOWN), 0&amp;
  42.         Next
  43.     End If
  45. End Sub
  47. &#39; Source: http://access.mvps.org/access/api/api0027.htm
  48. &#39; Code Courtesy of Dev Ashish
  50. Private Function fhWnd(ctl As Control) As Long
  51.     
  52.     On Error Resume Next
  53.     &#39; We only use this function for Screen.ActiveControl, so this is not necessary.
  54.     &#39; I can&#39;t remember if I found it harmful in some situations.
  55.     &#39; ctl.SetFocus
  56.     
  57.     fhWnd = apiGetFocus
  58.     On Error GoTo 0
  59.     
  60. End Function

答案2

得分: 1

这是一个鼠标设置：

英文:

I believe that's a mouse setting:

在Access表单中使用鼠标滚轮滚动到备忘录框或组合框

答案3

得分: 0

好的，我找到了一个问题的解决方案。在鼠标设置（鼠标属性）中跳“三行到三行”的问题在Windows控制面板中，它默认为数字三。我们必须将其更改为数字一！

路径：控制面板 > 鼠标属性 > 滚轮

现在，我们只需修复突然退出备忘录框的问题！

英文:

Well, I found a solution to one of the problems. The problem of jumping "three lines to three lines" in the mouse settings (Mouse Properties) was in the Windows Control Panel, which by default is on the number three. We have to change it to number one!

Path: Control Panel > Mouse Properties > Wheel

在Access表单中使用鼠标滚轮滚动到备忘录框或组合框

Now, We just have to fix the sudden exit from the Memo box!

huangapple
  • 本文由 发表于 2023年5月7日 18:08:25
  • 转载请务必保留本文链接：https://go.coder-hub.com/76193253.html
  • ms-access
  • vba
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定