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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Formats missing from Windows Registry.

Status
Not open for further replies.

bPruFin

Programmer
Sep 16, 2004
10
US
I'm getting an error (see below) when I get to DoCmd.OutputTo command at the end of this code.

Dim db As DAO.Database
Set db = CurrentDb

Dim qryOut As QueryDef

db.QueryDefs.Delete "tmp"
Set qryOut = db.CreateQueryDef("tmp", q2$)

DoCmd.OutputTo acOutputQuery, "tmp", xlCSVMSDOS, fileName, False

Note's:
1. q$ is a variant containing the sql statement.
2. fileName is a string variable containing the full path info with the name and ends in the .cvs extension.
3. I'm running this in MS Access 2000 in WinXP.

The error is # 2282 : "The formats that enable you to output data as a Microsoft Excel, rich-text format, MS-DOS text, or HTML file are missing from the Windows Registry."

Anyone have any ideas?

Thanks!

- Bruce
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top