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 Chriss Miller 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. SlakeB

    Recordset starting with a middle record - not the first

    That fixed it...Thanks so much!
  2. SlakeB

    Recordset starting with a middle record - not the first

    ...| -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...
  3. SlakeB

    Access Macros: Can you use relative paths??

    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.
  4. SlakeB

    Compacting a DB with VBA or VBScript

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

    VBSCRIPT TO FTP

    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...
  6. SlakeB

    Running Excel macros from an external .vbs file

    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"...
  7. SlakeB

    How do I call my VBA Macros outside of Excel ?

    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"...
  8. SlakeB

    Running Excel macros from an external .vbs file

    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) &...
  9. SlakeB

    Running Excel macros from an external .vbs file

    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.
  10. SlakeB

    Access Query Error problem

    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...
  11. SlakeB

    Calling a vbscript from a vbscript

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

    Combining Data from 3 tables with SQL

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

    Combining Data from 3 tables with SQL

    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...
  14. SlakeB

    Calling a vbscript from a vbscript

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

    Problem with two record sets for a Message Board

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

    Problem with two record sets for a Message Board

    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...
  17. SlakeB

    Querystring confusion

    Thank You! That fixed it.
  18. SlakeB

    Querystring confusion

    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"...
  19. SlakeB

    call a batch file from an Access module

    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?
  20. SlakeB

    Count Num Records in Access table

    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

Part and Inventory Search

Back
Top