Storing a single number without a table?

[efandango]

I have a series of records that I need to limit the displaying of, depending
on a single fixed number that the user enters. Think of it as a progress
number; in other words, record 419 is how far the user has progressed,
therefore only show records before this number.

I want to store a single, semi-permanent number that can be used in a: 'Show
these records if records <= stored number' scenario. I want the number to be
the same for all records and to be retained when the the database is closed
and reopened, and only changes when the user decides to alter it.

How can I do this?

 

[Allen Browne]

You can create a custom property on the table if you really want to do so.
This old article illustrates how:
Custom Database Properties
at:
http://allenbrowne.com/ser-09.html

The example creates a property on the Database object itself, whereas it
sounds like you want to create it on:
db.TableDefs("Table1")

I'm not sure this is a good idea for the example you give though. Seems like
you could get the number of records in Table1 with:
DCount("*", "Table1")
or the maximum ID value as:
DMax("ID", "Table1")