troubleshooting Question

Microsoft access error 70 - permission denied

Avatar of sxxgupta
sxxguptaFlag for United States of America asked on
Microsoft Access
7 Comments1 Solution2535 ViewsLast Modified:
I have two Windows 7 PCs that when the user clicks on the filter lookup (binoculars) button located on a form, they get error 70 - permission denied.  XP PCs do not have this problem and other Windows 7 PC do not have this problem.  I found out that if I comment out the Send Keys line in the code, the user does not get the error 70 problem........but when the Find window box opens up, the default search is set to search "Whole Field" instead of "Any part of the field", which is what the sendkeys line was supposed to do in the first place.  Not sure how to over come this.........
Private Sub FilterByLookup_Click()

On Error GoTo Err_FilterByLookup_Click

Screen.PreviousControl.SetFocus
SendKeys "%ha%n"
RunCommand acCmdFind

Exit_FilterByLookup_Click:
    Exit Sub

Err_FilterByLookup_Click:
    MsgBox "Error No: " & err.Number _
       & " in " & Me.ActiveControl.Name & " procedure; " _
       & "Description: " & err.Description
    Resume Exit_FilterByLookup_Click
    
End Sub
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 7 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 7 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