Recent content by Adam95

I had the exact same situation come up. In my case there would sometimes be a middle name field and sometimes not. When you tell the DTS package what file you want to bring in it get the layout of the text file(ie. # of field) from like the first 200 rows. Thus if the middle name field was...

At the end of the stored procedure could you SELECT * FROM #temp and hook a dataconnection to the storedprocedure? Adam

If I remember corrected there is a patch for accessing Access 2000 in VB 6. I had the exact problem, go search the knowledge base. SP5 for VB6 may cure the problem.

You must put the OWNER.TABLENAME.COLUMNNAME if the table has a different owner than the stored procedure, Example: If I was listed as the owner of a table and dbo is the owner of the stored procedure, to reference a column I would have to type atkisad.tblInventory.Orders If the table and...

Have you tried dataenvironment.refresh This should probably go in the afterupdate code of the order number field. Have the variable of the stored procedure = the .text of the order number field, run the stored procedure then do a dataenvironment.refresh, you may also have to refresh the grid...

You may try clicking on the detail for the item you are wanting to total, click on Insert from the toolbar and click Grand Total, this should give you a grand total at the end for that field. Hope this helps Adam

That is correct

Try this: Dim Application As CRAXDRT.Application Dim Report As CRAXDRT.Report Set Application = CreateObject("CrystalRuntime.Application") Set Report = Application.OpenReport(ReportFile) Report.Database.Tables(1).SetLogOnInfo "in01-sql03-nt", "QualityDevl&quot...

Rac is exactly right, you are not allowed to update an identity field. Identity field is kind of a row identifier for the DB to use. NEVER allow the user to edit an identity field, and the programmer should NEVER update the identity field IMHO. Adam

rs.open "Select * from tblTable1",[valid connection],[option],[option] rs.[field1] = Text1 rs.[field2] = Text2 rs.update rs.close simple as that

I would suggest using a select case Select Case cboEquipment0.text Case "Combine" EF = 70 F = (((S * W) * (EF / 100)) / 8.25) txtEquipment0.Text = F Case "Disk" * insert code here* ETC..... End Select Then all you have to change...

Been trying some tests to try and re-create this error but I cannot. I do have 2 suggestions. 1. Try putting the % sign on both sides of the strInput 2. Do not include the % in the strInput try something like this: LIKE % & '"strInput & "'"

You should use all 4. First close the recordset, then the database, then set them both to nothing. This will free up alot of resources for you and your end users. Hope this helps. Adam

It looks like your table has and index and/or key on some column. I would take a look at the indexes and keys for that table. One way to make sure the record you just added will be at the end without doing a movelast before you save is to make an autonumber field as a primary key for the table...

That CLSID is the Class ID in the registry. You may want to try and register that dll or better yet unregister then re-register it using regsvr32. Example: regsvr32 MSDBRptR.dll --this is to register regsvr32 -u MSDBRptR.dll --this is to unregister Run these under the Start Button, and Run...