Search results for query: *

Source file is created using the following: OS: XP PRO Sp3 - all updates completed Office 2003 - all updates completed Toad for DA is being launched by the windows scheduler and creating a file on the network. The file is being opened by (Managers Laptop): OS: Win7 - all updates completed...

I have written (also somewhat leveraged) this code to pull info from an excel 2007 file. I step through the code and it works fine. I create an executable and it works fine. But if I open another instance of the executable, either on my computer or somebody elses, I get this error. run-time...

I am currently trying to import 3 columns from an excel file. I used a connection setup that Skip had showed somebody. Dim sConn As String, sSQL As String Dim rst As ADODB.Recordset Dim cnn As ADODB.Connection Dim sPath As String, sDB As String sPath =...

The subject pretty much says it all. So, I haven't used the watch window much, but I have been following a thread and saw the FAQ on Watch window and got it to open the object model. I use the locals window all the time...I can step through code and see variables change, reset variables to...

I have 2 excel files. One file uses another for certain information that I use for configurating. I have a worksheet in the main file that has an external connection to the config file. I am using this piece of code to refresh to connection. ActiveWorkbook.Connections("AOI Config Data...

I'm trying to get an Average of a count in an SQL statement. Here is the statement. SELECT SFC, COUNT(SFC) as NumberSfc FROM plr_data WHERE ASSY="50060D" AND EVENT_DATE>=#5/23/2011# AND NC_CODE = "FF" AND PROCESS = "1-475-MV1" GROUP BY SFC; this produces a table output like: SFC...

Schema- EventID InDate OutDate InTime OutTime Status SID "It's the employee number" Elapsed Time "String" SFC "Barcode Serial Number on PCB" I have two queries that I'm trying to combine. Basically what happening is the user takes a PCB out of a nitogren cabinet and hits a button that enters...

I am doing a query on a production DB for the last 24 hours of data. Info comes back fine. I am trying to look at info by the hour so I have tried a couple of technics. At first the Engineer just wanted to look at throughput. So, I created an array with 24 elements and counted everything. Worked...

I'm attempting to get a scale to input data into Excel using VBA(hopefully). The scale has a USB interface and I have setup the interface according to docs (I believe). The port that gets created is COM5. I have done the port setup on that also. I set up the scale to send data when the reading...

I have written some code that copies a worksheet, which creates a new workbook, which I save to a file. One of the thing on the old worksheet/new workbook, is a macro button. When I open the new file the macro button is there and the macro is there, because I looked in the list of macros, but...

Running: PS4 WIN2000 advanced server sp4 w/updates I have one published app that I only want the user to be able to launch one instance. Hence, "Allow only one instance of application for each user" check box. I just had a user login (same username and password) and allowed them to open the...

I have 14 servers in my farm and one won't allow me to publish any apps, including the desktop. I'm running PS4.0 with the rollup patch and a few printer patches. When I try to publish the app I get all the way through the entire process, press finish and I get this error window. "Error Writing...

I'm running a PIX 506 6.3(3). I have the VPN cranked up and working mostly fine. I have defined an ip local pool for my address-pool in the vpngroup. The issue I'm having is that we are using Cisco Softphone and the IP address on the VPN is different almost everytime somebody starts the VPN...