Using acwzmain wizard for "dynamic report"

[handlebarry]

I can't find the module name .auto_entry under acwzmain Could it possibly be called something else in access 2000?

Also if anyone has an example of code using this wizard it would be helpful.

thanks

 

[PaulBricker]

I couldn't find any module named auto_main in my .mde file either, but the code in this post by FancyPrairie worked for me.


thread703-967300

Paul

 

[handlebarry]

thanks

could you show me the code in which you used it?

 

[PaulBricker]

I just ran it in the click event for a button.

Private Sub Command5_Click()

Application.Run "acwzmain.auto_entry", "YourTableOrQuery", 1, 3

End Sub

Paul

 

[handlebarry]

exactly what I did but I get an error,

Procedure declaration does not match......

guess I'll play around with it a bit - are you using access 2000?

 

[PaulBricker]

Yes, I'm using Access 2000. What declarations do you show at the top of your VBA module? Usually you will see
Option Compare Database
Option Explicit

If you show the Option Explicit, get rid of that line and just leave
Option Compare Database

Let me know how that goes.

Paul

 

[handlebarry]

Option explicit is not there (just Option Compare Database)

ta
barry

 

[handlebarry]

these are the two methods I've been trying to use - are there any glaring mistakes?


Private Sub Command29_Click()

Application.Run "acwzmain.auto_entry", "tblproperty", 1, 3

End Sub

and......

Public Function cmdMakeNewReport_Click()
Dim MyReport As Report
Set MyReport = CreateReport()
MyReport.RecordSource = "tblproperty"
'MyReport.Section(0).Property_code

End Function

 

[PaulBricker]

barry, let's check your references. Open a module, new or existing and on the menu bar go to Tools...References and tell me which libraries have a check mark in the box. It may be you are missing a library.

Paul

 

[handlebarry]

ok had a look....

Visual Basic for Applications
MS Access 9.0 object library
OLE Automation
MS ActiveX Data Objects 2.1 library

are the only 4 checked

barry

 

[PaulBricker]

OK, lets add a couple. Find these two and check the box next to them and see what happens.

Microsoft DAO 3.6 Object Library
Microsoft Visual Basic for Applications Extensibility 3.5

Let me know how it goes. If this doesn't help, you may want to think about reinstalling Access.


Paul

 

[handlebarry]

added both of those and no change
also found a reference called acwzmain and added that - still no change

not able to re-install access where I work

thanks for your help though, appreciate it

 

[PaulBricker]

Sorry Barry. If I run across anything, I'll post it here. Good luck.

Paul

 

[handlebarry]

it's now working!
The Public Function cmdMakeNewReport was somehow effecting it because once I removed that it worked

thanks for the help paul, seeya

 

[PaulBricker]

Amazing. Glad you got it.

Paul

 

[handlebarry]

hi again,

i've been searching thru the acwzmain arguments trying to find an export to file option. Is this possible? Do you know what argument should be used?

thanks
barry

 

[PaulBricker]

I don't think there are any. You might look into the OutPutTo method and see if that helps.

Paul

 

[dhookom]

If you objective is to allow users to select fields, set order, create criteria, maybe group, save definitions, and output to almost anything (Word, Print, Excel, HTML, Graph, CSV, Merge, Form Letter) then you should take a look at

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='DH Query By Form'.

You can easily set this up so "report/query" definitions are saved in tables in the Back-End mdb. I would never want users to create reports in an application that gets shared. I'm not sure how you would roll new versions of a front-end out to users without smucking their individual report objects.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[handlebarry]

hi duane - thankyou for your imput having a look at your database now. Not sure is my skills are good enough to understand how it works but will give it a go.

What I'm doing (or trying to do) is allow users to pick what fields they want in one off reports using check boxes. The database is relatively small and static, also in the reports there will be no criteria such as dates or users, so theoretically it should be very straightforward.

thanks and say merry christmas to you're grandson for me

 

[dhookom]

The QBF can be implemented by importing the tables, forms, and report from the demo mdb. Then create one or more queries with names that begin with "<" like "<Employee Info>" or "<Sales Details>". There are instructions on the first main form in the applet.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]