Results 1 to 21 of 21

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

Threaded View

  1. Jul 25th, 2005, 01:33 PM #1
    Webtest
    Webtest is offline

    Thread Starter
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

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

    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:
    Code:
        strSQL = "SELECT * INTO " & TABLE & " FROM MASTER_EXTRACT WHERE(Prof=" & i_Profile & ")"
    DoCmd.RunSQL strSQL
    Thank you for your gracious comments, suggestions, and assistance.
    Last edited by Webtest; Jul 25th, 2005 at 02:54 PM. Reason: [RESOLVED]
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width