Macro in Microsoft Access

1. What is Macro?

Macro KWCa Object mYyy:agsMxan;rbs; Microsoft Access vamantUnaTIsMrab; CUybEnßmel,Ón kargarrbs;eyIg)any:agqab;rh½s. vaGacP¢ab; Object epSg²enAkñúgkmµviFI eGayeFVIkarCamYyKña ehIy mantYnaTIxusRslHBI Tables, Queries, Forms nig Reports edaysarvamanlkçN³BiessmYyKW vaCa lkçN³énskmµPaB (Action) s+Mrab;eFVIeTAelI Files ( Databases) eGayeFVIGVImYy.

]TahrN_ ³ begáIt Macro mYyedIm,IbgðajCa Msgbox (Message box) KwbBa¢areTAelI File eGaybgðaj Bt_man (Message) ecjmkenAeBlEdleyIgebIk Form NamYy.

Macro GacbegáItnUv skmµPaB epSg²CaeRcIn dUcCa³ Open Form, Close Form, rWbegáIt Menu CaedIm.

2. rebobbegáIt Macros:

            - cucelI  Macros

            - cuc New eBlenaHvanig bgðajRbGb; Macro dUcxageRkam³

 

- Action: sMrab;eGayeyIgeRCIserIsedIm,IeGayeFVIskmµPaBGVImYy

% Action Arguments: sMramb;eRbIbBa¢ak;bEnßmeTAelIskmµPaB

]> kñúg Action eyIgeRCIserIsyk Msgbox KwbegáIt Message . bnÞab;mkeyIgRtÚvkMnt;bEnßmnUvkñúg  Action Arguments KW

-        Message: eyIgbBa©ÚlBt_manEdleyIgcg;eGayvabgðaj

-        Beep: yk Yes ( bgðajfamansMelg)

  ebIyk No ( KµansMelg )

-        Type: eRCIserIsykRbePTsBaØaEdlcg;eGaybgðaj ( sBaØa !, ? )

 Title: sMrab;dak;cMNgeCIgenARbGb; Message eBlvabgðaj.

 

eRkayeBleyIgbegáItrYcehIy (Save dak;eQµaH Ex: Msgbox ) .

kar Save enHeFVIeGayeyIgmanlkçN³gayRsYlkñúgkarP¢ab; Command Button kñúg Form.

3. rebobP¢ab; Macro kñúg Form:

edIm,IP¢ab; Macro eTAkan; Form eyIgRtUvebIk Form enaHCa Design View

-          Select on Form (Ctrl + R)

-          cucelI  Tabs

-          eRCIserIsyk On Open b¤ On Load

-       eRCIserIsyk Macro EdleyIg)anbegáIt (Msgbox) .

cMNaM:

eyIgGacbegáIt Macro edayBMucaM)ac;begáItenAkñúg Object Macros rYceTIbP¢ab;eTAkan; Command Button én Form k¾)anEdr eyIgGacbegáIt edaypÞal;Etmþg enAelI Tab Event én Properties rbs; Form b¤ Command Button .

]> eyIgbegáIt Macro OpenForm nig CloseForm edaymincaM)ac; begáItedaypÞal;enAkñúg Object Macro eyIgbegáIt eTAtam Tab Event én Properties rbs; Command OpenForm nig CloseForm pÞal;Etmþg.

viFIeFVI³

1 Macro Open Form

-          ebIk Form Ca Design View

-          cucelI Toolbox

-          RtÚvbiT Control Wizard CamunsinehIy cucelI Command Button ykkmKUrelI Form

-          Select elI Command Button ehIycuc Mouse xagsþaM

-          eRCIserIsyk Properties

-          cucelI Event Tab ehIydak; Cursor enAkñúg Text én On Click (has more data)