Search results for query: *

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

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

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)...

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

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

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

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?

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

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

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) =...

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

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.

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

I am having a problem with my T20 laptop. When I came home today it was turned on but was showing a blank screen. It wouldn't come to life so I turned it off but now it won't boot at all. Any ideas on what the problem may be? Here are the specs: Model: IBM T20 Purchased: 2000 OS: Microsoft...

I am trying to figure out how to write an if statement with an "OR" but I can't remember the syntax. Can somebody help me about with this? I thought it was && - AND || - OR but I guess I am wrong. Any suggestions?

I am having a problem with a sub routine that I wrote. The sub routine takes in one parameter and then gets another value from a SQL server database. The parameter is numeric as well as the value taken from the database. However, although the value from the db is type numeric in the db...

I wrote an access module which imports a word form. It has worked fine the past few weeks but now I am getting the following error with one file: "-2147217887: The field is too small to accept the amount of data you attepted to add. Try inserting or pasting less data." I checked all the...

Is there a system stored procedurs in SQL server to find the size of a table? I used a SP a few weeks ago but I can't remember if it was for the entire database or individual tables. It was something along the lines of SP_SIZE but that is not exactly it. Thanks

I am writing a script to send emails to about 100 users. I have been looking through the php.net description of Mail() and at the end I noticed that it said I shouldn't use this function in a loop. If I use a loop that cycles through 100 times is that too much for this function or am I okay?

Hello, I am trying to connect to an access db using PHP on and IIS server. I was able to write a SELECT query that worked but I can't quite figure out INSERT and UPDATE queries. Any ideas? See code below: <?php $db = 'database/nsbexl-nyc_db.mdb'; $conn = new COM('ADODB.Connection')...