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

"Ray S." wrote:

> 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?

Thanks Dennis,

I'll take your suggestion and post the second question in the appropriate
section.

"Dennis" wrote:

> 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
>
> "Ray S." wrote:
>
> > 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?

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?

"Ray S." wrote:

> 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?

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 ?

"Ray S." wrote:

> 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?
>
> "Ray S." wrote:
>
> > 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?

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.

"Dennis" wrote:

> 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 ?
>
> "Ray S." wrote:
>
> > 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?
> >
> > "Ray S." wrote:
> >
> > > 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?