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 Shaun E 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: Danman75
  • Content: Threads
  • Order by date
  1. Danman75

    All new error converting data type varchar to numeric

    I have a view using this line of code: isnull(Sum(Convert(decimal(10,2),credit_balance)),0) as creditamount Basically, it takes a value that is currently in a varchar type, changes it to a decimal and adds it up. I'm able to run this view with absolutely no problem. However, if I call this...
  2. Danman75

    ADO Recordset

    How do I change the sql statement in a query using an ADO recordset? I know how to do it in DAO (.SQL) but I'm trying to use ADO for consistency.
  3. Danman75

    How do I make a recordset the recordsource of a form?

    I need to know how to do this in ADO not DAO.
  4. Danman75

    Passing parameter in pass-through query using ADO

    I know how to do this using DAO but I need to use ADO instead so I can keep my programming uniform. In DAO you can change the SQL in a query using recordset and querydef but I can't figure out how to do this in ADO. The SQL statement in my pass_thru query is: EXEC sp_RefusedSales.
  5. Danman75

    DTS Disenables itself . . . sort of

    I have a DTS package that runs every 5 minutes from 8am to 10pm. It's set to do this 6 days a week with no end date in site. When I check it the following day in Management->SQL Server Agent->Jobs, it shows that the scheduled job is still enabled, as it should be. However if I look to see...
  6. Danman75

    Reports stuck on Portrait Orientation

    I have a database in Access Project that only I use and have been using for several months. Today is the first time I've had a problem with the report orientation. All of them are stuck on portrait and I can't change it back to landscape when I'm in print preview. Please help!!!
  7. Danman75

    Import a pdf file into sql server

    I have a pdf file that I need to import to a table in sql server. I'd like to use DTS but I can't find anything that will work with this type of file. If there's not a way to do it through DTS, I'd like to know if I can open it in excel so I can import from there. Please help!
  8. Danman75

    Temporary Table Reporting

    Is there a way to use a global temporary table as the record source in an access report? When I try, it tells me that the table doesn't exist.

Part and Inventory Search

Back
Top