External report writer

[Guest]

I'm using an Access database and need to share it now with some of my staff.
They are computer illiterate - as a result are unfamiliar with Access query
and report design.

Are there any "easy to use" external report generators (that can work off of
the MDB file) which also simplify the query / report design?

Any suggestions are appreciated.

 

[Duane Hookom]

My opinion is there isn't any simpler or more flexible report writer than
the Access. There is a fairly flexible query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. Users
can select the fields they want to display as well as set sorting, grouping,
criteria,... Results are a couple clicks from sending to Excel, CSV, Word
table, html, Word Merge,...

 

[Guest]

Duane,

Thanks for the tip. I downloaded this applet from the
rogersaccesslibrary.com site but can't get it to work.

Two questions:

1- is there a way to "import" all the required objects in group to my Access
database, or do I need to copy/paste each one individually? This must be
very cumbersome if I wish to use your applet on multiple of my databases.

2- How do I provide a "reference" to the Microsoft DAO Object Library which
your "About DHQBF" indicates is required?

Thanks

Jim

 

[Duane Hookom]

1- Select File->Get External Data->Import and select all required objects
(table, forms,...). You can import many objects at once.
2- Open any module and select Tools->References and if the "Microsoft
DAO..." library isn't checked, scroll down to find and check it.