[AccessD] Limit number of records

Hi Susan,

This feels like kind of cheating...........I went into the main queries,
limited the number of records to the top 5, then saved each query, created
an mde and deployed the application using the developer extensions.

Worked great.  Now the application will only show 5 records.



Julie Reardon
PRO-SOFT of NY, Inc.
44 Public Square, Suite 5
Watertown, NY  13601
Phone:  315.785.0319
Fax:  315.785.0323
NYS IT Contract#CMT026A
NYS Certified Woman-Owned Business
www.pro-soft.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Thursday, August 23, 2007 2:05 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Limit number of records

Count(*) = totoalnumberofrecords???

Susan H.  


HI,

I know that I have in the past sent a demo out limiting the number of
records that can be input.

It seems that I have misplaced the code.............

I have autonumbers as key fields on a lot of the tables.

A validation rule would be a simple fix, but Autonumber fields do not have
validation rules.

Anyone have a suggestion?


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com