Macro questions

[Alan T]

I am new to Access. The reason I need to look at Access is I need to
redevelop the existing Access application into another application so I need
to understand the current Access application.

Here it is:
A macro called 'Exit' will be called when a form is exited.

Macro Name Action
Exit Close
SelectObject
SetValue

I click on the 'Exit', this is the macro name, bottom shows:
Object Type: Form
Object Name: Employee Query <-- this is a SELECT query

I click on the 'Close' action:
Object Type: Form
Object Name: Employee Query

I click on the 'SelectObject' action:
Object Type: Form
Object Name: Employee Maint <-- this is a form
In Database Window: No


I click on the 'SetValue' action:
Item: [Visible]
Expression: Yes

Can someone let me know what this 'Exit' macro does please?

 

[alan]

¿ªÍØÍøÂç×÷ΪÐÂÆð£É£ÔÐÂÐ㣬Á¢×ã°²»Õ£¬ÃæÏòÈ«¹ú£¬ÎªÄúÌṩ×îÓÅÖʵķþÎñ
ÒµÎñº­¸ÇÓòÃû×¢²á£¬ÐéÄâÖ÷»ú£¬Ö÷»ú×âÓÃÍйܣ¬×ÔÓг¬Ç¿»ú·¿ºÍÒ»ÅúרҵԱ¹¤£¬ÎªÄú´î½¨ÍêÃÀµÄÍøÂçÎę̀£¬»¶Ó­ÁªÏµºÏ×÷
ÌÔ±¦´úÀíµê£ºhttp://shop33481519.taobao.com
Ö§¸¶±¦½»Ò×£¬È·±£°²È«£¨ÎÞÕÊ»§¿ÉÁªÏµÏßϽ»Ò×£©
ÖйúºÏ·Êò£ÉÏ·Ԫһ±õË®³Ç10´±2Â¥
ºÏ·Ê¿ªÍØÍøÂ繫˾ [ÍîICP±¸0507157]
ÒµÎñÁªÏµ£ºQQ:136159875
MSN:[email protected]
ÍúÍú£ºlanrain1012
email:[email protected]
µç»°£º13687593351

 

[Alan T]

Sorry, I can't read your characters.

 

[Tom Wickerath]

Hi Alan,

The reason I need to look at Access is I need to
redevelop the existing Access application into another application...

May I ask why?

It will be much easier for me (and likely others as well) to determine what
is going on if you convert this macro to VBA code, and then post the code. To
do this, select the macro group in question. Then click on Tools > Macro >
Convert Macros to Visual Basic.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

I am new to Access. The reason I need to look at Access is I need to
redevelop the existing Access application into another application so I need
to understand the current Access application.

Here it is:
A macro called 'Exit' will be called when a form is exited.

Macro Name Action
Exit Close
SelectObject
SetValue

I click on the 'Exit', this is the macro name, bottom shows:
Object Type: Form
Object Name: Employee Query <-- this is a SELECT query

I click on the 'Close' action:
Object Type: Form
Object Name: Employee Query

I click on the 'SelectObject' action:
Object Type: Form
Object Name: Employee Maint <-- this is a form
In Database Window: No


I click on the 'SetValue' action:
Item: [Visible]
Expression: Yes

Can someone let me know what this 'Exit' macro does please?