none
2007 bug RRS feed

  • Question

  • Being retired, I spend 8-10 hours a day, on half a dozen Access forums, and haven't seen a report of this bug.

    I usually write my own code, but running up a 'quick and dirty' form, to answer a forum question for someone, used the Command Button Wizard to check out something. The code it produced was this

    Private Sub OpenReport_Click()
    
    On Error GoTo Err_OpenReport_Click
    
     
    
     
    
        stDocName = "ReportName"
    
        
    
     
    
    Exit_OpenReport_Click:
    
        Exit Sub
    
     
    
    Err_OpenReport_Click:
    
        MsgBox
    Err.Description
    
        Resume
    Exit_OpenReport_Click
    
        
    
    End Sub

    which obviously won't open a Report!


    Monday, February 6, 2017 5:49 PM

All replies

  • Hi,

    I don't have 2007 but I just tried the same thing using 2010, and I got an Embedded Macro instead of VBA (this is even after I checked "Always use event procedure" in Options).

    Doesn't 2007 use embedded macros as well (I can't remember)?

    Monday, February 6, 2017 6:05 PM
  • I don't have that version to test, but maybe it was a bug that got fixed. Do you have all your Office updates installed? 2007 was really buggy off the shelf.

    Or if you can't find any other posts about this, maybe it was a one-time thing. Can you reproduce it in a new database?


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Monday, February 6, 2017 9:54 PM
  • I can confirm theDBguys expectations.  I just tested multiple button insertions with different option combination using Access 2007 and could not replicate the problem and Access always generated an embedded macro.  Even converting it into VBA there was no issue.

    Was this a one time thing, or is it reproducible?
    Can you give a step-by-step guide on how to reproduce the problem?
    Is your installation up-to-date? (FMS states 12.0.6650.5000, but I have 12.0.6759.5000)


    Daniel Pineault, 2010-2016 Microsoft MVP Professional Support: http://www.cardaconsultants.com MS Access Tips and Code Samples: http://www.devhut.net

    Monday, February 6, 2017 10:24 PM