How to insert into table from a temp recordset

[W.Dnx.W]

One more question...is there a way to execute SQL with docmd.RunSQL but without the confirmation dialog box...
I need to insert some data into table and I'm sure that I want to do it...how can I skip to answer "I'm about to append 1 row..."

Thnks

 

[llkhoutx]

The warning message won't apperar when you use

dim db as dao.database
set db=currentdb
docmd.setwarnings false ' turn warnings off
db.execute sql
docmd.setwarning true ' turn warning back on
db.close
set db=nothing

 

[W.Dnx.W]

Thanks...that was what I needed...I was wondering...how come that in Excell VBA there is a application.DisplayAlert and in Access isn't ?!?!

 

[llkhoutx]

Docmd.SetWarnings True and False serve the same purpose. Maybe different programming groups wrote Access and Excel and only certain only certain common functions were used. Of course, Access VBA in rooted in Basic.

Bill Gates knows.

 

[W.Dnx.W]

It seems so...anyways, thanks a lot for all your help guys...see ya around