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: *

  1. Kenhardwick

    Email from Notify Not Working

    As I indicated in my original post, the email is working for sending scheduled reports so do not believe that the account for the email has been dropped. Didn't update the server ?? I guess something could have changed that I didn't know about. What would I check to see if the notify was/is...
  2. Kenhardwick

    Email from Notify Not Working

    Seagate Info 7.5 - Win 5.0,NT-CIINFO.MDB At one point in time, the Notify Email worked but for some reason stopped working. We do not get an email when scheduled report fails and notify has been setup. Emails from scheduled reports continue to work. Any suggestion on how to research/resolve...
  3. Kenhardwick

    How to Automatically Open Excel Workbook with Data from ASP Page

    I am using <%Response.ContentType = &quot;application/vnd.ms-excel&quot;%> in my ASP page to generate Excel formated data. Right now, this opens a ASP page in the web browser that looks like an Excel page. Looks great but.. What I would prefer is have it open Excel on the users workstation...
  4. Kenhardwick

    Error when Exporting to Excel from Web Report

    I have some Crystal/Seagate reports setup to run on the web thru ASP pages. The reports work fine and I can export to *.rpt, *.doc and *.rtf, however I get the following error when trying to export to *.XLS CRAXDRT error occurred on Server.20541 Error in File... ..rpt: Error detected by export...
  5. Kenhardwick

    Attendance Records Display

    You might try bringing in your table twice. And linking on the personid. The criteria on the first table would be looking for the Z and the date range. The criteria on the alias table would be for the date range. You may have to do some groups and put the detail data on the group row to keep...
  6. Kenhardwick

    ASP forums

    Check out...http://www.youngpip.com/
  7. Kenhardwick

    Web Reporter Not Working

    Tom, Did you find a solution to this problem ? I had some web reports that were working just fine for me and then ,all of a sudden, I just started seeing the &quot;done&quot; with no results. Would appreciate any solutions you might have found.. Thanks... ken@kenhardwick.com
  8. Kenhardwick

    Setting the width of the page

    Jim, Excel Export... Yes, in fact, the main reason I had came up with this ideal was because I design a lot of reports that are created specifically to export to excel. So, this works great for that. And, of course, I usually hide all the sections except the header and the detail line, so it is...
  9. Kenhardwick

    Setting the width of the page

    In fact, more specifically, install &quot;Hewlett-Packard HP-GL/2 Plotter&quot; and you will be able to select a page that is 44in wide using lanscape.
  10. Kenhardwick

    Setting the width of the page

    I have had the same problem and came up with this solution...I installed a dot-matrix printer (even thought I do not have the printer) and then setup a custom page using the maximum value and then select my dot-printer using this custom page. Ended up with an extremely &quot;wide&quot...
  11. Kenhardwick

    Writing to Oracle using stored procedures

    See the article/download at http://www.15seconds.com/issue/010718.htm The downloadable ASP file will actually write a function to use your specified procedure. It is great !
  12. Kenhardwick

    Looping thru variables -Need function to get value of string

    I have say five variables named, field1,field2,field3,field4 and field5. And, I want to loop thru those five variables and want to do so thru code, like... field1 = 5 field2 = 1 field3= 3 field4= 4 field5 3 total= 0 For cnt = 1 to 5 nextField = field & cnt Total = Total +...
  13. Kenhardwick

    Tutorial searching (MS-Access - ASP - Webpage)

    Also, check out ASP tool...genericdb www.genericdb.com This is a very easy to use &quot;tool&quot; that makes it very easy to put database info on a web page with ASP code..and to be able to edit/add new info to your database. Very much worth checking out... From his webpage : <What Is...
  14. Kenhardwick

    What's the word on Recrystalize?

    We have used &quot;Recrystalize&quot; to create ASP files for our intranet phone book reports..&quot;easy to use&quot; and works very well. Highly recommended... Ken Hardwick Norman,Ok
  15. Kenhardwick

    how to create dynamic report in crystal report 8.0

    Here is the method I have used to do this. 1) Create a parameter field (for instance..call it &quot;Parameter1&quot;) and set default values of &quot;Employee Code&quot;,&quot;Name&quot;,&quot;Address&quot;,&quot;Salary Details&quot; Place this Parameter Field in Report Heading. 2) Create a...
  16. Kenhardwick

    List of "view" tables and List of Fields in a table

    The following SQL gives me a list of all tables in<br> our Oracle database. FYI - I am executing this SQL using<br> VBA in Excel using Oracle73 driver.<br> <br> Select TABLE_NAME<br> from ALL_TABLES<br> <br> I would also like to get a list of &quot;view&quot; tables. <br> How would I do that...

Part and Inventory Search

Back
Top