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 derfloh 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. madonnac

    CHECKSUM mistery

    using MD5 will give you less chance of a collision (or, any of MD2 | MD4 | MD5 | SHA | SHA1 | SHA2_256 | SHA2_512 ) the hashbytes function takes an algorithm, and a single variable. e.g. select hashbytes('MD5','madonnac') : 0xD7CA39B7F7F21CB229DC3DA72E17C064 select hashbytes('MD5','COOK...
  2. madonnac

    Mon-dd-yyyy conversion

    slice the string up. Case will recognize date format #107 (mmm dd, yyyy), which is only slightly different to your format declare @d varchar(40) set @d = 'Mar-01-2016' select cast(left(@d,3)+' '+substring(@d,5,2)+', '+substring(@d,8,4) as datetime2) You should be able to use things like...
  3. madonnac

    Directory Tree keeps changing back to "Read Only" - Why?

    Chris, Add a /D to that, and it will also handle directories: ATTRIB -R *.* /S /D
  4. madonnac

    Excel 2010 Formuls - lookup across sheets

    VLOOKUP will also work for this =A1 & " " & IFERROR(VLOOKUP(A1,Sheet1!$A$1:$C$55,3,False),"is NOT on the Table")
  5. madonnac

    Outlook 2013: Sorting People in Contact Group

    Unfortunately, I only have 2010 and 2013 to check this, but there should be a proofing option, where you have an Autocorrect section. This should allow you to disable the autoformat of name and email address. As to the name/email fixing, this horrible looking formula will try to fix the data...
  6. madonnac

    Excel 2010 Formula Conundrum. Referencing a "" cell in a further formula

    ISERROR is an optimized version of IF(ISERROR( Cell(2) Cell J49 =K49/I49 would become Cell(2) Cell J49 =IFERROR(K49/I49,"") Note that this will trap all errors, so things like #VALUE! , #NA! and #ERR! will also be caught
  7. madonnac

    CMS Supervisor - only manual login working

    I am running CMS Supervisor V 16.2.KC.12 If I select manual login, I can log into the servers with no issue. If I uncheck that box, it just sits at "Initializing, and does not get any further. One server is R16.2, the other is R14. Both show the default terminal as cvsup on the manual login...
  8. madonnac

    Test if Dynamic SQL Statement Requires a Parameter

    With this code to run a stored procedure: Set cmdl = New ADODB.Command With cmdl .ActiveConnection = StrCon ' Connection to the Database 'set COMMAND timeout property - query can time out on either the connection OR the command .CommandTimeout = 0 .CommandText = "spCrossTabRun"...
  9. madonnac

    What is it with Win7 and shared folders ?

    Try connecting to \\OtherCompterName\c$ - the c$ is an admin share, which will require the Admin user/pass for that computer. Note that the admin password has to exist - a blank password will refuse connections from other computers using that name e.g. UN:AdminBlank, Password:<none> -...
  10. madonnac

    Sumif across rows and columns

    Index: use of the 0: If you set row_num or column_num to 0 (zero), INDEX returns the array of values for the entire column or row, respectively. or If you set row_num or column_num to 0 (zero), INDEX returns the reference for the entire column or row, respectively There is nothing wrong with...
  11. madonnac

    Sumif across rows and columns

    To sum a 3-D array, we need to use an array formula First, the easy part - The Section: (A2:A4="A") This will give us true or false for each row. Then we work down the rows, and see if the date is correct: IF(B1:D1<TODAY(),B2:D4) We multiply each row by the true/false from the section, which...
  12. madonnac

    Need formula modification help

    The easiest way is with an IFBLANK test. =IF(ISBLANK(YourCellFormula),"",YourCellFormula)
  13. madonnac

    Parse multiple values from a single cell into seperate rows

    you may need to adjust the vbLf constant, depending on the values that force the new line vbLf is the LineFeed character, chr(10) vbCR is the Carrage Return character, chr(13) vbCrLf is both combined into one These selections cover 95% of the cases. Create a UDF function: Function...
  14. madonnac

    Differences in Call Time calculations

    yes, and I can edit both reports to show the other calculation, which shows the discrepancies.
  15. madonnac

    Differences in Call Time calculations

    I have 2 reports (designed by different people) that use 2 separate calculations to work out total call time (without ACW) One uses ACDTIME + HOLDTIME The other uses i_acdtime + i_acdothertime + i_acdaux_outtime Looking at the definitions in the Avaya help file, they would seem to be...
  16. madonnac

    Outlook 2010- &quot;Send as plain text&quot; not working

    Hi Whitemtntn It seems you've posted the same question at microsoft technet forum Please see: http://www.excelguru.ca/node/7
  17. madonnac

    MS Access ODBC DB Structure

    Unfortunately, there's no ODBC driver for a paper table. It needs to be entered into the computer... Are they expecting you to set up a webcam so you can take a picture of who is operating the machine? Perhaps OCR scanning so you can read the paper they log the user on? With the information...
  18. madonnac

    check if sum of column is below a value, if not increment adjacent cell value by previous cell +1

    As I assume you're trying not to overload a circuit, we will have to restart the numbering when the next value would overload the previous branch. This requires a helper column. Unit HP VFD Brake FLA Branch load Branch # 4104 5 No Yes 7.6 7.6 1 4106 2 No No 3.4 11 1 4108 2 No No 3.4 14.4 1...
  19. madonnac

    Seeking Cautionary Advice Re Linking Tables From Another Software Program

    Copy the access database to another location - this may be automated/run on a regular basis Use that database as a backend to your database. That way, you are linking to a snapshot of the database, and not connecting to the original in any way, so if someone does affect the data, you can simply...
  20. madonnac

    Good way to learn to double click

    Windows Solitaire was designed to introduce people to the mouse - you can drag & drop cards on the layout - you can double click them to put them up onto the target piles (Ace, 2, 3, ... ,K) - You can click on Menus to start new games, etc - you can use shortcut keys (F2, F3, etc) to...

Part and Inventory Search

Back
Top