Recent content by SkyHigh

This is how it shows up in the error logs of the database if it helps you guys to help me Thanks ,NEXTVAL('_seq_monthly_invoice_no_'),' . 0) From backend> E From backend> "ERROR: parser: unterminated quoted string at or near "' ...

Hi Folks There is something wrong in the 2nd last line because of which the insert statement is not coming out right, can someone please help me Thanks my $SQL_Insert ="INSERT INTO summary VALUES ('" . $LastDayOfMonth . "', " . $summrow{'id'} . ',' . $summrow{'alimit'} . ',' ...

Ok I figured out how to get the date I asked above with the following routines : $date3 = DateTime->now->truncate( to => 'month' )->ymd; #EndDate $date4 = DateTime->now->truncate( to => 'month' )->subtract( months => 1)->ymd; #StartDate Now I need to just year and month for $date4 in MMYYYY...

Thanks Jim for your help, I would also need to get first day of the current month and first day of the last month, also is there a way to get the output in YYYY-MM-DD format. Thanks much Brenda

This is great thanks, I will really appreciate if you can make it a function so I can imbed it in my existing script to set various dates for some variables like : my $forward_bal_date = your_function(2); my $open_bal_date = your_function(1); which should return date in yyyy-mm-dd format...

Hi Folks I need some routines to get the following dates from any given day of the month : Last day of the previous month Last day of the month before previous month I am using the following routines which breaks for leap year ($sec,$min,$hour,$mday,$month,$year,$wday,$yday,$isdst) =...

Hi Folks I need VBA code to create a new access database into a given path, give it a name and export a couple table into it from within an access application. Your quick help would be greatly appreciated. Thanks Brenda

The problem I am facing is a large set of records being buffered in the memory fetched by ADO and I believe it remains in the memory until the last record has been copied and the recordset is set to nothing ? Can someone please give me some good ideas how to overcome this problem, some code...

ADO to fetch dataset from remote_table and DAO to coputhe dataset into local access table. Please let me know of using ado also for the local table would help ? Thanks

Hi Folks I have to import large amount of data from remote database into local access tables using ADO and DAO via ODBC - the data involves about 2 million rows in one table, if the data is not that large it goes smoothly otherwise it results in out of memory error, is there a more effecient...

Hi Folks I am having a problem with the following ADO/DAO routines, if an address field contains double quotes (") it runs into errors, there are single quotes as well in the data I am dealing with, so is there another way with which it would be able to deal with double, single quotes and...

Hi Folks Has anyone written a code to send emails silently in the background using Redemption utility with outlook express, I need to convert the following routines for Redemption, can someone kindly help me with that. I am using outlook 2002 as client and I am not using MS Exchange Server -...

Great PHV !! Thanks for coming to my help once again !! Brenda

Can someone please help Thanks!!

Hi Folks I need some routines in VBA to check if a registry entery exists if not then add it. The registry entries required are as under HKEY_LOCAL_MACHINE/SOFTWARE/PetersSoftware/Button Painter, Install Folder C:/Programme files/Peters Software/Button Painter...