Thursday, January 08, 2009   
  Search   
 
 
Register  Login  
Forums  
     Minimize  

Welcome to MeraWindows forums.

Thank you for being at the Microsoft Windows Community Site. You may have to register before posting in forums. It's absolutely free. After registering, you can get all the benefits available to our registered members, you can access our Downloads section, you can participate in contests, etc. You can post in forums in English as well as in Hindi, in fact we encourage you to use Hindi in your posts. If you have any problem with registration or login, please contact us.
     
  


 
  Microsoft Windows Forums  Microsoft Offic...  Microsoft Acces...  General Information : Macros and other functions
Previous Previous
 
Next Next
New Post 8/7/2008 11:06 PM
User is offline techfreak
1141 posts
gizmos4fun.blogspot.com
MW Addict




General Information : Macros and other functions  
Macros in Access can be considered like a simplified programming language that can be used to increase the functionality of the data base. For example, it can enclose a macro to a command button in a form, so the macro is executed when clicking in the button. The macros contain actions that make tasks, like opening a report, executing a query or to close the data base. Almost all the operations of data bases that normally are made manually can automate by means of macros, thus saving time. 
 
Modules, like macros, are objects that serve to increase the functionality of the data base. Whereas the macros in Access are created selecting actions of a list, the modules are written in the Visual BASIC programming language for Applications (VBA), a version of the language of macros of Visual Microsoft BASIC who is used to program applications based on Microsoft Windows and who is included in several programs of Microsoft. A module is a collection of declarations, instructions and procedures that are stored jointly like a unit. There are two kinds of modules: standard modules and class modules. The class modules are joined to forms or reports, and normally they contain specific procedures of the form or the report to which they are enclosed. The standard modules contain general procedures that are not associated to any other object. 
 
Macros
 
1) In the Create tab, in the group Other, click in Macro command, then Macro menu item.
 
Illustration 1: Select the Macro command.  Click here to view larger image.
 
2) The Macro definition panel will appears.
 
Illustration 2: You will configure the macro in this panel.  Click here to view larger image.
 
3) Select the OpenForm action.
 
4) Configure the OpenForm arguments.
 
Illustration 3: You will configure the macro in this panel.  Click here to view larger image.
 
5) A condition specifies certain criteria that must be met before an action will be performed. You can use any expression to evaluate to true or false or Yes or No the expression and execute or not some commands based in these results.
 

 

CONTINUE THE COMPLETE REVIEW HERE
Gizmos4fun
 
New Post 8/7/2008 11:13 PM
User is offline Vasu Jain
3078 posts
www.cyberDimensions.blogspot.com
Distinguished Member




Re: General Information : Macros and other functions  

tx4 the post...really informative...shud b made a sticky post

"There are only '10' types of ppl in dis world. Those who understand BINARY and those who dont."

 
New Post 8/9/2008 9:18 PM
User is offline techfreak
1141 posts
gizmos4fun.blogspot.com
MW Addict




Re: General Information : Macros and other functions  

Thnx Vasu... Macros word is heard and seen by everyone.. but few know about

Gizmos4fun
 
New Post 8/10/2008 2:56 PM
User is offline dmudgal
724 posts
Experienced Member




Re: General Information : Macros and other functions  

yep even i knew abt.it but not in this fashion..........thanks buddy

Animate India
 
New Post 10/6/2008 12:16 AM
User is offline shrikant
1 posts
Member


Re: General Information : Macros and other functions  

hi...My name is shrikant ..How to view the macro functions which r already created..please help me....
 
 Page 1 of 1
Previous Previous
 
Next Next
  Microsoft Windows Forums  Microsoft Offic...  Microsoft Acces...  General Information : Macros and other functions


   Get Your Own E-Mail Account @MeraWindows.com Minimize  
New Page 1 New Page 1
Show your cool quotient with @merawindows.com email account
     
  
 
 
Terms Of Use   Privacy Statement  
© 2008 MeraWindows.com