M
Mike
Hi,
I am developing an official's schedule for football games.
many officials to many games.
I have a macro that (1)creates a temp. table (via a query)
that contains already assigned officials based on the
date. (2)appends any official to this temp. table (via
query) that has that same date off. (3) runs an unmatched
query on all officials and puts a list of available
officials into a combo box. This maco is tied to the
OnCurrent event of the form.
When the record changes the desired results do in fact
show up in the combo box.
After I make my official's seclection, and move to another
record, I get an SQLState error that halts the macro
before it creates the temp. table. The error is # 3211 (DB
ENGINE CAN'T LOCK TEMP. TABLE because some other process
has it in use.) I've closed the temp. table before and
after each query in the macro, I've placed DoCmd.close
temp.table in vbcode in the LostFocus event of the combo
box and I still get the error. No other control, form or
event triggers this macro. This is a single user
environment also. This is a project for my internship and
my instructor can't figure it out either. Any help would
be greatly appriecated.
Thanks
I am developing an official's schedule for football games.
many officials to many games.
I have a macro that (1)creates a temp. table (via a query)
that contains already assigned officials based on the
date. (2)appends any official to this temp. table (via
query) that has that same date off. (3) runs an unmatched
query on all officials and puts a list of available
officials into a combo box. This maco is tied to the
OnCurrent event of the form.
When the record changes the desired results do in fact
show up in the combo box.
After I make my official's seclection, and move to another
record, I get an SQLState error that halts the macro
before it creates the temp. table. The error is # 3211 (DB
ENGINE CAN'T LOCK TEMP. TABLE because some other process
has it in use.) I've closed the temp. table before and
after each query in the macro, I've placed DoCmd.close
temp.table in vbcode in the LostFocus event of the combo
box and I still get the error. No other control, form or
event triggers this macro. This is a single user
environment also. This is a project for my internship and
my instructor can't figure it out either. Any help would
be greatly appriecated.
Thanks