Converting Access Macro to VB

[ardneh]

Hi,

I know this is stupid..but the Access 2000 help file doesn't give me a hint on where to find the converted Macro.

In a design view, (after I create a report), I see that we can convert the Report Macro to VB (tool -> macro->convert Report's macro to visual basic. I really think this is a cool feature.. so I click on that. The conversion is done, but I dont know where the macro file is.. neither I know how to add it into my VB codes.

Can someone tell me ?

Rgds



hendra

[ardneh]

Hi,

I've been tryng to find the answer to this question for 1 whole day yesterday, but still can't find the answer.

And since no one reply to this forum, I am left with 2 possibilites.

1. The answer is so damn obvious!! So you guys think that I am lazy to find the answer myself
2. Nobody knows the answer.

So, my next question is "does the question really so obvious ??"

At this moment, I am left with 2 weeks to complete my DB project. So, if anyone know the answer pls do help me with it. I have scanned thru Access 97 Bible and found none, I have read the MSDN explaination (of course to no avail) and I have asked some friends..

I still don't know how to control the macro or create a report on Access from VB, so I am hoping that if I can learn how to create a report from Access and then convert the macro to module, i don't have to do any programming at all... But, that if I can find where is the converted macros.

Thanx anyway for reading my posts..




hendra