missing data when exporting out to excel

  • Thread starter Thread starter quzie
  • Start date Start date
Q

quzie

I have a query that I am exporting out to excel. All data comes over fine
with the exception of one exp field - Reporting Code:
Forms!frmReportsMenu!SelectAllIHDIV. I need this data to export to my excel
file so I can use it as a heading in the excel file. If I copy and paste this
column in excel it will copy over fine but if I use the
DoCmd.TransferSpreadsheet it will not return any value in that field. Says
unable to append all data and that is the only field that doesnt seem to come
over. Any ideas on what I am doing wrong or how I can successfully get the
results of the Forms!frmReportsMenu!SelectAllIHDIV over to the excel sheet.

thanks in advance
 
I have a query that I am exporting out to excel. All data comes over fine
with the exception of one exp field - Reporting Code:
Forms!frmReportsMenu!SelectAllIHDIV. I need this data to export to my excel
file so I can use it as a heading in the excel file. If I copy and paste this
column in excel it will copy over fine but if I use the
DoCmd.TransferSpreadsheet it will not return any value in that field. Says
unable to append all data and that is the only field that doesnt seem to come
over. Any ideas on what I am doing wrong or how I can successfully get the
results of the Forms!frmReportsMenu!SelectAllIHDIV over to the excel sheet.

thanks in advance
Click to expand...

is the form open?
If you have to force it, I guess you could turn the query into a
maketable/append query and then export the contents of the table, but
I would make sure the form is open first and then run the export.
 
I use a form that has a combo box SelectAllIHDIV and then it opens a query
that is dependent upon what is selected in that combo box on that form. So
the form is open but it only contains that combo box not the other fields
that need to be exported. I hope I explained that well enough that you know
what I am talking about.
thanks for your help
 
I use a form that has a combo box  SelectAllIHDIV and then it opens a query
that  is dependent upon what is selected  in that combo box on that form. So
the form is open but it only contains that combo box not the other fields
that need to be exported. I hope I explained that well enough that you know
what I am talking about.
thanks for your help
Click to expand...

What happens when you just run the query without trying to export? Do
you get the value from the combobox? Is it a multi-column combobox by
any chance?
 
Yes I get the value in the query, if I copy and paste into excel works fine
if I use the transfer spreadsheet it does not bring that data over. Brings
all the other data in the query just not that column. I suppose I could think
of some other work around I just thought maybe there was something I was
doing wrong that might be easily corrected. The combo box i single column
selection and actually at this point only one value in that column.
 
Back
Top