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  2100 
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******@pcdata sheet.com
"Debbiedo" <de**********@y ahoo.comwrote in message
news:11******** **************@ y80g2000hsf.goo glegroups.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.e mailaddresswrot e:
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...@pcdata sheet.com
"Debbiedo" <deb_dolit...@y ahoo.comwrote in message
news:11******** **************@ y80g2000hsf.goo glegroups.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******@pcdata sheet.com
"Debbiedo" <de**********@y ahoo.comwrote in message
news:11******** **************@ o5g2000hsb.goog legroups.com...
On May 4, 12:54 pm, "Steve" <s...@private.e mailaddresswrot e:
>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...@pcdat asheet.com
"Debbiedo" <deb_dolit...@y ahoo.comwrote in message
news:11******* *************** @y80g2000hsf.go oglegroups.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. emailaddresswro te:
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******@pcdat asheet.com
"Debbiedo" <de**********@y ahoo.comwrote in message
news:11******* *************** @y80g2000hsf.go oglegroups.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 such as "5",
"95", "50", or "<5" There is no "%" character stored in the database
just the number (and the "<" sign if there is one).
Problem...
|
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 deliverd and stored in tables -- deliverymaster,
deliverydetails
|
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 query. However, I
am struggling with putting these 2 queries together for a report that
looks like this:
PartNum TransDate Transaction Qty ...
|
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 terms I entered
displayed next to those entries? I would like to search with multiple
parameters (multiple search words) and have the results show me...
|
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 date picker combo for the start date and another for the stop date. I would like to display those 2 dates on the header of the access report I am...
| | |
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 table, opens the report, and closes the form. The code on the report is below.
I used this code on a similar report that also pulled its data...
|
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 is run again? This is causing
certain error problems.
1 Why does the code run for a print preview when the report already
exists?
2 What...
|
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 open the report. If I use the
|
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 from the form. In my table, I see 1, 2, 3 when I save a record. Good enough. Now, in my report, I wish to have checkboxes representing options a, b, and...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
