Alternative program calls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

From a button on a form, I'm executing a macro that calls a sequence of seven
append queries. At the execution of the first append, I allow the user to
enter two variable quantities, but the rest do not require any response. At
the execution of each one a pop-up warns that you are about to change a table
and another popup requests confirmation to continue. I think there is even
another popup that informs the user how many records are going to be
appended! I would like to eliminate all that and let the process complete
without all that intrusion. Does anyone know how I can do that?

I have another question that probably should be posted separately, but I'll
try it here anyway. I constructed another database and then migrated it to
SQL server. Once on the server, I cannot edit tables, views, and reports,
although I can make and save forms that are viewable only to me. Is this an
Access issue, or is it an issule of permissions at the SQL server or file
server level?
 
Make the first line of your macro
SetWarnings
and set the parameter to No
Make the last line
SetWarnings
and set parameter to Yes

Don't know the answer to the 2nd bit so I suggest you post it separately
 
Thanks Dennis,

I'll take your suggestion and post the second question in the appropriate
section.
 
Oh, Dennis, I just thought of another question you may be able to answer: Is
there some command I can use to close a table and any queries or reports
calling it?
 
Not sure if this is the answer you are looking for but assuming you are still
talking from within a macro use the Close Action
the parameters will then let you select what to close.
I suspect you are looking to somehow pick a table and close querys/reports
etc. that are currently bound to it ?
 
Yes, exactly, I want to pick a table and close any queries and reports, etc.
that are bound to it. And, in this particular situation I am within a macro,
so I'll try the close action suggestion.
 
Back
Top