Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011
    Posts
    5

    Unanswered: Question about this macro

    hello all , can some one explain this macro , check the attached screen shoot

    i want to know why they uses screen , active control etc...
    i would like to make same macro after understanding this and without come back to it ...
    this macro is an access 2010 template Student
    thanks for your help

    Click image for larger version. 

Name:	macro.PNG 
Views:	9 
Size:	19.9 KB 
ID:	13559

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Very few of the experts here use Macros, but Screen.ActiveControl simply refers to the Control, on the Form the Macro is being called from, that currently has Focus when the Macro is called.

    In this particular Macro, it it telling the Access Gnomes that if the current Control is not empty, open the Report whose name is the same as the Control's Value.

    I have to add that if you plan on doing much work, in Access, you really need to learn VBA rather than rely on Macros! Macros are very rigid and more limited, in what they can do, compared to using VBA code.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •