How do I overlay variable items on an imported image used for a re

[drewship]

Thanks Duane. I have a better understanding now which will hopefully allow me
to work this out.

Thanks again!!
Andrew

The query I suggested should add a 1 to a column in the first 5 records and 2
in following records. You can use a text box on your report with a control
source of =1 as the Link Master to filter a subreport to only those records
with a 1 in the column.

--
Duane Hookom
Microsoft Access MVP

I do need to divide them into 2 groups. I do not understand all of your code
or how the text boxes with =1 and =2 work. The report image contains both
page 1 and page 2 all contained within the detail section of the main report.
It looks like your code will pick the first 5 records and identify them with
a 1, and all the rest are identified with a 2. I do not know how to use the
text boxes as you indicated to display the subreports on each page of the
main report.

I do have a [Requesition Number] field in the Orders table which is what is
confusing. I thought I understood what the code was doing. I will continue to
work on these issues and hopefully can figure them out.

Thanks for your help!!
Andrew

I assumed you needed to divide your records into two groups. If the query I
suggested doesn't work then you need to fix it. Is there a [Requesition
Number] field in your Orders table?

--
Duane Hookom
Microsoft Access MVP


:

Duane,

I have tried linking the Master and Child fields but am not clear on " Then
you could possibly use the Link Master/Child with a couple text boxes on the
main report with control sources of
= 1
= 2"

I am using the Order Management Database I downloaded from Microsoft as the
template for my database. The query below will display all records from the
[Order Details] table.


SELECT [Order Details].*, CCur(Nz([Quantity],0)*[UnitPrice]) AS [Extended
Price]
FROM [Order Details];

When I try to modify your code below, popups appear asking for Requisition
number before the main form will even open and the data on the report shows
ERROR.

SELECT IIf([Requisition Number] In (SELECT TOP 5 [Requisition Number] FROM
ORDERS O ORDER BY
[Requisition Number]),1,2) AS GroupNum, Orders.*
FROM Orders;

Can you explain what the different parts of your code are doing and how do
perform the Master/Child links?

Thanks!!
Andrew

:

Creating a subreport from a subform is automated from the database window. It
shouldn't be too difficult to create a subreport.

Did you try to use the link master/child as I suggested? This is used to
filter the records displayed in the subreport based on values from the main
report.

--
Duane Hookom
Microsoft Access MVP


:

Duane,

I created a subreport like you recommended. I created it from the Order
Details Extended table which contains the required information...at least I
thought this would work, but it displays every record in the table instead of
only the selected data.

The data that the subreport needs to display is from a subform. I select a
Company or OrderNumber from the main form and the associated records are
displayed on the subform. I then need the subform data to be displayed on the
subreport. I tried to create a subreport from the subform but could not see
how to do this. I also tried to tie the subreport cell recordsources to the
form cells hoping to display the data. This only displayed the first record
multiple times in the subreport.

Any ideas on how to create a subreport based on a subform, or how to link a
subreport to a subform in a similar manner that a subform and mainform are
linked?

Thanks!!

:

I'm not sure how your report is layed out but you could add a calculated
column in the subreport record source that identifies the first 5 records.
For instance with the Orders table in Northwind:

SELECT IIf([OrderID] In (SELECT TOP 5 OrderID FROM ORDERS O ORDER BY
OrderID),1,2) AS GroupNum, Orders.*
FROM Orders

Then you could possibly use the Link Master/Child with a couple text boxes
on the main report with control sources of
= 1
= 2
--
Duane Hookom
Microsoft Access MVP


:

Thanks for replying Duane. So you are saying I should create a regular
subreport of the items and prices, then overlay this on the report image?
That sounds like it would work.

I have another question then. The report may have multiple pages depending
on the number of items listed. The first page of the main report only has
room for 5 items. After that, a continuation page is used which can list 20
or 30 items. If 10 items are ordered, how do I tell the subreport to place
the first 5 items on the main report page and the last 5 items on the
continuation page?

Thanks!!

:

You may need to use a subreport to display the details.
--
Duane Hookom
Microsoft Access MVP


:

Hello all.

I have imported the picture of a form we use and I need to overlay report
data on it. I have figured out how to overlay data with a single value like
the record number or authorized signature listed in the record. What I need
is to have multiple items overlay from top to bottom in a specific section.
For example, if the customer ordered an Apple, Orange, Pear, how do I take
these items from the associated record and display them and their associated
cost like:

Apple $1.00

Orange $.75

Pear $$.50


If I associate the Item to three specific locations on the form image, I can
only select ItemName from the record since that is where the items are
stored. Consequently, the report prints:

Apple $1.00

Apple $1.00

Apple $1.00

How can I sequence through the items in a table to display each item in the
table?

 

[drewship]

Thank you for replying Larry.

I initially thought that creating a report to look like my paper version
would be the way to go, but I do not really understand how they are set up
and have been hesitant to try. It looked like I could do the same thing
overlaying the data on an image which seems easier...but only if the data is
confined to a single entry.

Although I will continue to pursue the overlay and subreports using Duane's
suggestions for the short term, I will probably also try to create the form
using Access reports for flexibility in the long term.

Can you recommend resources on Access report writing?

Thanks again!!
Andrew

 

[Keith Wilby]

PS I guess grammar is not one of your strong suits!!!!

It certainly isn't yours Captain Redundant Exclamation Mark.

 

[Keith Wilby]

And you become more of a

You're a particularly nasty piece of work aren't you? Not only that, you're
too stupid to realise that your potential "clients" (or victims) read such
nastiness and give you the wide berth you deserve. Your feet must be more
or less completely shot away by now.