• kschwid (2/13/2012)


    In SQL you can highlight all queries in the Summary tab and right click and choose "Execute Stored Procedure as" then choose "create to", then choose file. This will script all hightlighted sp's create code into one file that you can then dig into and use find functions etc. to pick apart/find what you need.

    My question is, does Access have anything like that?

    not that I am aware of, but would like to know if there is.

    its not necessarily the "access views" you need to consider....you can have VBA code attached to a form event / cmdbutton event etc...also Access has "modules" where other code resides

    one idea...open a form in design view ..fire up the VBA code window and then use Edit>Find method to search for various "names" you believe may exist

    another...have you looked at exg "modules" and what that code does?

    .......sorry grasping at straws now

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day