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!

Search results for query: *

  • Users: ropewrench
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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...
  5. 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...

Part and Inventory Search

Back
Top