Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SkyHigh

    Syntax problem - please help

    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 "' ...
  2. SkyHigh

    Syntax problem - please help

    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'} . ',' ...
  3. SkyHigh

    How to get various dates

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

    How to get various dates

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

    How to get various dates

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

    How to get various dates

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

    VBA routines to create a new access db

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

    Importing large amount of data from a remote database into access

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

    Importing large amount of data from a remote database into access

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

    Importing large amount of data from a remote database into access

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

    Please help with the following ADO/DAO routines.

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

    Outlook Secrity popup bypass with Redemption

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

    Writing to registry using VBA

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

    Writing to registry using VBA

    Can someone please help Thanks!!
  15. SkyHigh

    Writing to registry using VBA

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

    encrypt/decrypt data

    Hi Folks Does anyone have some code to encrypt and decrypt data in a particular field of a table. Thanks Brenda
  17. SkyHigh

    Reliable code to create PDFs in Windows XP

    Please help !!! Thanks
  18. SkyHigh

    Reliable code to create PDFs in Windows XP

    Is there a reliable code to creae access reports in PDF format under windows XP. Thanks much !! Brenda
  19. SkyHigh

    Winzip (wzzip.exe) via access

    The problem was with the winzip switch I did some research found the right switch and it works. However, Here's another problem, what I want to do is to zip up a selected folder and send it by email and what happening is that ithe zipping process takes a while which code doesn't wait for - how...
  20. SkyHigh

    Winzip (wzzip.exe) via access

    Please help me !! Tks

Part and Inventory Search

Back
Top