[Beginner]how retrieve VBA code from Wizard

[peuplier]

Good morning
I need to know how to retrieve code from wizards. For example when you trigger Wizard to create sql queries, or a Forms, Reports, I think Access generate VBA code. Iam interresting how to retrieve this code. At first is it possible ? and if this is the case how to do ?
In my far experience in VB6, 10 years ago -time of dynosauraurus -, I recall we could retrieve the vb6 code, when launching a dao wizard. I don't know if this is possible today, with the new softwares nowadays

Thank for any help

Regards

 

[PHV]

Use the VBE: Alt-F11

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Hi,

You are referring to SQL, not VBA code.

The SQL is one of the properties of the QueryTable Object; probably the CommandText property. You can get this using VBA code, maybe something like...

Debug.Print YourQueryTableObject.CommandText

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dhookom]

If I understand correctly, you desire to get at the code in the wizard library files. The code is contained in multiple DLL, MDT, MDE, and other files. Most of it is compiled so you won't find readable source code. There are "hooks" into the code that allow you to write code to invoke the wizards.

In a much earlier version of Access, you could download the MDB versions of the wizard MDE files. You could learn a lot by review the code in these. There was still a fair amount of code that wasn't made available.

Duane
Hook'D on Access
MS Access MVP

 

[kjv1611]

peuplier,

If you're reading this, has your question been answered? Do you need additional information?

--

"If to err is human, then I must be some kind of human!" -Me