Results 1 to 3 of 3
  1. #1
    tylerg11 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    200

    DoCmd.OutputTo

    I use DoCmd.OpenReport and the Load event code gets executed. But if I use DoCmd.OutputTo, the Load event does not fire. I want that Load code to fire when I output the report without opening it.

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    I don't think a "Load" event on "OutputTo" makes any sense. The "OpenReport" physically opens a report. It is that opening/loading of that Report that is triggering the "Load" event.
    The "OutputTo" just outputs your data to a file, it does not open it, so there is no "Loading" going on within an Access object, so there is no "Load Event".

  3. #3
    tylerg11 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Sep 2011
    Posts
    200
    Ok. I was able to do what I was trying to do on the OnOpen event.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. DoCmd.OutputTo question
    By mkc80 in forum Access
    Replies: 5
    Last Post: 10-16-2012, 07:11 PM
  2. DoCmd.OutputTo not working
    By arunkumar213 in forum Access
    Replies: 1
    Last Post: 09-08-2011, 10:41 PM
  3. AcFormat in DoCmd.OutputTo
    By SIGMA248 in forum Programming
    Replies: 1
    Last Post: 04-15-2011, 08:50 AM
  4. OutputTo PDF???
    By jgelpi16 in forum Programming
    Replies: 1
    Last Post: 03-17-2011, 11:39 AM
  5. OutputTo Excel
    By smikkelsen in forum Access
    Replies: 0
    Last Post: 03-08-2011, 05:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums