Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / July 2007

Tip: Looking for answers? Try searching our database.

Vista Run-Time error 70, Permission Denied

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ken - 19 Jul 2007 20:23 GMT
Has anyonoe found an easy way to deal with this error yet? It happens when
using the "SendKeys" in a funcntion such as the one shown below. This code
ran perfect under WinXP. I came across this blog, but I'm wondering if there
is a better way to handle it. Looks like MS has known about this for over a
year.

http://blogs.msdn.com/davbosch/archive/2006/02/26/539470.aspx

*******************************************
Private Sub Form_Load()

   Me!cmdDataSheet.Visible = False
   Me!lblDatasheetviewonScreen.Visible = False

   'Move the focus to the list box and highlight the first query

   If Not IsNull(Me.OpenArgs) Then

       Select Case Me.OpenArgs
           Case "R"
               Me.ogrQRB = 1
           Case "Q"
               Me.ogrQRB = 2
           Case "B"
               Me.ogrQRB = 3
           Case Else
               MsgBox "Form " & Me.Name & " was passed incorrect OpenArgs
'" & _
                   Me.OpenArgs & "'.", vbCritical, "Cannot Continue"
               DoCmd.Close

       End Select

       SetupList (Me.OpenArgs)
   Else
       SetupList "R"
   End If

   SendKeys "{Down}"

End Sub
*******************************************

Private Sub cmdNew_Click()

On Error GoTo Err

   DoCmd.GoToRecord , , acNewRec
   DoCmd.GoToControl "txtClientName"
   SendKeys "{F4}", False

ExitErr:
   Exit Sub

Err:
   MsgBox "Error No: " & Err.Number & "; Description: " & Err.Description
   Resume ExitErr

End Sub
*******************************************

Thanks,

Ken
Klatuu - 19 Jul 2007 20:56 GMT
I don't know about Vista, but it doesn't suprise me.  I understand AC2007 no
longer supports Sendkeys.
Sendkeys is an archaic command that should be avoided.
Signature

Dave Hargis, Microsoft Access MVP

> Has anyonoe found an easy way to deal with this error yet? It happens when
> using the "SendKeys" in a funcntion such as the one shown below. This code
[quoted text clipped - 60 lines]
>
> Ken
Ken - 24 Jul 2007 19:42 GMT
Thanks for the response. So what would I use instead of Sendkeys in the
example below?

Ken

>I don't know about Vista, but it doesn't suprise me.  I understand AC2007
>no
[quoted text clipped - 71 lines]
>>
>> Ken
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.