Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Adam95

    Variable no. of Fields in DTS Import File

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

    What's the best way to pass info from a temp table to VB?

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

    Linking Access 2000 to VB6

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

    invalid column name

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

    Datagrid 6.0 control Question

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

    Adding totals of summaries

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

    Connect to SQL-server...?

    That is correct
  8. Adam95

    Connect to SQL-server...?

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

    How do I editing a record in SQL Server 7 using ADO

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

    How do I editing a record in SQL Server 7 using ADO

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

    Help with Function

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

    error when % is at the begining of a search string

    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 & "'"
  13. Adam95

    Does "set DB = Nothing" mean the same as DB.close??

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

    Updating and Reading Records in Access via ADODC controls.

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

    Data Report, class not registered

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

    Combo data to text box

    What you could do is on the click event of the combo box, check if text1 is empty, if its empty fill it with combo1.text, if it is not empty, then check text2, if its empty fill it, if its not goto next text box...etc Private Sub Combo1_Click() If Text1.Text & "" = "" Then...

Part and Inventory Search

Back
Top