How do I use: DoCmd.SetWarnings False Select statment INTO new_table DoCmd.SetWarnings True Tnx, Joe
J Joe G Dec 30, 2003 #1 How do I use: DoCmd.SetWarnings False Select statment INTO new_table DoCmd.SetWarnings True Tnx, Joe
R RobFMS Dec 30, 2003 #2 For the example that you gave below: DoCmd.SetWarnings False DoCmd.RunSQL "Select statment INTO new_table" DoCmd.SetWarnings True -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
For the example that you gave below: DoCmd.SetWarnings False DoCmd.RunSQL "Select statment INTO new_table" DoCmd.SetWarnings True -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
J Joe G Dec 30, 2003 #3 Thanks Large Rob Joe G -----Original Message----- For the example that you gave below: DoCmd.SetWarnings False DoCmd.RunSQL "Select statment INTO new_table" DoCmd.SetWarnings True -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- . Click to expand...
Thanks Large Rob Joe G -----Original Message----- For the example that you gave below: DoCmd.SetWarnings False DoCmd.RunSQL "Select statment INTO new_table" DoCmd.SetWarnings True -- Rob FMS Professional Solutions Group http://www.fmsinc.com/consulting Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- . Click to expand...
