Guideance needed - add entry form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Looking for guideance on the most appropriate way to handle the following
scenario:

System: Team knowledge base
Phase II requirements: Users should be able to view data in the database
via queries etc. (this functionality already implemented); need a new feature
that allows the users to enter new items in the knowledge base. However,
these users should NOT have the option to edit other records (scroll through
records in the database). One suggestion I've received is to create a temp
table mirroring the main table where the newly added record would reside. On
the SUBMIT button, we would move the record from the temp table to the main
table and delete from the temp table. This seems a little convoluted to me,
so I'm requesting feedback for other options. Could you just handle this by
disabling the record scroll feature on the entry window? I guess the main
objective is the 'protect' the integrity of the data in the primary table.

Thanks in advance.
 
oh it is pretty easy...

whip up a new form to test with - base it on the table - and then in design
view drag all the fields you want onto it...don't waste time rearranging or
labeling things for now...you can do that later...

still in design view, then click on the form's upper/left corner - the black
square - right click and select Properties

then take away all navigation by changing these properties:

Data Entry: yes
Scroll Bars: neither
Record Selectors: No
Navigation Buttons: no

then drag a button on your form....set that button to close the form &
reopen the form - give it the caption label as "Entry"

the close/open will happen so fast it won't be noticed and will refresh the
screen to blank fields...

this should work fine
 
Back
Top