473,395 Members | 1,379 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Run AutoReport with Parms from VBA

Anybody have the syntax to run an Access AutoReport from a Macro or
VBA? Specifically, I want to specify the QUERY name of the data to be
used, and to select TABULAR format.
Nov 13 '05 #1
2 1711
Have a look here:
http://www.mvps.org/access/general/gen0028.htm

--
Shane Suebsahakarn
----
Head of IT
PAN Telecom
Tel: +44 (0) 870 757 7001

"dgadway" <ga****@yahoo.com> wrote in message
news:f5**************************@posting.google.c om...
Anybody have the syntax to run an Access AutoReport from a Macro or
VBA? Specifically, I want to specify the QUERY name of the data to be
used, and to select TABULAR format.

Nov 13 '05 #2
ga****@yahoo.com (dgadway) wrote in message news:<f5**************************@posting.google. com>...
Anybody have the syntax to run an Access AutoReport from a Macro or
VBA? Specifically, I want to specify the QUERY name of the data to be
used, and to select TABULAR format.


Somebody has pointed me to a web site
(http://www.mvps.org/access/general/gen0028.htm)which indicated usage
of the Application.Run acwztool.frui_entry, TableOrQueryName, acReport
command.

What is still not understood here is the following:

1. How to indicate that AUTOREPORT is to be used.
2. How to indicate TABULAR format is to be used.
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Don | last post by:
Will the following pass parms "Color" and "Contrast" to the PHP script? If so, how does one retrieve the parms within the script? http://xyz.com/script.php?Color=blue&Contrast=weak Thanks,...
2
by: dataguy | last post by:
Does anyone know if you can pass parms to the sysin when using DB2UNLOAD?
4
by: Angel | last post by:
I'm trying to call a DLL function that receives as parameter a user-defined structure created by the company that made the dll. When I call the function from my main form, I call...
2
by: VM | last post by:
I have a Windows form that may be called with two parameters or three parameters (depending on who's invoking the form). The form was programmed so it received three parameters. How can I create an...
6
by: Paul M | last post by:
Hi All, I'm currently writing a z/OS DB2 Stored Proc in C, using an example from the IBM Stored Procedure guide (SG24-7083-00). The database calls to read and update the database work...
1
by: Dave | last post by:
Given a URL of http://Somthing/Somthing.asp?parm1=val1&parm2=val2&parm3=val3 I'm trying to create an expression that gives me: parm1=val1 parm2=val2 parm3=val3 As either distinct group...
5
by: Phil Hellmuth | last post by:
I hope this is the correct forum for this issue. I'm trying to call a SQL stored procedure using parameters, but am running into problems. Here's pertinent SP code: CREATE PROCEDURE...
2
by: =?Utf-8?B?cm9kY2hhcg==?= | last post by:
hey all, you know how you can pass parms thru the url (like http://my.site.com/test.aspx?id=1 is there a way to encrypt the id number? thanks, rodchar
1
by: =?Utf-8?B?cm9kY2hhcg==?= | last post by:
hey all, what's the best way to turn my csv string into sql parms? the sql parms can vary in count. thanks, rodchar
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.