macro to vb

[NAS]

Is there a way to convert a macro into VB automatically?

 

[Steve Schapel]

NAS,

No.

 

[Phil Smith]

YES. At least with access 2007. In design view of the macro, choose
the Office button in the upper right hand corner, choose, "save as:" and
where it says MACRO, use the pull down to change it to MODULE.

It is as simple as that.

 

[Phil Smith]

YES. At least with access 2007. In design view of the macro, choose
the Office button in the upper left hand corner, choose, "save as:" and
where it says MACRO, use the pull down to change it to MODULE.

It is as simple as that.

 

[Steve Schapel]

Phil,

Whereas I admire your nice reply to such a rude dude, I would also say that
what you have described is not "automatically".

 

[Gina Whipp]

NAS,

In Access 2003...

Go to the form in Design View and then go to Tools-Macro and select Convert
Forms Macro's to Visual Basic. I have not looked in Access 2007 to see if
that option is there.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Joey Pence]

YES. At least with access 2007. In design view of the macro, choose
the Office button in the upper left hand corner, choose, "save as:" and
where it says MACRO, use the pull down to change it to MODULE.

It is as simple as that.
stampz okcofkddffdd