Exporting a form page as an excel spreadsheet

P

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?
 
J

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.
 
P

Pwyd

Sadly, no. :(

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

JString said:
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 said:
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?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Doughnut Chart linked with the slicer in the pivot table 0
Access Lock File .LACCDB / Now shows as a notepad file 0
How do I clear a form? 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Capturing data from a list box 0
Clearing Fields in a Word Form 5
ADDING values from one listbox to another on same form 1

Top