Search results for query: *

I have this code which works am tring to put in some error hadling how ca I do that? I want to check for an error before Execute statement. Private Sub cmdAddTaskToProject_Click() Set cmd = New ADODB.Command With cmd .ActiveConnection = cn400 .CommandText = "INSERT INTO...

Am new to vb and functions . How would I create a function for date conversion? here is my code for date conversion. How can I pass a date field into a function and receive a value back into my txtfield? Dim fldDate As Double Dim fldMyDate As Date Dim fldMyDateStr As String fldDate =...

Hi, I have a field coming back from the database which is Numeric 8 position (19930203) I want to convert it into 02/03/1993 how would I do that?

Am tring to join to files in vb here is my code what am I doing wrong? Set cmd = New ADODB.Command AdoLoadTasks.ConnectionString = cn400 AdoLoadTasks.RecordSource = "SELECT * FROM ENPRAWD02.PRJTSKPF a " _ & "JOIN ENPRAWD02.TSKPF b On a.tsknbr =...

Anybody has a suggestion? Set cmd = New ADODB.Command With cmd .ActiveConnection = cn400 .CommandText = "SELECT max(PRJNBR) FROM ENPRAWD02.PRJPF" .CommandType = adCmdText Set objRecordset = New ADODB.Recordset objRecordset.CursorLocation = adUseServer...

I get this error message and I can't figure out why here is the code where I get it. '-------------------------- Private Sub Find_Employee() '-------------------------- On Error GoTo errorhandler Dim SQL As String SQL = "select * from [Employee Data Table]" & _ "where...

Hi, I got a problem am tring to convert this date field and am getting this error message. Please help Dim fldRequestReceiptDate As ADODB.Field Const DATEFORMAT = "MM/DD/YYYY" txtRequestReceiptDate.Text = Format(fldRequestReceiptDate, DATEFORMAT) Or is there a way to conver...

Original definition: Sub Load(Optional ComponentID As Long, Optional ProductID As Long, Optional ConfigurationID As Long, Optional ComponentStatusCode As String, Optional ProductClassID As Long, Optional ProductCategoryID As Long, Optional ProductTypeID As Long) Current definition: Sub...

Hi, I got a question. I have a vb5.0 project I have made some mosd to one of the Modules in this project. Now I need to move it to clients pc. We havea deployment package for this project. Is there a way to add the new module to this package so that the user will see the new change instead of...

Hi, I got this problem I can't figure out how to pass a parm from VB to Crystal Report 7.0. Am adding a crystal report to my VB project using Data Environment .DSR file. I have one parameter I can't pass that parm into my crystal report. Any Ideas ??????????????? Please Help...