how do i restrict the number of records in a table?

[donnie051280]

in my table Stock i only want 26 records at a certain point in time..
i created my table in access

thanks

 

[KenReay]

Hi

A few ways to do this

One simple method requiring no coding, declare a column, type number (integer), set its validation rule to >=1 and <=26, and index yes unique

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[TheAceMan1]

How are ya donnie051280 . . . . .

Which 26? Ramdom, Top, Bottom, Range . . . . . what?

Be more specific about this.

See Ya! . . . . . .

 

[mph1]

I think AceMan is correct. Which 26 do you want and to determine?? In my opinion, unless the amount of data (stock items) becomes extremely voluminous, I would not delete any items. It's good to maintain some type of history.

You could make a new col. in the table to indicate "not used" or something like that. In your form you could use this field to indicate such. Then create a query to illiminate what you don't want.

An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106