VBA-Create Macro (& Delete Form)

[daoxx]

Hi
I didn't find anything with the search - the words are too general.

How can I create a macro and define what it does from code?


EDIT: The other question was

How can I delete Form2 from Form1 with a button?

To do this use

DoCmd.DeleteObject acForm, name

Thanks

[NeoPa]

I'm afraid I can't help here, but I'm interested to know why you might want to create a macro from VBA code?

[daoxx]

I'm trying to allow people that can not work with Access have a simpler environment (only "click button, input data" kinda thing).

[NeoPa]

Ah.

In that case I suggest that perhaps you're interested in creating a macro OR code - rather than creating a macro using code.

Either method can automate tasks for you, although my personal preference is always to use code where possible.

I believe macro creation is possible with code, but certainly not for the feint-hearted or inexperienced coder.

Good luck :)

[daoxx]

Thank you, NeoPa .

[NeoPa]

No worries - Glad I could be of any help.

Welcome to TheScripts :)