|
| |
|
|
MCD
Posts: 650
Joined: 3/19/2002
From: Al USA
Status: offline
 |
Limiting Records Per Page - 6/24/2008 7:29:36
Is there a way to limit the number of records per page when gathering data from an Access database?
_____________________________
Author of " How To Build A Website With Duct Tape"
|
|
|
|
swoosh
Posts: 1437
Joined: 5/18/2002
From: Beaver Falls, PA
Status: offline
|
RE: Limiting Records Per Page - 6/24/2008 8:11:07
Take a look at this thread http://www.frontpagewebmaster.com/m-388635/tm.htm Hope it helps
_____________________________
Swoooosh
Just Do It!
| |
|
|
|
MCD
Posts: 650
Joined: 3/19/2002
From: Al USA
Status: offline
|
RE: Limiting Records Per Page - 6/24/2008 8:46:22
I had read that thread already. I do not see this option when working with an Access database.
_____________________________
Author of " How To Build A Website With Duct Tape"
| |
|
|
|
swoosh
Posts: 1437
Joined: 5/18/2002
From: Beaver Falls, PA
Status: offline
|
RE: Limiting Records Per Page - 6/24/2008 8:51:44
Working with an Access Database shouldn't matter. Do you have Paging Enabled? if not, you will have to do so to state how many results per page you want.
_____________________________
Swoooosh
Just Do It!
| |
|
|
|
MCD
Posts: 650
Joined: 3/19/2002
From: Al USA
Status: offline
|
RE: Limiting Records Per Page - 6/24/2008 9:10:42
I know I'm looking for Enable Paging but I cannot find it. The EW help is no help. I've gone through every step again and somewhere or somehow I'm still missing it.
_____________________________
Author of " How To Build A Website With Duct Tape"
| |
|
|
|
swoosh
Posts: 1437
Joined: 5/18/2002
From: Beaver Falls, PA
Status: offline
|
RE: Limiting Records Per Page - 6/24/2008 9:14:28
when you click on your data results control in design view, you should see a little arrow button in the upper right hand corner of the results (you may have to position your mouse there). Click the arrow and you will see some options. One of them will be Enable Paging
_____________________________
Swoooosh
Just Do It!
| |
|
|
|
MCD
Posts: 650
Joined: 3/19/2002
From: Al USA
Status: offline
|
RE: Limiting Records Per Page - 6/24/2008 9:24:48
That is where I thought it should be. I only have the following:
Auto Format
Choose Data Source
Configure Data Source
Refresh Schema
Property Builder
Edit Templates
_____________________________
Author of " How To Build A Website With Duct Tape"
| |
|
|
|
swoosh
Posts: 1437
Joined: 5/18/2002
From: Beaver Falls, PA
Status: offline
|
RE: Limiting Records Per Page - 6/24/2008 9:37:44
Select the Control and view the property sheet window. You should see an area for "Paging".........make sure it is set to True
_____________________________
Swoooosh
Just Do It!
| |
|
|
|
MCD
Posts: 650
Joined: 3/19/2002
From: Al USA
Status: offline
|
RE: Limiting Records Per Page - 6/24/2008 10:19:01
Still nothing. It's hard to believe I'm missing this. Even the small amount of code show nothing that refers to pages or records. This should be a simple matter but I'm stumped.
You were referring to Property Builder wasn't you?
_____________________________
Author of " How To Build A Website With Duct Tape"
| |
|
|
|
swoosh
Posts: 1437
Joined: 5/18/2002
From: Beaver Falls, PA
Status: offline
|
RE: Limiting Records Per Page - 6/24/2008 10:26:20
Property Builder?......No. I was referring to what is in the thread mentioned earlier.
http://www.frontpagewebmaster.com/m-388635/tm.htm
_____________________________
Swoooosh
Just Do It!
| |
|
|
|
swoosh
Posts: 1437
Joined: 5/18/2002
From: Beaver Falls, PA
Status: offline
|
RE: Limiting Records Per Page - 6/24/2008 10:34:53
Open up the Tag Property Window.......I believe it should be on that one. Not sitting with a machine with EW at the moment
_____________________________
Swoooosh
Just Do It!
| |
|
|
|
MCD
Posts: 650
Joined: 3/19/2002
From: Al USA
Status: offline
|
RE: Limiting Records Per Page - 6/24/2008 11:34:11
Here was the problem Swoosh. You can Enable Paging in Gridview but you do not get that option in DataList. Sorry for the troubles but thanks for your help.
_____________________________
Author of " How To Build A Website With Duct Tape"
| |
|
|
|
swoosh
Posts: 1437
Joined: 5/18/2002
From: Beaver Falls, PA
Status: offline
|
RE: Limiting Records Per Page - 6/24/2008 11:39:42
Ahhhhhh okay, EW doesn't offer Paging for Data List, although it can be done. I hope Grid View will serve well for what your after.
_____________________________
Swoooosh
Just Do It!
| |
|
|
|
MCD
Posts: 650
Joined: 3/19/2002
From: Al USA
Status: offline
|
RE: Limiting Records Per Page - 6/24/2008 12:04:29
I was mainly getting used to the .NET controls. I usually need a datalist because I use some databases with descriptions. I wish DataList offered paging.
_____________________________
Author of " How To Build A Website With Duct Tape"
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
