Re: RunCommand acCmdFind not working
From: M.L. Sco Scofield (Sco_at_ScoBiz.com)
Date: 09/21/04
- Next message: Allen Browne: "Re: Problems with converted MDB"
- Previous message: Douglas J. Steele: "Re: Access97 under XP job"
- In reply to: James: "RunCommand acCmdFind not working"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 20 Sep 2004 18:42:31 -0600
Try adding Screen.PreviousControl.SetFocus to your code.
Good luck.
Sco
M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
"James" <jrcooperatemaildotcom@foo.com> wrote in message
news:3a0401c49f11$eb001c90$a401280a@phx.gbl...
> Hi,
>
> I have an Access 97 app converted to Access 2002. The app
> uses workgroups to hide the Menu bar for standard users.
> To allow user to use the Find command each form contains a
> Find button, which opens the Find dialog.
>
> However, when you search the focus is set to the find
> button so I get - The control 'btnFindRecord' the macro is
> attempting to search can't be searched.
>
> I've tried using the old Access command :
> DoCmd.DoMenuItem acFormBar, acEditMenu, 10, ,
> acMenVer70
>
> And the new command:
> DoCmd.RunCommand acCmdFind
>
> And both have the same effect.
>
> Any suggestions?
> Thanks
>
>
- Next message: Allen Browne: "Re: Problems with converted MDB"
- Previous message: Douglas J. Steele: "Re: Access97 under XP job"
- In reply to: James: "RunCommand acCmdFind not working"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|