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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ropewrench

  1. ropewrench

    Math Formula problem

    Having problems with a seemingly simple formula in Crystal 8.5 (also tried on demo version of Crystal 11) Using Basic Syntax: dim qtya as number dim qtyb as number qtya = (176/91) qtyb = 176 Formula = qtyb/(qtya) Results on Report: 91.00 Should get 91.003 (field is formated to 4 decimal...
  2. ropewrench

    Could not find installable ISAM

    Thanks for the tip, we will try the MDAC to see if that makes a difference. We did verify that the path is correct for the files, so that is not the issue. In the link you provided the overview states: "This release does not include Microsoft Jet, the Microsoft Jet OLE DB Provider or ODBC...
  3. ropewrench

    Could not find installable ISAM

    I just started receiving this error after 3 months of flawless operation Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: Could not find installable ISAM.] Here is the code that is being processed...
  4. ropewrench

    Export SQL data update to Excel

    LNBruno, That is exactly what I did. The SP deletes the Excel file, then using an Excel template which is copied to a new name replaces the deleted one and this is then attached for sending. It works pretty good. respectfully, ropewrench
  5. ropewrench

    Export SQL data update to Excel

    I am trying to send the information from a query on SQL server table to update an existing Excel spreadsheet. (Not append to it. My initial INSERT works fine but I really want to have it update instead. DTS is not an option at this time. Attached is the code. Any help would be greatly...
  6. ropewrench

    SQL Mail pull recipients from list

    Never mind, found my own answer. -- ****** Declare and find Email Distribution List ******* declare @emaildistribution varchar(128) select @emaildistribution = RTrim(RinAutoEmail.MailingDistribution) FROM RinAutoEmail WHERE db.ReportName = 'BelowMin'; use master declare @sendmail...
  7. ropewrench

    SQL Mail pull recipients from list

    I am looking to pull recipients for xp_sendmail from a table and insert them into a varible on the @recipients. Is this possible? The table holding the addresses is fine and inserts the specified address into the variable. However get the error: Server: Msg 18031, Level 16, State 1, Line 0...
  8. ropewrench

    Help adding new data to a subform

    I wanted to post a thanks for the help. The problem was a design flaw with the Master/Child link between the main form and subform. I needed to remove the links and redefine the relationships between the corrisponding tables. That was also the other problem, the main form did not need a...
  9. ropewrench

    Help adding new data to a subform

    TheAceMan1, Thank you for the response. I will try and give as much generic information as I can due to company restrictions. 1. Are the tables linked in a relationship to each other? Yes 2. 1:M relationship: tblOne.fldUnitNum to tblTWO.fldMaintUnitNum 3. Master; cboUnitNum to Child...
  10. ropewrench

    Help adding new data to a subform

    I know I am missing something very simple in this but I am in need of help. I have a form based on 2 tables. When the form opens it opens as acAdd. The main part of the form has a combo box where user selects an item. The subform is datasheet where the user is supposed to enter new data relevant...
See more

Part and Inventory Search

Back
Top