Re: 14 field query fails Output To Excel with "Too many fields def

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



How does it fail: just doesn't produce an Excel file? Any error messages? How
about if you manually export the data without using the macro?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Phil Smith" wrote:

It fails at the "Output To" step of a macro. It does not matter when I
run it, whether nightly, based on a scheduled call to Access to run a
specified macro, or I simply open up the database and manually lauch
that macro.

Jerry Whittle wrote:
How does it fail?

When does it fail: during the output or during the nightly job?

How exactly are you running the output?

How are you going to run it every night?

.



Relevant Pages

  • Re: APPEND QUERY RUNS ON ITS OWN BUT NOT IN A MACRO
    ... I see no reason why they would fail. ... like Excel spreadsheets then a relational database. ... and its back-end c. 17 MB. ... although the AUTOEXEC macro will fail to run ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Need specific record in report
    ... Jerry Whittle, Microsoft Access MVP ... The report must contain the specific person's record data from ... I have the email function set up in a macro. ... it pops up a box wanting the ConsumerID. ...
    (microsoft.public.access.queries)
  • Re: macro recorded in one document doesnt show up in a new docume
    ... If you fail ... Some company networks renew the normal template when you log in. ... Word MVP web site http://word.mvps.org ... Word 2007 and reopen it later, however, the Macro is no longer ...
    (microsoft.public.word.docmanagement)
  • RE: Cant abandon a query without saving
    ... You need to find the macro or code and set warnings back to True after it is ... The code could be in a macro, module, or form. ... Jerry Whittle, Microsoft Access MVP ... Keith Bontrager - Bicycle Builder. ...
    (microsoft.public.access.queries)
  • Re: Recording the date and time when a record is modified in Access
    ... Don't use a macro. ... Instead use code like below in the BeforeUpdate event ... Jerry Whittle, Microsoft Access MVP ... I built the code but the DateModified Field does ...
    (microsoft.public.access.queries)