Search results for query: *

Function ConvertToLetter(iCol As Integer) As String Dim i, j As Integer Dim sCol As String Dim iAlpha As Integer Dim iRemainder As Integer iRemainder = Int(iCol Mod 26) If iRemainder = 0 Then iRemainder = 26 End If sCol = Chr(iRemainder + 64) If ((iCol -...

So I have used the same code just changing the variable names several times without any issues until now. The following code gives me the infamous 91 error Object variable or With block not set. Sub GetANITESTLIST() ' Declare variables Dim qry As String Dim qt As QueryTable Dim...

I am using code that works correctly when getting data from MSSQL, but does not work correctly when I get data from POSTGRES on a MAC. I am running my code on the latest MAC OS X Yosemite. PERL version 5.18 DBI version 1.631 DBD-Pg version 3.4.2 Postgres version 9.3.5 the line of code is...

I am trying to return only those grouped rows where the OriginalAmt does not equal the ReverseAmt. Instead of the query giving me the rows I want, it returns all rows. Please help. Need ASAP. SELECT h.Account, h.ApplSeq, SUM(CASE WHEN h.Dcindicator = 0 THEN h.Tramt ELSE 0.0 END) AS...

Hello gurus, I am trying to manipulate a chart I created using the Win32::OLE chartwizard code as follows: $chart1->Chart->ChartWizard($ws->Range("A40", "B42", xlPie, 7, xlColumns, 1, 0, 0, '', '', '', ''); What code do I use to change the font size of the category labels on the pie graph...

I am using the PERL module Spreadsheet::WriteExcel to create an excel workbook from scratch. I create a worksheet put some data in it. Format everything and I also add a few formulas near the bottom of the sheet after all the data is written to the worksheet. When I open the workbook...

my code looks something like: DECLARE @var AS VARCHAR (20); SET @var = 'A/B'; SELECT * FROM Tablename WHERE LTRIM(RTRIM(Field)) = LTRIM(RTRIM(@var)); It does not return any rows. It does return rows if I write the code as follows: SELECT * FROM Tablename WHERE LTRIM(RTRIM(Field)) =...

Here is my code: use Win32; use Win32::NetResource qw(:DEFAULT AddConnection CancelConnection); $| = 1; %NETRESOURCE = { 'Scope' => "RESOURCE_GLOBALNET", 'Type' => "RESOURCETYPE_ANY", 'DisplayType' => "RESOURCEDISPLAYTYPE_GENERIC", 'Usage' => "RESOURCEUSAGE_CONNECTABLE", 'LocalName' => "D:"...

I wrote a stored procedure and I am getting an error that tells me I have an invalid column name 'FclsA'. Here is an excerpt from my procedure where the error is coming from: SELECT DISTINCT ClientId, Account, Famno, ApplSeq, CAST('FCLSXXXX' AS VARCHAR(8)) AS 'FclsA', CAST('FCLSXXXX' AS...

After a lot of trouble, I found a way to use MS Access to make my reports look pretty while using stored procedure located in MSSQL Server. Here are the steps I used without complete detail. This documentation should help you get started and may even be enough to complete your task, depending on...

In a previous thread (thread183-1120970) I obtained some information that helped me to get the last day of a month if I provided a date. Here is the function I created in MSSQL: [code] CREATE FUNCTION fn_GetLastDayOfMonth (@date DATETIME) RETURNS DATETIME AS BEGIN SET @date =...

How do I get Mail::Sender to handle mix languages, but more importantly the following Chinese characters when sending email: ??????? Michael Libeson

I am trying to send emails to clients and I have some pre-formatted text at the top of the body of the email then I have a digital signature that I need to add before the end of the body of the email. Please help me get the text and inline image to work correctly. The email is sent but the...

Below is the error message I get: DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '@P1'. (SQL-42000) [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) at...

OK, so I have this PERL script that I have been using for some time now. I used to use in a NT environment with an older version of PERL. I am currently running on Windows 2000 and a newer version of PERL. I even have used the same script to process the same files successfully. All of a sudden...

When running a perl script from a windows 2000 server command window, a GUI pops up as programmed and is active. After clicking a button in the active window, the window closes and a new window pops up, but the active window is the command window and not the gui window. I have tried focus and...

Software Version Info: GreatPlains eEnterprise 6.00g52 Dexterity 6.00m069 Explorer 6.00.15 Windows2000 SP3 Build 2195 Printers: HP LaserJet 4300TN HP LaserJet 4000N Connecting via Citrix Problem: When trying to print 40 day collections, the job hangs somewhere between the 25th and 30th...

Can anyone help to increase the speed of my code snippet. I use the code to parse a web log that is formatted in any variation of the Common Log Format (CLF). It breaks every record into fields that I will use for analysis later. $main::tlp = $main::readline...

I am currently running Win2000 server with Active State's Perl 5.8.0 installed. I have tried to run the follwing: ppm install Spreadsheet-ParseExcel.ppd I am using an unpackaged Zip file that I downloaded from Active State since the computer I am trying to install the module on is not...

Using a set of ASCII data files, I have written PERL code that process the data to produce output. The first time I wrote the code, the data was processed in 20 minutes. Next I modified the same code where the only change was that I stored hashes until I processed all files instead of clearing...