Search results for query: *

Hello: It will greatly appreciated, if someone can provide a link or can this be done with the datepicker control...

Hello I have selected from MS WORD 2007, Developer section the Date Picker and set the Title and Tag to TargetDate. I would like the end user to select only today or future dates and not be able to select past dates. Past dates can either be grayed or not be available. I have added following...

DTS package created to download FTP files. All task are performed successfully, files are pulled view FTP task on to the destination folder. I can see the file populated under the dest folder. DTS package message displayed successfully loaded but file gets deleted from the destination folder...

Thanks you for you the quick response. Insert into was changed and worked Dim sql as string sql = "insert into Prescriber select * from " & _ "[ODBC;Driver=SQL Server; " & _ "SERVER=NEWPASQL1;DATABASE=DBRPT;" & _ "TRUSTED_CONNECTION=yes;]." & _...

I have been getting Syntax error in INSERT INTO STATEMENT. TRIED INPUTTING DIFFERENT STATEMENT. WAS UNABLE TO FIND ERROR. NEW AT VB THANKS IN ADVANCE. PleasePrivate Sub cmdCreate_Click() If CreateAccessDatabase(txtDatabaseName.Text) = False Then MsgBox ("Database...

Option Explicit '----------------------------------------------------------------- Private Const MAX_PATH = 255 '----------------------------------------------------------------- Private Declare Function GetTempPath Lib "kernel32" Alias "GetTempPathA" (ByVal nBufferLength As Long, ByVal lpBuffer...

OPEN VISUAL BASIC EDITOR MODIFY COPY AND PASTE AND RUN Sub SendersInFolder() Dim onsMapi As Outlook.NameSpace Dim oFolderSource As Outlook.MAPIFolder 'Dim oFolder1 As Outlook.MAPIFolder ' ENTER ACTUAL NAME FROM FOLDER ABC 'Dim oFolder2 As Outlook.MAPIFolder ' DEC Dim oFolder3 As...

END SELECT is missing prior to Case 2 ' Type Case 3 ‘SP End Select under Public Function fSelectSQLGrid(iGrdSQLIndex) As String Please not change made to logic thanks spag

Form created with following lblMessage ,MSflexgrid, cmdsearch , optName, & optNumber, Table exits under sql ------------------------------------------------------------ 1.clsADO connection program is connecting correctly to sql via clsado...

Thanks a lot, it works. I just need to twig a little to obtain dates in year 2004 and also try a input box to pickfolder. Next step is to count emails by month Thanks a lot. spag

Need help!! vb code It is urgent, please help This code is a macro under MS OUTLOOK It works, but I need to save strreport info into word/excel/text file Tried to enter a line as strreport.saveasfile "c:\report.txt" give me an compile error. instead of " MsgBox strReport " It is urgent...

You are great. It works. Thanks a lot for you quick response Jon. Can you please look at my old thread to which no one has replied when you get a chance? It will be greatly appreciated. spag

Data was downloaded from a text file. Data type of Amtpay column currently is char(11). Amtpay have both negative and a positive numbers Need to convert char to money id amtpay ---------------- ------------ 0415 .54 0416 1.67...

Table that has the following layout or customer id, begindate and enddate. Cust begindt enddt abc 1/16/2003 1/16/2003 abc 2/20/2003 2/20/2003 abc 3/11/2003 3/13/2003 abc 3/25/2003 3/27/2003 abc 4/15/2003 4/15/2003 abc 4/17/2003...

I have a table that has the following layout or customer id, begindate and enddate. 1.updated field prevenddt select a.cust,a.begindt,a.enddt daysprev = 0 ,(select max(enddt) from #t1 as c where( c.cust = a.cust and c.enddt < a.enddt)) as prevenddt into #t2 from #t1as a 2.calculated daysprev...

Please add an extra row to the original table: 12345 9001 9/1/2003 9/20/2003 - Row # 9 Goal is to track all customers that exist in the database whose shipment occurred within 45 days from the next order date for each customer. As you see that by doing step 1 –...

Looping ???? I am a new at sql and try to obtain faster results. From the database, the ultimate result should be to show customers whose number of days is less than 46 from the first ship date to next order date (which is greater than the ship date). Cust ivoice orderdt shipdt 12345 9899...