controling the spread of fields in the excel

[thread]

Hi all,
I'm trying to find a way to export the data in the form into excel.
is there a way to decide on the fields and culomns that are been
exported to the excel file?

 

[Jeff Boyce]

If I understand correctly, you are trying to control which fields are
exported to Excel.

You can do this by export a query, rather than a form. In your query, limit
the fields.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[thread]

is there a way to place SQL sentence inside of an ADO object and that
way it will be much more dynamic for me to do any changes

Jeff Boyce ëúá:

 

[Jeff Boyce]

I'm afraid I don't have any experience in that area.

Good luck!

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

is there a way to place SQL sentence inside of an ADO object and that
way it will be much more dynamic for me to do any changes

Jeff Boyce ëúá:

 

[John Nurick]

I'm not sure, but your VBA code can assign an SQL statement to a query
on the fly, e.g. (code snippet)

Const QToExport = "qryExportQuery"
Dim SQL As String

SQL = "SELECT "
'append list of fields to SQL
...
SQL = SQL & " FROM MyTable "
SQL = SQL & " WHERE ...
...

'Assign new SQL statement to query
CurrentDB.QueryDefs(QToExport).SQL = SQL

DoCmd.TransferSpreadsheet acExport, , qryExportQuery

 

[thread]

thanks,i believe that should do
John Nurick כתב: