having only 1 record in a table

[Greg]

I'm creating a table with multiple fields to use for calculations in
other forms and to easily change the calculation values as needed.

In the table i only want 1 record to be created; but later on maybe 5
at the most for calculating values for additional forms i create. is
there another way to do besides limiting the primary key number to 1
and the default value as 1. i would like a message to appear before
they can create another record as to afterwards like the above way
does.

If more information is needed please ask.

Many thanks in advance

Greg

 

[Michael]

Hi Greg,

My name is Michael Noto. Thank you for using the Microsoft Newsgroups.

Restricting the PK to 1 is the only way I can think of keeping only the one
record. In a form, you can use the form properties to mot allow adding
records or code in the lost focus event to try to save the record which
will fail on any record except the first record but in the table itself we
will not receive message until the record save is attempted. For example, a
user entering data in all fields before attempting to move to a new record
will not get the message until after all data is entered.


I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Regards,
Michael Noto
Microsoft IIS Support

This posting is provided 'AS IS' with no warranties, and confers no rights.

Please do not send email directly to this alias. This is our online account
name for newsgroup participation only.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp

From: Greg <[email protected]>
Subject: having only 1 record in a table
Date: Fri, 16 Jan 2004 18:28:58 -0500
Newsgroups: microsoft.public.access.tablesdbdesign

I'm creating a table with multiple fields to use for calculations in
other forms and to easily change the calculation values as needed.

In the table i only want 1 record to be created; but later on maybe 5
at the most for calculating values for additional forms i create. is
there another way to do besides limiting the primary key number to 1
and the default value as 1. i would like a message to appear before
they can create another record as to afterwards like the above way
does.

If more information is needed please ask.

Many thanks in advance

Greg