473,394 Members | 1,658 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,394 software developers and data experts.

Create report from form?

Hi all

I need to create a report from a form. What I'm trying to do is create a
system where I can examine data for a single client on a form then print a
report on only that client - Any ideas??

Thank in advance

Dan
Nov 13 '05 #1
2 6744

Dan Kean wrote:
Hi all

I need to create a report from a form. What I'm trying to do is create a system where I can examine data for a single client on a form then print a report on only that client - Any ideas??

Thank in advance

Dan


create the report without filters and then pass the primary key of the
client in question in the Open event of the report as a WHERE clause.
See DoCmd.OpenReport in the help.

Nov 13 '05 #2
sorted many thanx

<pi********@hotmail.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

Dan Kean wrote:
Hi all

I need to create a report from a form. What I'm trying to do is

create a
system where I can examine data for a single client on a form then

print a
report on only that client - Any ideas??

Thank in advance

Dan


create the report without filters and then pass the primary key of the
client in question in the Open event of the report as a WHERE clause.
See DoCmd.OpenReport in the help.

Nov 13 '05 #3

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

Similar topics

1
by: Viktor Lakics | last post by:
Dear All, I designed carefully a reasonably complicated report and a form. I use this form for data entry and also for searching by setting various filters on that form. What I would like to...
1
by: ray | last post by:
I am trying to create an icon so that when someone reachs the end of a report page they can preview and print. Does anyone have any suggestions aboutte best way to do this. I can crate the...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
9
by: badboybrown | last post by:
Hello, Is it possible to step through the "Create MDE" process and see what is causing Access to crash? I tried, unsuccessfully, many times to create an MDE from my database. But, randomly, I...
6
by: fieldja | last post by:
I have a form called OwnerForm. It contains a combo box called Owner. The combo box looks up names from a table called OwnerName. It contains fields called OwnerID and Owner. I also have a main...
5
by: Linds | last post by:
I have a report within my access database that I would like to have a shortcut on my desktop that could bring up that report. In other words, now I have to double click on the database, then go...
1
by: Joyfully | last post by:
I and a new user of MS Access 2003, and I need help with a report created from a form. I created a form that data is inputed weekly. I created a report to display this data in putting only the...
3
by: creative1 | last post by:
Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however,...
8
by: Paul H | last post by:
I want to base a form on a crosstab query. The query shows statistics for a user defined period. The column headings will look something like this: ClientID Month01 Month02 Month03 etc.. ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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: 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...
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
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
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
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.