1 record table

Sorry Joseph, no comprendae.
Gerry
"Joseph Meehan" wrote in message
.. .
George wrote:
I would like to suppress adding a new record once the user has
completed filling in a form. The cursor should go back to the first
field in the same record. I am using Access 97.
Thanks in advance for any help you can offer.
Gerry

Why not just set the from to not allow data entry in the form
property - data area?

--
Joseph Meehan

Dia duit

I'm just convinced that as long as I keep old data I'll probably never need
it - but the minute I delete or overwrite it I will!

;-)

To limit to one record, set the Allow Additions Property to No. open the
form in design view, and there's a little square in the upper left of the
form. Right-click, select Properties, Allow Additions is on the Data tab.

Good luck!

SusanV


"George" wrote in message
...
This is a good idea if one required an audit trail of any changes made to
the system. I need this for another system I am working on. Thanks
But the system i am working on presently requires no history. Just a 1
record table.

Thanks Susan,
Gerry

"SusanV" wrote in message
...
Hit send by accident - sorry!

Thanks for replying. I was wondering though if you might not want some
history of configuration perhaps? If so you could use an AutoNumber field
and then base whatever you do with the data on Max of that field.

Just a thought!
--
hth,
SusanV

"George" wrote in message
...
I am storing a single set of configuration data into 1 record. This is
all I need and I must eliminate the possibility of having more than 1
record in the table.



Thanks



"SusanV" wrote in message
...

I'm curious - what's the purpose of this table / form?

SusanV

"George" wrote in message
...
I would like to suppress adding a new record once the user has
completed filling in a form. The cursor should go back to the first
field in the same record. I am using Access 97.
Thanks in advance for any help you can offer.
Gerry

Susan, This has solved my problem. Thank you very much.
Gerry

"SusanV" wrote in message
...
I'm just convinced that as long as I keep old data I'll probably never
need it - but the minute I delete or overwrite it I will!

;-)

To limit to one record, set the Allow Additions Property to No. open the
form in design view, and there's a little square in the upper left of the
form. Right-click, select Properties, Allow Additions is on the Data tab.

Good luck!

SusanV


"George" wrote in message
...
This is a good idea if one required an audit trail of any changes made to
the system. I need this for another system I am working on. Thanks
But the system i am working on presently requires no history. Just a 1
record table.

Thanks Susan,
Gerry

"SusanV" wrote in message
...
Hit send by accident - sorry!

Thanks for replying. I was wondering though if you might not want some
history of configuration perhaps? If so you could use an AutoNumber
field and then base whatever you do with the data on Max of that field.

Just a thought!
--
hth,
SusanV

"George" wrote in message
...
I am storing a single set of configuration data into 1 record. This is
all I need and I must eliminate the possibility of having more than 1
record in the table.



Thanks



"SusanV" wrote in message
...

I'm curious - what's the purpose of this table / form?

SusanV

"George" wrote in message
...
I would like to suppress adding a new record once the user has
completed filling in a form. The cursor should go back to the first
field in the same record. I am using Access 97.
Thanks in advance for any help you can offer.
Gerry

Glad to help any time

;-)

"George" wrote in message
...
Susan, This has solved my problem. Thank you very much.
Gerry

"SusanV" wrote in message
...
I'm just convinced that as long as I keep old data I'll probably never
need it - but the minute I delete or overwrite it I will!

;-)

To limit to one record, set the Allow Additions Property to No. open the
form in design view, and there's a little square in the upper left of the
form. Right-click, select Properties, Allow Additions is on the Data tab.

Good luck!

SusanV


"George" wrote in message
...
This is a good idea if one required an audit trail of any changes made
to the system. I need this for another system I am working on. Thanks
But the system i am working on presently requires no history. Just a 1
record table.

Thanks Susan,
Gerry

"SusanV" wrote in message
...
Hit send by accident - sorry!

Thanks for replying. I was wondering though if you might not want some
history of configuration perhaps? If so you could use an AutoNumber
field and then base whatever you do with the data on Max of that field.

Just a thought!
--
hth,
SusanV

"George" wrote in message
...
I am storing a single set of configuration data into 1 record. This is
all I need and I must eliminate the possibility of having more than 1
record in the table.



Thanks



"SusanV" wrote in message
...

I'm curious - what's the purpose of this table / form?

SusanV

"George" wrote in message
...
I would like to suppress adding a new record once the user has
completed filling in a form. The cursor should go back to the first
field in the same record. I am using Access 97.
Thanks in advance for any help you can offer.
Gerry

George wrote:
Sorry Joseph, no comprendae.
Gerry
"Joseph Meehan" wrote in message
.. .
George wrote:
I would like to suppress adding a new record once the user has
completed filling in a form. The cursor should go back to the first
field in the same record. I am using Access 97.
Thanks in advance for any help you can offer.
Gerry

Why not just set the from to not allow data entry in the form
property - data area?

--
Joseph Meehan

Dia duit

Forms have a data property called data entry. You get to that by doing
a right click on the top left of the from window while in design mode. Data
is a tab; select it. You will see data entry as one of the choices. make it
set to no or not allow or whatever negative choice you have. That will then
keep anyone from entering a new record using that form.

--
Joseph Meehan

Dia duit

On Fri, 2 Jun 2006 12:45:58 -0400, "George"
wrote:

I am storing a single set of configuration data into 1 record. This is all I
need and I must eliminate the possibility of having more than 1 record in
the table.

For a table-based solution that will prevent a user from "going
behind" the Form to mess it up, add a Validation Rule to the table's
Primary Key to insist that it be equal to its current value. I.e. if
the PK is an Autonumber and the only record in the table currently has
that field equal to 1, set that field's Validation Rule property to

=1

John W. Vinson[MVP]

Hey, thanks, John. That's a cool trick, that can be applied to many other
situations as well. I'm always looking for ways to "make Access do the work"
as well as keep things somewhat tamper-resistant. Many of the things I
deliver must be left open to modification for a variety of reasons, so I'm
constantly looking to find a balance between accessibility for the end user
and robustness of the overall application. This one is going in the top
shelf of my toolbox.

Pete



"John Vinson" píse v diskusním
príspevku ...
On Fri, 2 Jun 2006 12:45:58 -0400, "George"
wrote:

I am storing a single set of configuration data into 1 record. This is
all I
need and I must eliminate the possibility of having more than 1 record in
the table.

For a table-based solution that will prevent a user from "going
behind" the Form to mess it up, add a Validation Rule to the table's
Primary Key to insist that it be equal to its current value. I.e. if
the PK is an Autonumber and the only record in the table currently has
that field equal to 1, set that field's Validation Rule property to

=1

John W. Vinson[MVP]

Hi John,
Thanks for the information. I am having a litle problem though. Validation
rule is not an option when I have selected the PK. Yet all other fields in
my table has the validation option. What am I doing wrong?
Gerry

"John Vinson" wrote in message
...
On Fri, 2 Jun 2006 12:45:58 -0400, "George"
wrote:

I am storing a single set of configuration data into 1 record. This is all
I
need and I must eliminate the possibility of having more than 1 record in
the table.

For a table-based solution that will prevent a user from "going
behind" the Form to mess it up, add a Validation Rule to the table's
Primary Key to insist that it be equal to its current value. I.e. if
the PK is an Autonumber and the only record in the table currently has
that field equal to 1, set that field's Validation Rule property to

=1

John W. Vinson[MVP]

Thanks Joseph, Susan sugested this as well and it solved my problem.
Thanks a lot for your input,
Gerry

"Joseph Meehan" wrote in message
.. .
George wrote:
Sorry Joseph, no comprendae.
Gerry
"Joseph Meehan" wrote in message
.. .
George wrote:
I would like to suppress adding a new record once the user has
completed filling in a form. The cursor should go back to the first
field in the same record. I am using Access 97.
Thanks in advance for any help you can offer.
Gerry

Why not just set the from to not allow data entry in the form
property - data area?

--
Joseph Meehan

Dia duit

Forms have a data property called data entry. You get to that by doing
a right click on the top left of the from window while in design mode.
Data is a tab; select it. You will see data entry as one of the choices.
make it set to no or not allow or whatever negative choice you have. That
will then keep anyone from entering a new record using that form.

--
Joseph Meehan

Dia duit