Creating Auroreport Tabular

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

I've set up a new database and there's lot of queries being run by the user,
and I don't want to have to set up a report for each of them, so i've put an
Autoreport button in the menu bar. This works fine, BUT it's always
defaulting to Columnar and i need it to be tabular. Is there some paramater's
I can set to make it automatically use Tabular Autoreporting?
 
Vantastic said:
Hi all

I've set up a new database and there's lot of queries being run by the user,
and I don't want to have to set up a report for each of them, so i've put an
Autoreport button in the menu bar. This works fine, BUT it's always
defaulting to Columnar and i need it to be tabular. Is there some paramater's
I can set to make it automatically use Tabular Autoreporting?
Click to expand...
 
Depending on your need for you users, you might want to use the query by
form applet from
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
solution has several forms, a couple tables, etc that you can import into
your mdb. Then just create a few master datasource queries that combine your
tables and hides the tables.

Users can then create and modify "query/reports" that are a couple clicks
from sending to Print, CSV, Word Table, Word Merge, Excel, HTML, Graph,...
 
How do you put an Autoreport button in the menu bar?

Right click the toolbar/menu bar and click Customize... then go into
Commands and just drag and drop the functions you want there...

The AutoReport is found under "Insert" in the commands section.
 
Hi Dwayne

The users here are idiots, to put it bluntly :) I don't want to give them
any options on printing reports or anything like that... Perhaps i'll just
have to have the query in a subform, with the mainform containing a button to
print a report, which i'll have to set up for each query...

Ah well, it was worth a shot :) Thanks for your help!
--

---
The glass is neither half empty nor half full. It is simply twice the size
it needs to be.


Duane Hookom said:
Depending on your need for you users, you might want to use the query by
form applet from
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
solution has several forms, a couple tables, etc that you can import into
your mdb. Then just create a few master datasource queries that combine your
tables and hides the tables.

Users can then create and modify "query/reports" that are a couple clicks
from sending to Print, CSV, Word Table, Word Merge, Excel, HTML, Graph,...
Click to expand...
 
Back
Top