1 record table

  • Thread starter Thread starter George
  • Start date Start date
G

George

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
 
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
Click to expand...

If I understand your question, change the Form's Cycle property to
Current Record.
 
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
 
Thanks for the answer!

George said:
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
Click to expand...
 
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!
 
George said:
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
Click to expand...

Why not just set the from to not allow data entry in the form property -
data area?
 
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
 
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 said:
Sorry Joseph, no comprendae.
Gerry
Click to expand...

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.
 
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.
Click to expand...

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
 
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
 
Thanks Joseph, Susan sugested this as well and it solved my problem.
Thanks a lot for your input,
Gerry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
DELETE FROM a table WHERE... 1
Access Dcount (multiple criteria) 3
Suppress warnings, but show error messages 2
Create sequence number for table 6
Calculated field in a table 6
Automatic deletion of subform's record 12
Turning a 3 column flat file into a "3D" Table 2

Back
Top