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 Sub
    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

    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: MS Access Tips and Code Samples:

    Monday, February 6, 2017 10:24 PM