ronin
07-22-2010, 07:06 AM
Hi ,
I have this problem, I use this code
Application.ExportXML ObjectType:=acExportQuery,DataSource:="XMLQuery", _
DataTarget:="I:\PensionMail\" & Me.CurrentConsult & "_" & ConsID & "_" & Format(Now, "dd-mm-yy") & ".xml"
and my DataSource is table resulted from a query which return also columns with empty(null) values if there such .
In the result XML file I can't see the columns that are with null values
How to see them reflected also in xml file ???
thanks
I have this problem, I use this code
Application.ExportXML ObjectType:=acExportQuery,DataSource:="XMLQuery", _
DataTarget:="I:\PensionMail\" & Me.CurrentConsult & "_" & ConsID & "_" & Format(Now, "dd-mm-yy") & ".xml"
and my DataSource is table resulted from a query which return also columns with empty(null) values if there such .
In the result XML file I can't see the columns that are with null values
How to see them reflected also in xml file ???
thanks