NEED HELP FROM AN EXPERT!!!!

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Is it possible to restrict a user who is entering data
into a form from viewing and or changing any other
records. In short I am tring to hide the record selector
at the bottom of the form and force the user to use a
button that saves the data and opens a new record. I will
saw I am new to Access and I have a deadline in 3 hours to
get this project fixed... Please try to be specific as
possible.


Thanks in advance
 
it is possible to turn off the record selector. Open the
form in Design View. Across the top to the left of the
white ruler bar, right click on the little box. from the
pull down menu select properties. under the format tab,
go to Record Selectors. Choose No. Close that box and
save.
 
Matt said:
Is it possible to restrict a user who is entering data
into a form from viewing and or changing any other
records. In short I am tring to hide the record selector
at the bottom of the form and force the user to use a
button that saves the data and opens a new record. I will
saw I am new to Access and I have a deadline in 3 hours to
get this project fixed... Please try to be specific as
possible.
Click to expand...

If you set the form's Data Entry property to Yes (on the Data tab of the
form's property sheet in Design View), the form will open as a blank
form to enter a new record only, and as each new record is added the
previous one will disappear. The navigation buttons at the bottom will
still appear unless you also set the form's Navigation Buttons property
(on the Format tab of the property sheet) to No; however, they won't
permit the user to do anything but go to the next (new) record. If you
choose to turn off the Navigation Buttons, the user can still use the
Edit -> GoTo menu to go to the next new record, but you may choose to
have a command button with code like this:

Private Sub cmdSaveRecord_Click()

RunCommand acCmdSaveRecord

If Not Me.NewRecord Then
RunCommand acCmdRecordsGoToNew
End If

End Sub

Note that the above assumes that "cmdSaveRecord" is the name of the
button.
 
Back
Top