[MS_AccessPros] Open Query Design, Close the Show Table dialouge box, Switch to SQL View

 

Can someone tell me what I need to do do the code below to perform what I have in the subject line? Right now it opens a Wizard window for Queries and not the Query Design button. I'm using Access 2007.

Public Function openNewQry()

On Error GoTo ErrHandler

SendKeys "~", False
RunCommand acCmdNewObjectQuery
RunCommand acCmdSQLView

Exit Function

ErrHandler:

MsgBox "Error in openNewQry( )." & vbCrLf & vbCrLf & _
"Error #" & Err.Number & vbCrLf & vbCrLf & Err.Description
Err.Clear

End Function

Thanks,

Steve

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 2
• New Files 9

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___