preventing records to be scrolled with the mouse wheel in EditView

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

Guest

Hi all,

I have a single form which is set to allowedits = false, it is thus a form
which I call ViewMode. But the same form, through an 'edit' button, can
become allowedits = true, so called EditMode, and be used to edit records.
I've just discovered that if I click in a field and use the mouse wheel, I
can browse the whole recordset; which is nice in ViewMode, but I have to
absoultely disable this feature when in edit mode.
I'm not very experienced and don't know if there is a property to disable
the scroll (in access, not in the mouse settings:) and freeze the view to one
single record ... any idea??

thanks a lot
Massimo
 
max said:
I have a single form which is set to allowedits = false, it is thus a form
which I call ViewMode. But the same form, through an 'edit' button, can
become allowedits = true, so called EditMode, and be used to edit records.
I've just discovered that if I click in a field and use the mouse wheel, I
can browse the whole recordset; which is nice in ViewMode, but I have to
absoultely disable this feature when in edit mode.
I'm not very experienced and don't know if there is a property to disable
the scroll (in access, not in the mouse settings:) and freeze the view to one
single record ... any idea??
Click to expand...


I believe the DataEntry and AllowAdditions properties will
take care of all that. Setting them both to True will only
display the new record and setting them to False will only
display existing records.
 
I believe the DataEntry and AllowAdditions properties will
take care of all that. Setting them both to True will only
display the new record and setting them to False will only
display existing records.
Click to expand...


Hi Marsh,

thanks for your help.
This is definively a good solution for the "NewRecordMode". But what can I
do for the EditMode? the DataEntry porperty set to yes will prevent the user
to see and edit existing records... i just need to prevent the scroll. Do
you think it is possible?

Massimo
 
I believe the DataEntry and AllowAdditions properties will
max said:
This is definively a good solution for the "NewRecordMode". But what can I
do for the EditMode? the DataEntry porperty set to yes will prevent the user
to see and edit existing records... i just need to prevent the scroll. Do
you think it is possible?
Click to expand...


Sorry, I misread the original question and thought it was
only the new record situation where you wanted to prevent
scrolling.

In general, I prefer to prevent users from seeing other
records by setting the form's Record Source to a query that
only has the one record in its dataset. So the code in the
Edit button's Click event would then look like:

Me.DataEntry = False
Me.AllowAdditions = False
Me.RecordSource = "SELECT * FROM table " _
& WHERE ID=" & me.txtID

The View button would have to reset the RecordSource to your
original table/query as well as setting AllowEdits, etc.

I've never tried it, but I imagine it would also be possible
to use code in the form's BeforeUpdate event procedure that
checks a flag variable to verify that the Save button
(assuming you have one) was used or Cancel the update if it
wasn't. This way, the form will not be able to navigate
until the changed record has been saved.
 
Hi again Marsh,

many many thanks for your hints,
the query solution is working fine :)

cheers
Massimo
 
Back
Top