Search results for query: *

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

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

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

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

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

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

Hi Folks I am using the following code to zip up a selected folder but it doesn't work and I get the msg saying the file doesn't exist but it does exist, please help - thanks ---[Code]--- Set objFSO = CreateObject("Scripting.FileSystemObject") sTempZipFolder = "c:\Temp"...

Hi Folks I remember having seen in samples provided by Microsoft showing Continous form as master with a subfom but don't seem to find one, can someone pls show me how that can be done. Thanks Brenda.

Hi subject says it all, I want to get full month name i.e. January instead of just Jan with fist letter being in upper case, out of a given date Can someone please help me. Thanks much Brenda

Hi Folks I have a sample with treeview, which is actually designed to display data from the database, what I want to do is to display folders in the treeview and open selecting a node it should display the files in the listview, the code used in the form is as under, can someone please help me...

Hi I am populating names of files in a folder in a listbox, what I need to do is to open the file shown in the listbox column by double-clicking it, the following code doesn't work. Thanks for your help Brenda ---Code--- Private Sub lstFile2_DblClick(Cancel As Integer) On Error GoTo...

Hi Folks I would like to know how do raise custom exceptions in VBA and halt execution of any subsequent code. In my case I have various public functions which check for certain information in the database, I am calling these functions from a command button whereever suitable, but what is...

I am trying the following routines in one of my functions and I get runtime error 424 : If Not Object.FileExists(CurrentProject.path & "\Archives\Reports " & ccmonth & ".mdb") Then fs.copyfile CurrentProject.path & "\" & CurrentProject.name...

Hi Folka Is there a way I can close all opened forms and reports using one command button. Thanks Brenda

Hi Folks I have a pivot table form, I need some VBA routins to transfer pivot table on form to excel without actually opening this form i.e. from a command button on another form. Your help is appreciated. Brenda

Hi Folks I have an application that gets new data at the end of every month, what I want to do is to first call some routines to copy the application with a new name ( in other words back it up ) before getting the new data. Can someone please give me some ideas as to how I can do it. Thanks...

Hi Folks Is there a workaround on the subject limit, or how can I direct the output to a new worksheet once it reaches the max rows limit Here's the snippet of the code I am using : *** Set RsrDetail = db.OpenRecordset("SELECT * FROM tblOrderDetails") nbRows =...