E
Ed Patterson
My book inventory database is in Access 2000 I am trying to eliminate
unnecessary and annoying mouse moves and clicks.
The following code in an event procedure for a command button pops up
a search box. The default "Match:" setting in the Find and Replace box
is "Whole Field". How do I set the default to "Any Part of Field"?
Private Sub cmdFindRecord_Click()
On Error GoTo Err_cmdFindRecord_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_cmdFindRecord_Click:
Exit Sub
Err_cmdFindRecord_Click:
Thank you for your assistance,
Ed Patterson
MsgBox Err.Description
Resume Exit_cmdFindRecord_Click
End Sub
unnecessary and annoying mouse moves and clicks.
The following code in an event procedure for a command button pops up
a search box. The default "Match:" setting in the Find and Replace box
is "Whole Field". How do I set the default to "Any Part of Field"?
Private Sub cmdFindRecord_Click()
On Error GoTo Err_cmdFindRecord_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_cmdFindRecord_Click:
Exit Sub
Err_cmdFindRecord_Click:
Thank you for your assistance,
Ed Patterson
MsgBox Err.Description
Resume Exit_cmdFindRecord_Click
End Sub