D
Darren
I have a database that sits on SQL Server 2000 and users are restricted on
what actions they can perform on the objects. Via ODBC I have an Access
database for the forms, reports etc.
One of the forms uses a subform and here is the problem. The underlying
table of the subform can only be viewed by certain users thus if they tried
to change, delete or update a record, SQL Server would say "denied". Inside
the subform I have used an error trap that will convert the SQL Server
message into something more understandable to the end-user. If they click
on a save button within the subform the message displays as intended,
however, if they change something then click on a field in the main form,
they get the obscure SQL Server error instead.
My question is, how can I get the same user-friendly message if they either
click on save in the subform or move the focus to a field in the main form?
I have tried adding the message code to the sub-form's "On Lost Focus" event
but this does not work. I also added the same code to the "On Error" event
for both forms but again no joy. After the message is displayed using the
msgbox command I also have DoCmd.RunCommand acCmdUndo so that any changes
they tried to make is removed. If I did not do this, the user would be
trapped on the form and could only exit by closing Access.
I have also used the same code in the OnError events for both the subform
and main form to no avail.
Any advice would be greatfully received.
Regards
Dazza
what actions they can perform on the objects. Via ODBC I have an Access
database for the forms, reports etc.
One of the forms uses a subform and here is the problem. The underlying
table of the subform can only be viewed by certain users thus if they tried
to change, delete or update a record, SQL Server would say "denied". Inside
the subform I have used an error trap that will convert the SQL Server
message into something more understandable to the end-user. If they click
on a save button within the subform the message displays as intended,
however, if they change something then click on a field in the main form,
they get the obscure SQL Server error instead.
My question is, how can I get the same user-friendly message if they either
click on save in the subform or move the focus to a field in the main form?
I have tried adding the message code to the sub-form's "On Lost Focus" event
but this does not work. I also added the same code to the "On Error" event
for both forms but again no joy. After the message is displayed using the
msgbox command I also have DoCmd.RunCommand acCmdUndo so that any changes
they tried to make is removed. If I did not do this, the user would be
trapped on the form and could only exit by closing Access.
I have also used the same code in the OnError events for both the subform
and main form to no avail.
Any advice would be greatfully received.
Regards
Dazza