Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    4

    VBA Code pops up unexpectantly

    Although the code has compiled without error, a report is giving me trouble. The command is:

    DoCmd.OpenReport stDocName, acViewPreview

    A VBA code window pops open unexpectantly, to this spot. I can even import an earlier version of the report (March 15) and the problem persists. I can find nothing wrong with the report! It used to open without this behavior.



    Ideas on how to resolve?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Are you setting the name first? Does the report open without error directly from the navigation pane?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Need help with VBA code here
    By goodguy in forum Programming
    Replies: 2
    Last Post: 09-09-2011, 06:26 AM
  2. Word code in Access - How to modify my current code
    By Alexandre Cote in forum Programming
    Replies: 0
    Last Post: 11-15-2010, 08:26 AM
  3. Code in combobox, code in text box
    By float in forum Forms
    Replies: 3
    Last Post: 09-29-2010, 07:12 AM
  4. Access 2003 code vs Access 2007 Code
    By ralphjramirez in forum Access
    Replies: 5
    Last Post: 11-23-2009, 12:33 PM
  5. Help with vba code
    By rockape in forum Programming
    Replies: 11
    Last Post: 09-29-2009, 06:49 AM

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