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

export query in xml format

Status
Not open for further replies.

gsix

MIS
Jun 24, 2006
1
US
I want to export a query in xml using Access VBA. I am 99% there but I have the error '7798'. I looked all over (forums, msdn) for the documentation about this run-time error but so far nothing... Can someone point me to a URL so that I can debug? I do not know if I am missing something...

Note: this error does not occur when the a SELECT query has been created manually with the GUI. It occurs when I create a new SELECT query through VBA and assign the following properties: maxrecords = 10, hidden = true.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top