Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

datasheet view of a query sent to snapshot viewer

Status
Not open for further replies.

stewglyn

Programmer
Apr 4, 2002
9
0
0
GB
I'm using a macro to run this function:

Function OutputToSnapshotViewerQ()
Dim Qryview As Variant,QryName As String

On Error GoTo OutputToSnapshotViewerq_Err
Set Qryview = Screen.ActiveDatasheet
QryName = Qryview.Name

DoCmd.OutputTo acOutputQuery, QryName, acFormatSNP, "C:\data\A\" & QryName & ".snp", False

OutputToSnapshotViewerq_Exit:
Exit Function

OutputToSnapshotViewerq_Err:
MsgBox Err.Description
Resume OutputToSnapshotViewerq_Exit

End Function
when run tells me output formats are missing from the registry! also i think problem with Qryview datatype.
HELP!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top