S
sal
Hi
I have a form containing a sub-form. I have created a
procedure to cancel the sub-form 'Delete' event, add the
current date in the 'DateDeleted' column for that record
& requery the sub-form, thus hiding the 'deleted' record.
Because this database is used on a number of PC's with
different screen resolutions, and I cannot make the sub-
form grow vertically, I have removed the sub-form &
replaced it with the individual controls and made the
main form continuous. Now, when the delete event occurs
in the main form, the event is cancelled as it should be,
the current date is entered in the 'DateDeleted' column
for that record, but when the procedure tries to requery
the form I get the message "3246 Operation Not Supported
In Transactions".
I was not using transactions before & I am not using them
now, so I cannot understand why it will not work.
Thanks
I have a form containing a sub-form. I have created a
procedure to cancel the sub-form 'Delete' event, add the
current date in the 'DateDeleted' column for that record
& requery the sub-form, thus hiding the 'deleted' record.
Because this database is used on a number of PC's with
different screen resolutions, and I cannot make the sub-
form grow vertically, I have removed the sub-form &
replaced it with the individual controls and made the
main form continuous. Now, when the delete event occurs
in the main form, the event is cancelled as it should be,
the current date is entered in the 'DateDeleted' column
for that record, but when the procedure tries to requery
the form I get the message "3246 Operation Not Supported
In Transactions".
I was not using transactions before & I am not using them
now, so I cannot understand why it will not work.
Thanks