Search results for query: *

Does anyone know how to create a crystal report using an existing dataset? The dataset is currently been filled with an access db. I am trying to use the dataset to fill the information that I want to display. Everytime I call the routine I received an error "object reference not set to an...

I am trying to download files from a ftp server using DTS. I was able to add the files and download the information manually, however when I schedule the dts to run at a schedule time I get an error: DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 0 (0) Error...

Does anyone know how I can read table values using VB Scripts and DTS? I am trying to read information store in an sql table, the information in this table is the file name, location and destination. What I need to do is check if files are avail on a source path if so, the file needs to be move...

Can any one tell what is wrong with this query. I am trying to update information based on the parameters,I get an message 0 rows effected. However, if I do it manually it works. -SET @SQL=' UPDATE tblAIAttachments SET Div=' + @Div + 'SET Account =' + @Account + 'WHERE Div=' + @Org_Div + 'AND...

Can someone tell me what is wrong with this function. I am receiving an error near begin on line 200. I have display part of my code. CREATE FUNCTION dbo.fn_MonthlyUpdatesCalculation (@StartDate datetime, @EndDate datetime) RETURNS TABLE AS BEGIN DECLARE @MinAudits int, @WorkDays int SET...

Can anyone help me. I cannot get this sql statment to excute. What I am trying to do is select record from record set and delete those records in the table DELETE tblAI FROM tblAI WHERE(SELECT Div, Account, CorrespondType, COUNT (Account) AS Inquiries, MAX(MediaDate) AS MediaDate FROM...

I cannot figure how to load a ADO recordset from a stored procedure. Does anyone know how this can be done.

I am trying to open a pdf in vb net and preview the file in a mdi form. I don't want to use System.Diagnostics.Process.Start becuase this runs the application. My goal is to preview the file in a form using a preview dialog. Thanks in advance

does anyone know how I can display a print icon on the statusbar when there are jobs printing?

I am receiving this error everytime I try running this query Error in list of function arguments: '=' not recognized. Unable to parse query text. What I am trying to do is compare the value in one field and change the value based on the condition. List below is my SQL SELECT Div, IIf([Div] =...

I am using a crystal viewer to display my reports. However, We I try running the report I get this Database Login this require me to enter server, login and password. The information that is feeding the report is from a data set. Here is how I am declare my information Dim rptPrint As New...

I am trying to use the finditem in a listview but I am receiving an error 'FindItem is not a member of the listview'. I have research this in the msdn and other web site but with no success i still cannot get it to work.

Does anyone know how I can highlight an item in the the listview. I have try lstvwAI.Items(0).Selected = True this does not work. any idea

I a SP which I have different where clause however I am unable to find the error. Can you please help me or direction on how I can accomplished the same thing REATE Procedure AIRetrieval @AssocNum bigint, @Criteria as char(1) as Select * from tblAI Where Case @Criteria When 'P' then...

I am very unfamiliar with treeview. I am trying to add data however I cannot figure how to add the child. Here is what I am trying to do to add the parent. .Nodes.Add(drCurrent("Store")) Does anyone know how to add the child.

I would like to use a case statement to determine the day of the week i.e. Sun =1 Mon = 2 etc. The information is being supplied from a SP. The user will type in the day of the week (mon,tue, etc) and I want the SP to determine the numeric value. I have provided my SP. CREATE Procedure...

Having a little problem with formating time in a text box... Attempting to format a time as hh:mm tt in a text box and it won't return a value. txtstart.text=format(txtstart.text,"hh:mm tt") Thanks in advance

I currently have a listview, I would like the user to click on the listview and select the item they want to edit. I am able to display the information from the listview to the textbox once. However, when the user clicks on another item I receive an error "out of range". How would I display the...

I have researched on passing values from one form to another, however I am unable to find what I am looking for. I have a main form with information obtain from a SP with a parameter field. The second form is like a search form, which I want to fill in a field in my main form. My goal is to...

I have two fields in my table, one field is updated when the employee is hired. The second field is the term date, which this field is null until the employee has resigned their position. I would like to default this field with the employee's hiredate. How do I do that? I have try default value...