troubleshooting Question

Access 2007 RunTime - "The command or action 'Find' isn't available now."

Avatar of souquetbressand
souquetbressandFlag for United States of America asked on
Microsoft Access
2 Comments1 Solution1105 ViewsLast Modified:
Hello,

I have created a database in Access 2007 which is backended by MySQL.  When I deploy this database via the 2007 Developer Extensions everything seems to function correctly.  However, I have coded a button to use the "find" function so that my users can search the database for records which are pertinent to their needs.

Unfortunately, when they click this button, they get the error, "The command or action 'Find' isn't available now."  CTRL+F does not work either.  The code below is what was used to design the button which will search the form as needed.  Regrettably I have searched endlessly and cannot find a solution to this problem.  Sadly MS support for RunTime is nearly non-existent.

If anyone has a solution to this issue or any suggestions on further troubleshooting the problem, please let me know.  Also, if you need additional information I would be happy to provide it.  

Thank you!
Private Sub find_cp_Click()
On Error GoTo Err_find_cp_Click
 
    Screen.PreviousControl.SetFocus
    DoCmd.RunCommand acCmdFind
 
Exit_find_cp_Click:
    Exit Sub
 
Err_find_cp_Click:
    MsgBox Err.Description
    Resume Exit_find_cp_Click
    
End Sub
ASKER CERTIFIED SOLUTION
jppinto

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros