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!

  • Congratulations strongm 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. alexkeel79

    Closing CSV File without being prompted to save

    I wrote a script to copy data from a series of CSV files in a directory into an excel spreadsheet. When I'm done copying the date I close the CSV files. I am trying to figure out how to close the files without being prompted to save the file. I have tried the following: importWkbk.Save...
  2. alexkeel79

    Listing Files in a Directory

    I figured it out. I needed to reference Microsoft Scripting Runtime library. For future reference here is the link that I used: http://www.exceltip.com/st/List_files_in_a_folder_with_Microsoft_Scripting_Runtime_using_VBA_in_Microsoft_Excel/446.html
  3. alexkeel79

    Listing Files in a Directory

    I'm working on a script to import all of the files in a given directory into my access DB. Basically what I am trying to do is get a list of all the files in the given directory and then loop through all of those files and import their content into the DB. I found an example to be used for...
  4. alexkeel79

    13: Type Mismatch Error

    Hello, I'm having an issue with a piece of my Access VBA Module. The Module imports data from a Microsoft Word form into the Access DB. In one part of the module I am trying to set a variable = a date field on the form: CrsDivApprvDt2 = IIf(IsDate(doc.FormFields("CrsDivApprv2Dt").Result)...
  5. alexkeel79

    Linking a Word File to an Excel File

    I'm looking for a way to link a WOrd file to an Excel File. Basically what I have is an excel file which tracks 8 fields for certain issue #'s. Then I have a word file that has some additional information on these issues. I would like to set it up so that the word file references the fields...
  6. alexkeel79

    Problem connecting to shared Printer

    One other thing. I am running Windows XP Pro on the desktop and the laptop which can connect to the printer. However on the laptop that I'm having trouble connecting to the printer I am running Windows XP Home Edition.
  7. alexkeel79

    Problem connecting to shared Printer

    I am having some trouble connecting to a shared printer with a laptop. I can connect to the printer with one of my laptops but the user name is the same as on my desktop which the printer is connected to. I even tried mapping a drive to the desktop from the laptop in question but I get a...
  8. alexkeel79

    Running a Stored Procedure in a DTS Package

    EXEC SP_NAME; I also tried adding the database name and owner as such: EXEC DBNAME.dbo.SP_NAME; With the first call I received an error saying I could not call a select query but there is no select query in the SP. With the second the error said could not find the object 'DBNAME'. Note that...
  9. alexkeel79

    Running a Stored Procedure in a DTS Package

    I am trying to execute a stored procedure in a DTS package but I keep getting an error. I am using the Execute SQL task object with an SP that has a few Update queries and 1 Delete query. When I try to test this object the error it gives me says that I can't execute a select statement. Any...
  10. alexkeel79

    Passing Variables through the HTTP Header with '&' character

    I ran into a problem with a string that I was trying to pass through the HTTP header. The string included the character '&' and since that is the character used to seperate elements my string is cut in half. Is there any special character I can use to pass '&' through the HTTP header?
  11. alexkeel79

    VBScrip Regular Expressions

    I am new to VBScript Regular expressions and I am trying to parse a string which includes the lastname, firstname of a user. I tried "LASTNAME\, [A-Z]" and "[A-Z], \FIRSTNAME" but the problem I ran into is that with the last name pattern unless the full last name is used as the search string...
  12. alexkeel79

    LEFT JOIN Problem

    Yeah that is what I thought as well but the number is lower than it should be and if there were duplicates the number would be larger.
  13. alexkeel79

    LEFT JOIN Problem

    I am running into a problem when using the left join table. I have one table (table1) that has a count of items and the expense code assigned to that count of items. I have a second table (table2) that gives me additional information related to the expense code. I am using a left join because...
  14. alexkeel79

    reDim VBScript Array

    Hey Guys, Thanks for your help. I was able to resolve this problem by creating a temp array 1 position bigger than the initial array and then used reDim (without preserve) to make the original array bigger. Finally I copied the data from the temp array to the originally array again.
  15. alexkeel79

    reDim VBScript Array

    I'm having some trouble with a redefining the size of a 2 dimensional array. I keep getting the following error: Microsoft VBScript runtime error '800a0009' Here is an example of my code: dim contArr() 'dynamic array reDim PRESERVE contArr(0,1) 'set initial size of the array contArr(0,0) =...
  16. alexkeel79

    Check to see if array has a value

    Whoops. The second dim should be reDim: dim myArray() reDim myArray(-1) if ubound(myArray) < 0 then 'There are no values in my array end if
  17. alexkeel79

    Check to see if array has a value

    I was trying to check to see if there was anything in the array. I think I found a solution but let me know if you have something better. See below. dim myArray() dim myArray(-1) if ubound(myArray) < 0 then 'There are no values in my array end if
  18. alexkeel79

    Check to see if array has a value

    I am trying to figure out whether or not an array has a value. I thought I could do this buy taking using the ubound function but if the array has nothing in it I get an error with the ubound function. Then I thought I could use the isArray() function but since I declare my array as a dynamic...
  19. alexkeel79

    Check to see if recordset is empty

    How to I check to see if a recordset from a SELECT query is empty? I am getting the following error: error '80020009' Exception occurred. And the only reason I can think of is because I have an if statement that checks a value from a recordset that is empty.
  20. alexkeel79

    Commenting out lines of code

    Is it possible to comment out more than one line of code in ASP/VBScript?

Part and Inventory Search

Back
Top