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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Fletch12

  1. Fletch12

    Automatically Scroll Down Page

    How can I setup a SQL Report I've built using Report Builder 3.0 to automatically scroll down the matrix and then move to the beginning once it reaches the bottom. Should I create a style sheet? If so, please explain how to do this.
  2. Fletch12

    Join Tables Based on Most Recent Date

    I have two tables, with sample data as below. I need to be able to find the stock value from Table1 for each item. But I need to find it for the supplier of the most recent receipt. I've highlighted the records from Table2 with the most recent dates, and shown the desired results I need at...
  3. Fletch12

    Retrieve Column Name of First Column Where Value Less Than...

    I was able to get this working. Thanks for the help!
  4. Fletch12

    Retrieve Column Name of First Column Where Value Less Than...

    This works, but it's more complicated that I originally posted. The 20,000 value was just an example. This value can be different for each item, and is derived from another field in a different table. So I need to be able to loop through Table2, and for each item in Table2 return the MAXDAYS...
  5. Fletch12

    Retrieve Column Name of First Column Where Value Less Than...

    Unfortunately I have a poorly designed table that I need to query. The sample data and desired query result are listed below. I need to write a query that will result in the first column name that's found where the value is less than 20,000 (for example) for that item. If it's not possible to...
  6. Fletch12

    Find TextBoxes with Equal Values

    I have four textboxes on a single form. How can I search the values in these textboxes to determine which contain equal values to the other? So textbox1 can equal textbox3 and textbox4, but not textbox2. Or textbox1 can equal textbox2 and textbox3 can equal textbox4, but textbox1 not equal...
  7. Fletch12

    Add 3750 as Gigabit Backbone to LAN

    Thanks brianinms. That worked!
  8. Fletch12

    Add 3750 as Gigabit Backbone to LAN

    Here is the "sh run" output from both switches. Thanks. 2950 Switch sh run Building configuration... Current configuration : 2083 bytes ! version 12.1 no service pad service timestamps debug uptime service timestamps log datetime no service password-encryption service sequence-numbers ...
  9. Fletch12

    Add 3750 as Gigabit Backbone to LAN

    I am by no means a Cisco expert, so I apologize for my limited knowledge on this ahead of time. We currently have three Cisco 2950 switches. These are currently connected via the fast-ethernet ports. However, we also have a 3750 switch, SFP SX transceivers, and 1000BASE-SX SFP modules (for...
  10. Fletch12

    Backup Exec 10 - Autoloader Errors

    I have been struggling with an issue for months now. I have an HP 1/8 Autoloader with an Ultrium232 drive. I am constantly getting A0 and A1 errors on the loader and my jobs in Backup Exec just hang until power is cycled on the autoloader. I occassionally get good backups, and after a day or...
  11. Fletch12

    Received TKIP Michael MIC failure report

    We recently moved to a more secure WLAN using WPA encryption. Now at various times throughout the day all the clients connected to the AP are disconnected. The errors in the event log of the AP are, "Received TKIP Michael MIC failure report from the station <####.####.####> on the packet...
  12. Fletch12

    Logon Failure

    I tried to use the rsconfig.exe command line utiltity to simply update the credentials, but am now receiving this error, "The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.6.43'. The expected version is 'C.0.6.51'...
  13. Fletch12

    Logon Failure

    Unfortunately, this is 2000. Any ideas for 2000?
  14. Fletch12

    Logon Failure

    I setup Reporting Services a few months back, and evidently must have configured it to run under my domain account, because since I updated my domain password I am unable to execute any of my reports or access the Report Manager. I received the below error message when attemmpting these things...
  15. Fletch12

    Restrict Access to All Pages Except One

    Is there any way to restrict users access to all but one page of a domain... Example: http://www.microsoft.com/en/us/default.aspx - OK to access http://www.microsoft.com/presspass/press/2008/aug08/08-04CashbackDealDaysMA.mspx - NOT OK to access Thanks.

Part and Inventory Search

Back
Top