Paging Problem
Jan 31, 2005
Hi.
I hava Form where a subform exists. The subform is expands or stays the same depending on
the products on the subform.
Therefore the Form it may be one page or could be 2 pages depending the subform list. Also I
have some details at the Page Footer in order every page in my Form to include those details.
But i can tot manage MA to make 2 pages or 1 page depending the subform list, when i print out the record.
Normally i get data in top of the next record and i Do not know how to declare that i am still in the same record.
I would like automatically to set the borders for the pages if is 1 or 2 even 3 pages..
I hope u understand what i am trying to explain.Thank you.
View Replies
Mar 2, 2007
Does anyone have any samples or links to places that can help me. I created a basic list of items in a Access database, but there is so many I need to break them up. Any help is appreciated.
View 1 Replies
View Related
Oct 23, 2004
I was just wondering if anyone can help me?
I have successfully paged through a recordset on my page using the .recordCount, etc. methods, the only thing is I have 2 independent recordsets looping on the page, which when there was not paging involved this worked fine, however now I need to span the results of BOTH of these across pages, I just cannot seem to figure out how! I have one set of records paging fine, but the other either messes the page up, or shows on the first page of results and no more of the other recordset, etc.... so yeah that is basically the problem I am hitting, so I was just wondering is there any examples or ways you could tell me to do this??
Any help that can be offerered would be very much appreciated ).
View 3 Replies
View Related
Mar 5, 2013
I have an Inventory database with 2 tables. Here is a simplified version of both tables:
First Table is Inventory:
Fields are
ID
Description
PackSize
PackCost
Second table is PriceHistory:
Fields are
ID
InventoryID
Date
PackCost
Fields are joined, one to many (one inventory record can have many prices in its history). ID in the inventory table is joined to InventoryID in the PriceHistory table.
The problem comes when I am browsing records in FORM VIEW of the inventory table:
As I page through the inventory records, I often see the same record multiple times (once for each entry in the pricehistory table).
For example, if the item POTATOES in the Inventory table has had it's price updated 3 times (3 entries in the PriceHistory) table, then I see the Potatoes record 3 times as I am browsing.
I only want to see this record once (with the latest price) when I am browsing the Inventory table in form view.
View 1 Replies
View Related