M
mpm32
I have a main form with 4 sub forms attached. One of the sub forms i
from a table that has calculations based on variables from the mai
form and 2 other tables. I have built queries and bundled the
together into a macro to update this calculations table. This macr
runs fine on it’s own.
I would like to have the macro run OnTab or OnClick etc. from the mai
form. When I set those procedures to run I get an Action Faile
message. When I press Halt, I get an error box that says; ‘ Th
database engine could not lock table ‘Costs and Proceeds Calcs’ becaus
it is already in use by another person of process.”
I know this is happening because I have the table open by way of th
sub form. There has to be a way to disable the table while the macr
is running so that the updates are visible on the sub form after th
macro runs. I have looked everywhere and tried many things to get thi
to work but I am stuck.
Can anyone point me in the right direction? Once I get over thi
hurdle, this project is done.
Thank
from a table that has calculations based on variables from the mai
form and 2 other tables. I have built queries and bundled the
together into a macro to update this calculations table. This macr
runs fine on it’s own.
I would like to have the macro run OnTab or OnClick etc. from the mai
form. When I set those procedures to run I get an Action Faile
message. When I press Halt, I get an error box that says; ‘ Th
database engine could not lock table ‘Costs and Proceeds Calcs’ becaus
it is already in use by another person of process.”
I know this is happening because I have the table open by way of th
sub form. There has to be a way to disable the table while the macr
is running so that the updates are visible on the sub form after th
macro runs. I have looked everywhere and tried many things to get thi
to work but I am stuck.
Can anyone point me in the right direction? Once I get over thi
hurdle, this project is done.
Thank