G
giggles
I have a form I have created to ease the transition from a flat database to a
relational database, however when I try to link from the new user forms to
this "snapshot" form (includes information from 4 tables) it gives me an
error that the table that fuels that particular user form is already opened
exclusively by another user - even if I have it opened exclusively or at home
and not on a shared server. I created both a macro and VBA code to first
close the user form before opening the snapshot form and it worked for one
form, but not the others. I assumed the sql code that is the source for the
snapshot is what would not let both forms be opened at the same time -but
manually closing the form works -but using code or macro doesn't seem to work
- what am I missing?
relational database, however when I try to link from the new user forms to
this "snapshot" form (includes information from 4 tables) it gives me an
error that the table that fuels that particular user form is already opened
exclusively by another user - even if I have it opened exclusively or at home
and not on a shared server. I created both a macro and VBA code to first
close the user form before opening the snapshot form and it worked for one
form, but not the others. I assumed the sql code that is the source for the
snapshot is what would not let both forms be opened at the same time -but
manually closing the form works -but using code or macro doesn't seem to work
- what am I missing?