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.
"Piet Linden" wrote:
> On May 2, 6:21 pm, quzie <qu...@discussions.microsoft.com> wrote:
> > 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
> >
> > "Piet Linden" wrote:
> > > On May 2, 1:42 pm, quzie <qu...@discussions.microsoft.com> wrote:
> > > > 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
> >
> > > 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.
>
> 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?
>
|
Similar Threads
