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 Mike Lewis 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. Sniipe

    XSLT not constantly getting decimal values

    I'm using .net to process the XSLT into XML
  2. Sniipe

    XSLT not constantly getting decimal values

    Hi Tom, I see an issue now with the inputs in excel. they are coming up as: the 10.01 answer is coming up as: <Cell id="DiscountPerc1 div 100"><Data ss:Type="Number">0.10009999999999999</Data></Cell> the 0.01 answer is coming up as: <Cell><Data ss:Type="Number">1E-4</Data></Cell> So...
  3. Sniipe

    XSLT not constantly getting decimal values

    I have the following xslt code <xsl:attribute name="DiscountPerc1"> <xsl:value-of select=". * 100"/> </xsl:attribute> It is trying to translate from an XML file (origionally an excel sheet where the cell would be formatted for percent) values like this: 10.01 It then...
  4. Sniipe

    checkbox to wipe out radiobuttons

    cool, thanks Phil, Its good but I think I need it to only work for radio buttons. Can I get getElementsByName and then dig down into that and get them by type?
  5. Sniipe

    checkbox to wipe out radiobuttons

    <tr> <td>Are you happy?</td> <td><input type="radio" name="2" value="4" can_run="true"/></td> <td>Yes</td> <td><input type="radio" name="2" value="5" can_run="true"/></td> <td>No</td> <td><input type="checkbox" name="2" checked/></td> </tr> I'm creating the above code...
  6. Sniipe

    bare minimum setup for automatic macro

    this is what I have so far: Private Sub Application_Startup() Dim olApp As Outlook.Application Dim olNS As Outlook.NameSpace Dim olFld As Outlook.MAPIFolder Dim oMail As Outlook.MailItem Set olApp = Outlook.Application Set olNS = olApp.GetNamespace("MAPI") Set olFld =...
  7. Sniipe

    bare minimum setup for automatic macro

    I got round my problem and created the code I needed which fires off when I receive a new mail. The problem is now that the function Application_NewMail() does not catch all new mail. eg if I open outlook I might have 3 emails waiting. I want to alter the subject in these as I do in...
  8. Sniipe

    bare minimum setup for automatic macro

    sorry SkipVought, I don't get you. when I go to my outlook 2010 and I click alt+f11 and then I click help I get the bing search, which has nothing... absolutely nothing at all in it.
  9. Sniipe

    bare minimum setup for automatic macro

    I'm using outlook and alf + F11 brings up the VBA In their I have access to ThisOutlookSession. I wanted to popup a msgbox("hello world") when I recieved a new mail. I assumed this went into: Private Sub Application_NewMail() MsgBox ("hello world") End Sub What do I need to do to get...
  10. Sniipe

    VB 6 call to add to array list error

    I have a .net dll and it has a readonly peropery quotelist() as arraylist The problem is that when I'm in VB6 I try the following: objSolution.QuoteList.Add (objQuote) And it fails with an "Object does not support this Property or Method" Any ideas?
  11. Sniipe

    Excel saves values incorrectly to XML

    The value is exactly 7. I type in 7. Here is how you get the same results as I did. I tried this on excel 2007. I have also tried it on earlier versions of excel, but don't get the same results. Open excel. Format a cell to be percentage with 2 decimal places. Enter in 7 Save as excel xml...
  12. Sniipe

    Excel saves values incorrectly to XML

    I have a column in excel that is a percentage. When I save 6% it saves to the XML as <Cell><Data ss:Type="Number">0.06</Data></Cell> BUT when I save 7% it saves to the XML as <Cell><Data ss:Type="Number">7.0000000000000007E-2</Data></Cell> I understand why Excel does this, but how do I go...
  13. Sniipe

    select all in a drop down combo box

    I have a combo box, that unfortunately has 8000 + items in it. Retarded, I know, but what can I do. Anyway there is a check box that selects all. But when I select it and go thru the for loop that selects every value it takes a good few seconds. Is there a quicker way to select all? A...
  14. Sniipe

    using VBA to call an insert statement

    thanks Randy, that was it, but how come I didn't get the warning? How do I turn it on?
  15. Sniipe

    using VBA to call an insert statement

    I'll give that a try joe when I get home, but any idea why it won't insert the row when I use the MS access SQL command?
  16. Sniipe

    using VBA to call an insert statement

    Dim sqlString As String sqlString = "INSERT INTO Member (Member_ID, First_Name, Last_Name, Membership_Paid, Notes ,Telephone, Mobile, email, Address_Line_1, Address_Line_2, Address_Line_3, County, Country, Membership_Account, Family_ID) VALUES (" & Next_MemberID & ", '" & firstFamilyname & "'...
  17. Sniipe

    select max brings back more than 1 row...

    Hey Guys, I was looking for the most recent result which will always be the one with the higest templateid. I do only require 1 value. The quoteid's will always remain the same. There could be 100+ questionID's involved in the results.
  18. Sniipe

    select max brings back more than 1 row...

    Ahh I see what u did there PHV, I assume both do the exact same thing tho? Perhaps computationally yours is quicker?
  19. Sniipe

    select max brings back more than 1 row...

    this is what I came up with... but it looks horrible... select tbl1.templateid, tbl1.answercell, tbl1.questionid, tbl1.answer, tbl1.quoteid, tbl2.screen, tbl2.guilabel from ( SELECT A.templateid, a.answercell, A.questionid, A.ANSWER, A.quoteid FROM PPT_Answer A INNER JOIN ( Select...
  20. Sniipe

    select max brings back more than 1 row...

    almost there. with your query PHV; SELECT A.templateid, a.answercell, A.questionid, A.ANSWER, A.quoteid FROM PPT_Answer A INNER JOIN ( Select max(B.templateid) AS templateid, B.questionid, B.quoteid from PPT_Answer B inner join PPT_Question Q on B.QUESTIONID = Q.questionID and...

Part and Inventory Search

Back
Top