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!

  • Congratulations Chriss Miller 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. CosmoKramer

    Extreme political correctness???

    Is this another example of extreme political correctness? http://www.cnn.com/2003/TECH/ptech/11/26/master.term.reut/index.html Hoc nomen meum verum non est.
  2. CosmoKramer

    Delete old DB reference

    We recently upgraded our SQL Server databases to SQL 2000. I have started modifying our reports that uses one of these databases. I have changed the report fields to the new server reference, but the report is still looking to log on to the "old server", as well as the new one. I...
  3. CosmoKramer

    Moving app from Win NT to Win 2000

    I have inherited an app that uses the following connect string in an .ini file: DB_CONNECT="Provider=SQLOLEDB;Network Address=172.16.5.238;Network Library=Dbmssocn;Database=SmhCensus" This app runs fine on an NT client, but not on a Windows 2000 one. I don't receive any error...
  4. CosmoKramer

    Limiting subreport results

    I have a main report that lists cancelled patient appointments. The user wants to see all future appointments for that patient as well. I created a subreport, linked that subreport to the main report by patient id. That subreport works, I see all of each patient's appointments. How do I now...
  5. CosmoKramer

    Extra blank record when exporting to Excel

    I have modified an existing report to suppress all headers, footers, etc. and only leave the detail section. The user wants to export this data to Excel. It works, except there is an extra blank record after each real record in the spreadsheet?? What am I overlooking??
  6. CosmoKramer

    Show parameter information when report is empty

    I have a report that is passed three parameters: start date, stop date, and dept_id. When there are no records for that particular department and date range, I would like a custom message to appear. Something like: "There are no appointments for department: Cardiology" I can display...
  7. CosmoKramer

    How to print page totals in your reports

    This can be done with just a little bit of code........ Add an unbound text box to your detail section (for example, txtSum) and set it to be invisible. In the On Format event of your page header section, put the following code: txtSum = 0 This will reset the variable to 0 for each new page...
  8. CosmoKramer

    How to print page totals in your reports

    This can be done with just a little bit of code........ Add an unbound text box to your detail section (for example, txtSum) and set it to be invisible. In the On Format event of your page header section, put the following code: txtSum = 0 This will reset the variable to 0 for each new page...
  9. CosmoKramer

    Keep subreport together on same page with detail

    In my main report I have a multi-line detail section that is grouped by a date/time field. Within that detail section I have a subreport. I want to keep the subreport together with the detail section, i.e., not start the next page with the subreport. If there is not enough room to print both...
  10. CosmoKramer

    Date Range for months with < 31 days not working

    I have a query that returns records from a user entered date range. If I look at the records in the table that meet the criteria for 4/2001 there are 22. The following query only returns 21 if the user enters 04/01/2001 and 04/30/2001 as the beginning and ending dates: SELECT...

Part and Inventory Search

Back
Top