Why doesn't all the data output to excel?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Fspinelli
    New Member
    • Aug 2010
    • 85

    Why doesn't all the data output to excel?

    I have a query used to enter data and it takes that data and forms 7 different symbols from them.

    I have a macro that outputs the query (results) to Excel. Only problem is some of the symbols do not carry over in full, just partially. I still see them in the query, but only pieces of it outputs to Excel.

    The macro is:
    Object Type: Query
    Object Name: qryMakeSymbols
    Auto Start: Yes

    The field names (or controls - whatever they are called) in each of the 7 are on target. I checked to see if there was any discrepancies - nada.

    What am I missing?
  • Fspinelli
    New Member
    • Aug 2010
    • 85

    #2
    Oh Never Mind...I figured it out! I had to set the Object Type to "Form" - it worked. thanks anyway!

    Comment

    Working...