Search results for query: *

Is this possible? CONNECT TO <remotemachine> USER <user> USING <password>; INSERT INTO <localmachine>.localtable SELECT * FROM <remotemachine>.remotetable; If I issue SELECT * FROM <remotemachine>.remotetable; then all rows are corrently returned. My problem is specifying the local table...

If I want to update a file in Free using the %Fields() BIF can the field be an array element? For Example... FMyfile UF E K DISK d Weeklyhrs ds d Monhrs d Tuehrs...

I have the following snippet With ActiveCell.Offset(R, 0).EntireRow If .Interior.ColorIndex = 35 Then .Interior.ColorIndex = 36 Else .Interior.ColorIndex = 35 End If End With The problem is that the entire row is selected (ActiveCell.Offset(R, 0).EntireRow). What I would like to...

I am creating an SQL statement by concatenation as follows: Dim DataLib As String Dim Stmt As String DataLib = "Mylib" Stmt = "" Stmt = Stmt & "SELECT USRDPT, PRIOR, CONCAT(DESC1, DESC2) AS DESC, " Stmt = Stmt & " CONCAT(A.STATUS, CONCAT(' - '," Stmt = Stmt & " (SELECT...

I thought this was going to be simple but I've not had any luck. I have an external query in cell A3 and I want to move it to Cell A1. I should think this is easily done but it's Monday morning... Thanks in advance, Rob

I am creating a new work sheet (sheet2) from a macro on sheet1. I later intend on emailing sheet2 (as an attachment through File->Send). The problem is that when the new worksheet (sheet2) is opened by the recipient he gets the macro that was used to create the sheet. I would like the new...

The following code causes the error... Run-time error '1004' Application-defined or object-defined error. Can someone explain what's wrong? (I figure that the new worksheet is not in the scope of the called subs but I'm not sure) Private Sub CommandButton1_Click() AddNewSheet End...

Can someone explain why I get an run time error on the range statement please. I'm creting a new sheet, naming it with the selection date and beginning to format the cells. The cells statements work fine but the range ends with an error. Set NewSheet = Sheets.Add NewSheet.Name =...