Search results for query: *

That fixed it...Thanks so much!

...| -84 | 39 2 | -85 | 40 . . . . . . . . . Here is my vbscript code sSQL3 = "SELECT * FROM BUS_STOP" Set objRS2 = Nothing Set objRS2 = CreateObject("ADODB.Recordset") objRS2.Open sSQL3, db counter = 0 objRS2.MoveFirst Do While...

When performing certain macros like 'transfer to spreadsheet', can you use relative paths (like ../spreadsheets/test.xls) to the files involved or do you need to use the full absolute path (like C:/spreadsheets/test.xls)? relative paths don't seem to be working for me.

does anyone know how to compact and repair a DB with either VBA or VBScript?

This is a question for xmsre: When you said: "No, but I have the opposite. I have one that you put into your sendto folder so that when you right click a file you get a sendto FTP site option." what sendto folder are you talking about? I would like to be able to add some of my own scripts to...

hey PHV, I used the code below and it worked great. Do you know how to stop the "Do you want to save changes" window from popping up? Dim X Set X=CreateObject("Excel.Application") Set W=X.Workbooks.Open("D:\Docs\JaydipDB\OutputFiles\testExcelMacros.xls") X.Run "macTest1" X.Run "macTest2"...

hey PHV, I used the code below and it worked great. Do you know how to stop the "Do you want to save changes" window from popping up? Dim X Set X=CreateObject("Excel.Application") Set W=X.Workbooks.Open("D:\Docs\JaydipDB\OutputFiles\testExcelMacros.xls") X.Run "macTest1" X.Run "macTest2"...

Here is what I have so far (something similar worked with Access macros that I was dealing with). It successfully opens the excel document, but it can't find the macro. Dim oWSH Dim retVal Set oWSH = WScript.CreateObject("WScript.Shell") retVal = oWSH.Run("excel.exe " & Chr(34) &...

Does anyone know how to do this? I have an excel spreadsheet with two buttons on it. Each button triggers a macro. I want an external .vbs file to run those macros without me having to go into excel and push the buttons.

Every time I run a macro of mine (which triggers a query) I get this error: "Microsoft Access Can't Append All the Records in the Append Query" It asks if I want to continue, and I click ok. Is there a way to keep this message box from popping up when this occurs? I've tried 'On Error Resume...

So would I do something like this?: Set Cmd = Server.CreateObject("ADODB.Command") sVBToRun = "externalScript.vbs" Cmd.Execute(sVBToRun)

Thanks! this worked: INSERT INTO yourNewTable SELECT * FROM ( SELECT * FROM yourTable1 UNION ALL SELECT * FROM yourTable2 UNION ALL SELECT * FROM yourTable3 );

I have three tables. Each of these tables have the same structure (same fields). I want to create a new table with the same structure, and I want to put all the records from the other 3 tables into it (kind of like a master table). Does anyone know how to do this with SQL? The SQL doesn't...

Is it possible to call a vbscript file from within another vbscript file without using the DOS shell?

Is it possible to Join more than two tables in a SQL statement?

I am building a message board application, using an Access DB. The users can view all the main posts, and by clicking on one, they can view all of the subthreads for that post. On the ASP page displaying the main post, and the sub posts, I want a picture of the person who made the main post...

Thank You! That fixed it.

The asp page I'm working with has a query string fed into it, and the URL is: replyToThread.asp?MainThreadNum=14 On that page, I have a form with this code: <form method="get" action="scriptSubThread.asp"> <table> <tr> <td align="right"> <input type="hidden" name="MainThreadNum"...

How can I do this? I know how to call a .vbs file: Call Shell("wscript.exe " & "myVBS.vbs", vbMaximizedFocus) How can I call a .bat file instead?

I think I answered my own question. This works: Set rsCount = CreateObject("ADODB.Recordset") rsCount.open "tblErrorLog",objConn1 Dim intErrorCount intErrorCount = 0 Do While Not rsCount.EOF intErrorCount = intErrorCount + 1 rsCount.moveNext Loop wscript.echo intErrorCount