RE: Alternative program calls

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