Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Cordeyo

    VBA & SQL SERVER

    But this is what I did in SQL Server 2005 -- ============================================= -- Author: Cordeyo -- Create date: 4-22-09 11:55 AM -- Description: -- ============================================= ALTER PROCEDURE [dbo].[sp_CHANGE_PROCEDURE_TEXT] @PROCEDURE VARCHAR(50), @OLDTEXT...
  2. Cordeyo

    VBA & SQL SERVER

    Gary, Thanks for the tips. After a little more research, this is what I have decided to do. I have discovered this SQL which will get me the text I need to change. SELECT DISTINCT [NAME], xtype, O.ID, O.ID, [TEXT], 'GWOT' = SUBSTRING([TEXT], PATINDEX('%GWOT%', [TEXT]), 4) FROM SYSOBJECTS O...
  3. Cordeyo

    Run-time error '1004'

    Hi Skip Just an observation that if the loop was not activated because ReportP.Sheets(1).Cells(w, 2) is empty when w = 1 then w will stay at 1, causing the code Cells(w - 1, 4) to translate to Cells(0 ,4). Which will generate the 1004 error. Help me if I'm wrong. I do not claim to be an expert...
  4. Cordeyo

    Run-time error '1004'

    Groves22 If w - 1 = 0 you will get the 1004 error. HTH Cordeyo
  5. Cordeyo

    Select one or more text files in a directory.

    FileSystemObject still works in Office 2007. At least it does for me in Access. As I said "You must have a reference to the Microsoft Scripting Runtime library". Here is the complete code I use. You will have to change it to suit your needs. Public Sub RemoveQuotesFromTextFile(ByVal sFile As...
  6. Cordeyo

    Email from Excel not sheet based

    03Explorer, I can't see why this would not be possible. I've sent email from Access. Here are some links that may help you get started. http://www.tek-tips.com/viewthread.cfm?qid=1531002 http://www.tek-tips.com/viewthread.cfm?qid=1490777 Cordeyo
  7. Cordeyo

    Select one or more text files in a directory.

    gjsala I have a text file I must remove quotes from. To do this I use the FileSystemObject. You must have a reference to the Microsoft Scripting Runtime library. This is some of the code I use: Set oFso = CreateObject("Scripting.FileSystemObject") Set InStream =...
  8. Cordeyo

    VBA & SQL SERVER

    Is there a way to programmatically modify the structure of views in SQL Server through VBA or VB? I have nearly 200 views that have a where conditions which contain the word 'GWOT' that needs to be changed to 'OCO'. I also have some views which have fields named ???_GWOT which need to be renamed...

Part and Inventory Search

Back
Top