Hi, I'm new to Access and I am using the 2007 version. I'm trying to create a report that will be generated from a table and/or form. I have an Orders table and an OrderDetails table. The Orders(Parent) table contains an ID, Vendor, Various Dates while the OrderDetails(Ch ild) contains the actual products ordered with the ID, OrderID(Linked from Orders table), Manufacturer, CatalogNo, Price, Quantiy, etc.
The report I have now is grouped by OrderID but unfortunately it shows all the records with all the OrderIDs from my OrderDetails table. I really only want a single OrderID and the purchases related to that OrderID to show. How can I accomplish this? Will I need to create a message box that asks for an OrderID and then use that in some type of query?
Also I want to be able to generate the same(or similar) report from my order form. The main form uses the Orders table while a subform uses the OrderDetails table. There is an OrderID field and I've added a button that opens my template report. I just can't figure out how to get the report to show the particular records with the OrderID in the form.
I would appreciate suggestions, examples, or links.
1  1064  nico5038 3,080
Recognized Expert Specialist
Make sure the subreport is located in the "Details" section of the report.
When that's the case, single-click the subreport and open the properties.
Under the Data tab there are two "Linkage" properties that should hold the ID field the subreport needs to be linked with. Assuming your tblOrderDetails also has an OrderID, the same fieldname should be in both Linkage properties.
Clear ?
Nic;o)
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: longtim |
last post by:
I have been having endless difficulty creating reports/queries that
set any relevent parameters from controls in forms.
I am creating an application under access 2003 but will target access
2000. The access file is in access 2000 format.
I have a form that will hold the relevent parameters for the
query/report that reports the statistics for all job records that
match a certain criteria. These are:
- A Customer Name.
|
by: Mike |
last post by:
I am writing a .NET application in C# that uses Crystal
Reports. I want the crystal reports to grab information
from a database no matter where the database is
located. To do this, I want to create an ODBC connection
to the database at runtime in order for the report to
grab data from the database. Does anyone have a code
snippet that shows how to do this? Thank you very much
for your reply.
Mike
|
by: Joe_Black |
last post by:
Hi all,
I want to create an MDI app that allows reporting on XML data files
downloaded from the equipment that we manufacture, this MDI app will
have several default reports but due to the nature of the data different
people will want to see it in different ways.
What I would like to do is have several standard reports/graphing MDI
Children that come as standard, then allow the user to apply a plugin
that will allow them to view their...
|
by: Przemo |
last post by:
Hi,
I have an ASP.NET 2.0 application. I need to generate some documents
(reports) like invoices, orders, etc. Users need them to preview and print.
Which of methods is the best for doing it:
1. Creating HTML page containing data (problems with rendering and
unexpected behavior when dynamic text is too long),
2. Creating invoice as a XML and then transforming it into ready document
using XSLT
3. Rendering document as a GIF just writing...
|
by: erick-flores |
last post by:
Hello all
I am creating an Expense Report. There are to types of expenses:
Company expenses and Reimb Expeneses. The company expenses is under
"Expense Details Co" table and Reimb Expenses is under "Expense
Details" table. So I am creating this final report to see both type of
expenses separately but I CANT.
I got this report design from a website, but it only came with one
"Expense Details" table, so I add the Expense Details Co. The...
| | |
by: Argonath |
last post by:
Hi,
I'm afraid this will no doubt horrendously basic as I'm a complete newbie to VB and have dived in without learning to do much... Start in the deep end and all.
So if anyone could help, I'd appreciate it;
I've got this bit of code and I couldn't for the life of me tell you why it doesn't work, if anyone else can I'd appreciate it!
Cheers
|
by: Andy Baker |
last post by:
I have a utility that captures a signature on a handheld device and stores
it as as string containing a series of points. I want to recreate this
signature as a bmp file using VB.NET code. To do this, I have created a
bitmap object using the following code
Dim bmpSignature as Bitmap
bmpSignature = New BitMap(240, 80)
and I then use the graphics object to replot the points on the new bitmap,
and save it using...
|
by: BK |
last post by:
A little rant first...
I have 15+ years experience with developing software. Why is it that
everything related to creating reports in .NET seems so convoluted to
me? I don't want to use Crystal. I've worked with SQL Reporting
Services and I'm not impressed. I've spent time looking at the new
ReportViewer control and I'm not impressed. The ReportViewer seemed
promising, but it is just so counterintuitive to me. What am I missing...
|
by: sklett |
last post by:
I've developed an ERP application that we use internally and works quite
well. I receiving more and more requests from users to print various
transactions, order forms, search results, etc. I haven't decided what the
best way to do this is because I don't have much experience with generating
printable forms.
Early on I knew one of my modules would need to print a clear report so I
used the open source SharpPDF library to generate the...
|
by: jai83 |
last post by:
hi,
How can Stored procedures be used in oracle reports for creating reports instead of SQL queries?
Thank you.
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
