Calling Access Wizards

[dpimental]

How can I call part or whole of an access wizard.

For example, how do I call the AutoForm Columnar wizard?
How do I call the AutoForm Tabular wizard?

ECT.

David I'm Your Huckleberry!

 

[Steve101]

Whenever you create a new Table, Query, Form or Report object, Access presents a dialogue box, and amonst the choices, is always one or more options to use a wizard to proceed.

Try it out. Open a new or existing database, display the forms window and click on the new button. You will see that the AutoForm: Columnar and AutoForm: Tabular options present themselves, along with other form creation alternatives.
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[FancyPrairie]

Here's some code I use to create forms programmtically:

ii = auto_Entry("NameOfYourTableOrQuery", intFormView, acForm) 'intFormView: 1=Columnar; 2=Tabular; 3=Datasheet

strActiveForm = Screen.ActiveForm.Name

DoCmd.Close acForm, strActiveForm, acSaveYes

Don't have time to explain. But this may give you a start.

 

[dpimental]

Thanks FancyPrairy. You're not half-bad.
Which, I think linguistically (and since I have a degree in linguistics, I should know) either means you are totally bad or totally good?

I'm not sure what the implications are in clasic or inductive logic. That's not my area of expertise?!

Anyways, to the point.
I knew there was a way to call out the auto form wizard.
But when I try your code, access says it doesn't recognize the sub procedure or function, do I need to reference the specific library?

David I'm Your Huckleberry!

 

[FancyPrairie]

Sorry I don't have time to investigate this further, at this time (meeting to go to). It's some code I put together several years ago. However, I belive the file you need to reference is one of the following:

c:\Program Files\Microsoft Office\Office\1033\Acwzlib.mde
c:\Program Files\Microsoft Office\Office\1033\Acwztool.mde
c:\Program Files\Microsoft Office\Office\1033\Acwzmain.mde

If this doesn't work, let me know.

 

[FancyPrairie]

By the way, the list box wizard is called like this:

Application.Run "acwzmain.lst_Entry", "YourListBoxName", "YourChildName"

The following worked for Access 95, but I couldn't get it to work for Access 2000.

var = Lst_Entry("YourListBoxName", "YourChildName&quot

Note that the Application.Run command may work for creating forms (your original question)

 

[dpimental]

FancyPrairy, it was the Acwzmain.mde file to reference.

A couple more questions if you don't mind.

Is there any way to specify styles?

Did you every develop anything for reports?

David I'm Your Huckleberry!

 

[FancyPrairie]

Don't know if there is a way to specify styles.

Reports are done the same way as forms; but instead of "acForm" it would be "acReport". For example,

ii = auto_Entry("NameOfYourTableOrQuery", intFormView, acReport) 'intFormView: 1=Columnar; 2=Tabular;

 

[Steve101]

David,
Sorry about my initial post; I thought that it was a somewhat basic question from a novice; did'nt mean to insult anyone's intelligence.
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(dont cut corners or you'll go round in circles)

 

[dpimental]

Steve, no problem.

FancyPrairy, any documentation on what's in the various wizards (i.e. functions, methods, ect?)

David I'm Your Huckleberry!

 

[FancyPrairie]

I had to do a little digging thru my documentation to find some of the web sites that have this info. Here is a start:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q148506&

 

[dpimental]

Thanks for the info FancyPrairy.

David I'm Your Huckleberry!