I am wondering if I can create an application that when you click on
it (say a shortcut), it opens a report parameter box to query a set of
parameters, and then opens the report based on these selections
without actually opening the access database window.
In other words, can I have the end user only see (i.e. have access to)
the report in the print preview mode?
If so, any suggestions as to how to go about this?
Many thanks
Debbie
5  2092 
I forgot to say I was using Access 2003 for XP
Use an Autoexec macro that opens the report when the database is opened.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications re******@pcdatasheet.com
"Debbiedo" <de**********@yahoo.comwrote in message
news:11**********************@y80g2000hsf.googlegr oups.com...
>I am wondering if I can create an application that when you click on
it (say a shortcut), it opens a report parameter box to query a set of
parameters, and then opens the report based on these selections
without actually opening the access database window.
In other words, can I have the end user only see (i.e. have access to)
the report in the print preview mode?
If so, any suggestions as to how to go about this?
Many thanks
Debbie
On May 4, 12:54 pm, "Steve" <s...@private.emailaddresswrote:
Use an Autoexec macro that opens the report when the database is opened.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resou...@pcdatasheet.com
"Debbiedo" <deb_dolit...@yahoo.comwrote in message
news:11**********************@y80g2000hsf.googlegr oups.com...
I am wondering if I can create an application that when you click on
it (say a shortcut), it opens a report parameter box to query a set of
parameters, and then opens the report based on these selections
without actually opening the access database window.
In other words, can I have the end user only see (i.e. have access to)
the report in the print preview mode?
If so, any suggestions as to how to go about this?
Many thanks
Debbie- Hide quoted text -
- Show quoted text -
Can I still get to the DB to make changes? I want to limit some of the
users to just the report for previewing and printing, others can have
access to the DB for editing needs.
Hold down the Shift Key to open the database in normal fashion.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications re******@pcdatasheet.com
"Debbiedo" <de**********@yahoo.comwrote in message
news:11**********************@o5g2000hsb.googlegro ups.com...
On May 4, 12:54 pm, "Steve" <s...@private.emailaddresswrote:
>Use an Autoexec macro that opens the report when the database is opened.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resou...@pcdatasheet.com
"Debbiedo" <deb_dolit...@yahoo.comwrote in message
news:11**********************@y80g2000hsf.googleg roups.com...
>I am wondering if I can create an application that when you click on
it (say a shortcut), it opens a report parameter box to query a set of
parameters, and then opens the report based on these selections
without actually opening the access database window.
In other words, can I have the end user only see (i.e. have access to)
the report in the print preview mode?
If so, any suggestions as to how to go about this?
Many thanks
Debbie- Hide quoted text -
- Show quoted text -
Can I still get to the DB to make changes? I want to limit some of the
users to just the report for previewing and printing, others can have
access to the DB for editing needs.
On Fri, 04 May 2007 19:54:47 GMT, "Steve" <so***@private.emailaddresswrote:
Once the report is opened, is there any thing that prevents minimizing or
closing the report window and gaining access to the database program?
Chuck
--
>Use an Autoexec macro that opens the report when the database is opened.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com
"Debbiedo" <de**********@yahoo.comwrote in message
news:11**********************@y80g2000hsf.googleg roups.com...
>>I am wondering if I can create an application that when you click on
it (say a shortcut), it opens a report parameter box to query a set of
parameters, and then opens the report based on these selections
without actually opening the access database window.
In other words, can I have the end user only see (i.e. have access to)
the report in the print preview mode?
If so, any suggestions as to how to go about this?
Many thanks
Debbie
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: J.D. Buehls |
last post by:
I am displaying some values on a report. I am opening the .asp page
with a
Response.ContentType = "application/msword" and these particular
values appear in a table. One column shows percentages...
|
by: prabhukalyan |
last post by:
Hi all,
I am not so good in queries. here is my problem
2 tables to store the received items (fabric)-- inwardmaster,
inwarddetails
and after some processing (Dyeing)
the items were...
|
by: rxfrenc |
last post by:
Hello,
I am trying to create a report that displays balance impacting
inventory transactions. I can easily pull the current on-hand balance
in one query and the transaction history in another...
|
by: Reef81 |
last post by:
Does anyone know a way to have the search parameters displayed in the
query or report? For example, if I set up a parameter to search all
entries in my table, is there a way to have the search...
|
by: keithsimpson3973 |
last post by:
Does anyone know if it is possible to display the value of a date picker control on a vb6 form that the user selected on an access report? I am using vb6 to display a report selection and it has a...
|
by: martin DH |
last post by:
Hello,
I have a report that I open that pull its data from a form that builds a where string. Opening the report first opens the form, where I enter criteria, and then pulls matching records from a...
|
by: Gord |
last post by:
When I open a certain report, it runs some code that generates the records
that will be displayed in that report. This works fine. When I go to print
preview the report it appears that the code...
|
by: Naushad |
last post by:
Hi All,
I am trying to open the report conditionally from the dialogue box
form. In the form there are three field.
cboEmployees
StartDate
EndDate
I have used these field in criteria to...
|
by: tuxalot |
last post by:
New to Access so please go easy. I have a form with an option group. I've wish to have it's result display on my report.
options a, b, c
I've created a field in my table to accept the data...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
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...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
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
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |
