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 bkrike 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: sharkatek
  • Content: Threads
  • Order by date
  1. sharkatek

    how do I prevent a bare directory display of files

    I want to use the "403 Access Forbidden" type response to keep someone from trying to see a bare directory list of files. Can anybody help me? I use Front Page and have no experience with css. Thank-you in advance!
  2. sharkatek

    Additional validation needed for Front Page Form Fields

    I am using a simple Front Page form and am able to capture the IP address by checking the Remote Name box on the saved fields dialog box, but is there any way to validate with additional javascript code to keep a specific IP address from accessing the page? I am not using a database or ASP...
  3. sharkatek

    Front Page Forms - is there a way to validate IP address

    Question: I am able to capture the IP address by checking the Remote Name box on the saved fields dialog box, but is there any way to validate to keep a specific IP address from accessing the page? I am not using a database or ASP, just a simple Front Page form and I have a rogue person...
  4. sharkatek

    CreateObject error "The system cannot find the file specified."

    Hello, I have an application in Access 2000 that automates the execution of a Cognos Impromptu query. The version of Impromptu is 7.1 Here is the code to the point where the error occurs: Dim objImpApp As Object Dim objImpRep As Object Dim strReport As String Dim strCatalog...
  5. sharkatek

    Need to delete Excel file after importing into Access

    1 - I am able to successfully import an Excel file into my Access table, but I need to delete the Excel file after importing - how can I do this with VBA? 2 - When I display the "Import" form, I want to enable import buttons when a new Excel file has been created (by another process) and is...
  6. sharkatek

    Cognos Imp. Asynchronous open error

    Error number -237 DMS-E-GENERAL, A general exception has occurred during operation 'asynchronous open'. I have a report that runs rine when the filter limits the data to a value, but when I try to run it for the entire database, I get this error. I read the other posts after doing a search...
  7. sharkatek

    Impromptu "crashing" when trying to convert to crosstab

    I am using Cognos Impromptu version 7.1.339.0 and have created a simple list report that I need to convert to a crosstab report. When I need to make modifications, I go back to my original simple report and make the changes (to sorting, grouping, etc), save that, then save it as the crosstab...
  8. sharkatek

    Is there a better way than using Hot Files?

    Hello all, I am using Cognos Impromptu v 7.1.339.0 Please answer either or both questions: 1. Is it better to use a report as a query and pull information from there rather than creating a hot file from the report and then using it? 2. How can you save a dataset and use fields from it in...
  9. sharkatek

    How to get the (+) as a filter option? (for outer joins)

    Hello all, I have joined a table and a hot file and the join works ok sometimes, but not always. I want to force it to work by using the (+) for a left outer join, but the (+) is not an available option I in the filter tab. How can I get he (+) option added to the filter tab? Thank-you in...
  10. sharkatek

    Finding Reports that use a Specific Hot File

    Hi All, Can anybody tell me how to (please answer any question you can): 1 - Locate all reports (and their location drive, folder) that use a particular hot file? 2 - Open an existing report and determine WHICH hot file it uses and the location (drive, folder) of the hot file? 3 - If you...
  11. sharkatek

    What is a cube?

    What is a cube and can you give me a simple example of how it would be used? I am using Cognos Impromptu V. 7.1.339.0 with multiple catalogs. Thank-you! Sharkatek
  12. sharkatek

    filter on a calculated field

    I have a field I have constructed using three text values It is a Row-Shelf-Bin combination. I am COUNTING the number of unique combinations for one location. How can I filter on the counts that are > 1? Every time I go to the FILTER tab, my calculated field is not even there as a Report...
  13. sharkatek

    How to sort a TEXT field so numbers are in numeric order

    I have a text field with these (sample) values and they must be sorted. The default sort leaves me with something like this: BT01 CM201 10 100 10005 1001 101 1042 Is there any way to force the actual numbers to appear at the top in true numeric order followed by the values that start with...

Part and Inventory Search

Back
Top