N
NetworkTrade
this question maybe is actually about the macro function in Access07
Have a form which shows alot of data - alot of which is involved with query
based calculations....
There is an unbound text box ; its purpose is if the user needs to change a
key value in the showing data. They can enter a new value into the unbound
control...then press an 'update' button.
the button runs a macro that runs a series of queries that now use this new
value in the unbound text box to replace/insert into underlying table - and
runs queries on it.
this works 'as is' in Access2003
in Access2007 there is a message box that occurs when one attempts to close
the Form that "another user has changed data....." with an option to keep the
change or not.
I can understand the reason for the message - because it is true - the data
originally showing is now changed due to the update macro...so I don't have a
problem with the new message per se....
To avoid this message, I created a shadow form just to hold this new value -
I have it open hidden as the first event of the macro - thus the new value is
now in ShadowForm - then the macro closes the main Form - then the macro
carries on with its normal queries refering to now the shadowform rather than
the form.
I step thru this manually it is fine.
But via macro I still get the overwrite warning message - as if the main
form is not yet closed when the queries are running even though the form is
supposed to be closed before the query goes on....
don't know anything about timing and thought sequencial in macros would be
sufficient... thoughts?
Have a form which shows alot of data - alot of which is involved with query
based calculations....
There is an unbound text box ; its purpose is if the user needs to change a
key value in the showing data. They can enter a new value into the unbound
control...then press an 'update' button.
the button runs a macro that runs a series of queries that now use this new
value in the unbound text box to replace/insert into underlying table - and
runs queries on it.
this works 'as is' in Access2003
in Access2007 there is a message box that occurs when one attempts to close
the Form that "another user has changed data....." with an option to keep the
change or not.
I can understand the reason for the message - because it is true - the data
originally showing is now changed due to the update macro...so I don't have a
problem with the new message per se....
To avoid this message, I created a shadow form just to hold this new value -
I have it open hidden as the first event of the macro - thus the new value is
now in ShadowForm - then the macro closes the main Form - then the macro
carries on with its normal queries refering to now the shadowform rather than
the form.
I step thru this manually it is fine.
But via macro I still get the overwrite warning message - as if the main
form is not yet closed when the queries are running even though the form is
supposed to be closed before the query goes on....
don't know anything about timing and thought sequencial in macros would be
sufficient... thoughts?