Thanks very much...this is exactly what i'm looking for. I'm currently
searching some other settings which can be adjusted like this.
Thankxs very much
"Jimbras" <alguem@microsoft.com> schreef in bericht
news:4107940b$0$3608$a729d347@news.telepac.pt...[color=blue]
> hi, Chris,
>
> when working with access runtime and you need to change options you must[/color]
use[color=blue]
> code.
>
> try this:
>
> if application.getOption("Confirm Action Queries") = true then
> Application.SetOption ("Confirm Action Queries"), False 'change
> parameter to false (don't have to confirm action queries)
> end if
>
> Regards
>
>
>
> "Remco Groot Beumer" <test123test12@12move.nl> escreveu na mensagem
> news:ce7kp0$ln8$1@news2.tilbu1.nb.home.nl...[color=green]
> > Hello,
> >
> > I've developed a Microsoft Access 2000 database. In a lot of events
> > Docmd.RunSQL is used. In my database options the 'Confirm' options are
> > turned off, so I don't have to confirm action queries. The SQL[/color][/color]
statements[color=blue][color=green]
> > are executed behind the scenes this way.
> >
> > But When I run the same database with a runtime version of Microsoft[/color]
> Access[color=green]
> > 2000, I have to confirm the actionqueries that are executed with
> > Docmd.RUnSQL again. For each SQL statement, the confirmation-question is
> > shown on the screen. Since I don't see the option to change this[/color][/color]
settings[color=blue]
> in[color=green]
> > the runtime version I wonder how to solve this?
> >
> > Does anyone know how to solve this problem?
> >
> > Greetings,
> > Chris
> >
> >
> >[/color]
>
>
>[/color]
