Exporting a form page as an excel spreadsheet

[Pwyd]

I was trying to export a form as an excel spread sheet, i've never had a
single problem with this in the past. It would export each listbox on the
form, and then put each value as a row. For some reason now, its giving me
hte column headings as the listbox names, which is fine, but all of the
contents are null. it exports the proper number of rows. but they're all
blank.

In a seperate but similar issue, i'm trying to compare the contents of a
textbox to the value of a listbox. When i use the msgbox function to pop up
the values, it shows that they're both null, even thoug hthe open form, right
in front of me, clearly shows they are not. using the .value qualifier does
not help. changing from me. to the strict [Forms]!...etc has no effect at
all.

What the hell is going on?

 

[JString]

I don't know, but it sounds as if you were using a method like
transferspreadsheet by referencing a query statement that might not be
working anymore.

 

[Pwyd]

Sadly, no.

I was using the standard "export" command. Running it from the file menu
doesn't make any difference either.

I don't know, but it sounds as if you were using a method like
transferspreadsheet by referencing a query statement that might not be
working anymore.

I was trying to export a form as an excel spread sheet, i've never had a
single problem with this in the past. It would export each listbox on the
form, and then put each value as a row. For some reason now, its giving me
hte column headings as the listbox names, which is fine, but all of the
contents are null. it exports the proper number of rows. but they're all
blank.

In a seperate but similar issue, i'm trying to compare the contents of a
textbox to the value of a listbox. When i use the msgbox function to pop up
the values, it shows that they're both null, even thoug hthe open form, right
in front of me, clearly shows they are not. using the .value qualifier does
not help. changing from me. to the strict [Forms]!...etc has no effect at
all.

What the hell is going on?