ACCESS: How To: Disable popup on RunSQL with "SELECT INTO" [RESOLVED]

[Webtest]

Esteemed Forum Participants and Lurkers:
===============================
ACCESS 2000 (XP) & '97

I am running an SQL statement on an existing table to create a new table. How can I keep the dumb modal popup "You are about to insert a zillion records into your table" from occurring? Here is where the warning pops up:

    strSQL = "SELECT * INTO " & TABLE & " FROM MASTER_EXTRACT WHERE(Prof=" & i_Profile & ")"
    DoCmd.RunSQL strSQL

Thank you for your gracious comments, suggestions, and assistance.

[RobDog888]

Turn the alerts off before the insert and back on after.

application.displayalerts = false 'off

[Webtest]

Hey ... wait a minute ... that's the way megashaft does it in Excel! They couldn't possibly have done it the same way in Access???

[RobDog888]

Whats a "megashaft"?

[Webtest]

Hah!!! I was RIGHT!

Application.DisplayAlerts in Access yields an ERROR!

"Method or data member not found"!

[Webtest]

It's a Freudian slip.

[RobDog888]

An error turning off the alerts or from the insert code?

The display alerts property will accept the default choice when they are turned off.

[Webtest]

When I run the function it bombs with ".displayalerts" highlighted in the first line with the message "Method or data member not found". It does NOT like "DisplayAlerts".

    Application.displayalerts = False
    DoCmd.RunSQL strSQL, False
    Application.displayalerts = True

[RobDog888]

Oh, which version of access are you testing this on? 97 or 2000?

[RobDog888]

Doh! Memory failing.... use wdAlertsNone

[Webtest]

ACCESS 2000 right now ... I don't think I have to make the top-level table generator compatible with '97.

[RobDog888]

My Bad My previous post is for words constant.

It should be True/False for Access 97+ but double check this link for it and 97.

http://msdn.microsoft.com/archive/de...html/SFE31.asp

[Webtest]

Doh! Memory failing.... use wdAlertsNone

Could you please put this in context? I can't quite figure out how to use it ...

A most sincere "Thank you"!

[RobDog888]

Post #12 shows my error and you dont need that constant since it was my mistake and posted for Word and not Access.

Question: is this all being run from behind a forms button click or something?

[Webtest]

Look back at my post #8 ... ACCESS:

When I run the function it bombs with ".displayalerts" highlighted in the first line with the message "Method or data member not found". It does NOT like "DisplayAlerts".

Now that we know how EXCEL works, let's try to solve the ACCESS problem ... how to turn off (and back on, of course) Display modal popups.

[kfcSmitty]

web, maybe you don't realize this, but rob is trying to help you. Could you try to be a little less rude?

[Webtest]

I found it ...
DoCmd.SetWarnings False

[RobDog888]

Well I'm sorry for the confusion but I am eating lunch and posting at the same time. So at least its Resolved

[Webtest]

... and "DoCmd.SetWarnings [True|False]" works fine.

I was going to say something REALLY nice about the Raiders, but now ...

[Webtest]

web, maybe you don't realize this, but rob is trying to help you. Could you try to be a little less rude?

Rob Dog ... You're the greatest! And the Raiders are the greatest team that I follow religiously!

kfcSmitty ... sorry to have bugged you with my feeble attemps at trying to convince (and tease) RobDog that he was confusing Access with Word and Excel! My signature is very sincere ...

[RobDog888]

Art, No worries or ofense taken

Even a Guru can have a bad day