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 dencom 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: Sniipe
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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?
  5. 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...
  6. 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...
  7. 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 & "'...
  8. Sniipe

    select max brings back more than 1 row...

    I have this code: Select max(a.templateid) as templateid, a.questionid, a.ANSWER, a.quoteid from PPT_Answer A, PPT_Question Q where A.QUESTIONID = Q.questionID and A.templateid = Q.templateid AND A.QuoteID='TCA0136327' and a.answercell = 'B15' group by a.questionid, a.answer, a.quoteid...
  9. Sniipe

    tricky sql (for a n00b)

    I have this sql SELECT max(d.distributorid), c.countryid FROM distributor d, country c WHERE d.countryid = c.countryid and d.hassmbsb=1 group by c.countryid Essentially there are a number of distributors per country. Up till now the latest...
  10. Sniipe

    maintaining ID's when using Excel...

    I'm not sure if this is an Excel or XML/XSLT issue. I've an excel document which has been application created and has values like this <Row ss:AutoFitHeight="0"> <Cell><Data ss:Type="String">Active</Data></Cell> <Cell ss:StyleID="s92" id="Active"><Data ss:Type="Boolean">1</Data></Cell>...
  11. Sniipe

    Nortel Contivity VPN Client won't install

    reference to: thread463-705786 I've been at this for a while now. I've read the FAQ posted here: http://www.tek-tips.com/faqs.cfm?fid=4134 by edemiere My folder looks different and looks like this: NT_IPSECSHM\0000\Driver = {4D36E972-E325-11CE-BFC1-08002BE10318}\0012 Whereas the FAQ says to...
  12. Sniipe

    [Newbie] - Combo box and forms simple issue

    Hey all, I'm pretty new to MS access, but I have a form with a combo box. Currently, visually everything happens as expected. The combo box pulls its value from another table, but when I click next record the current record outputs an error: You must enter a value in the 'Employee/Course link...
  13. Sniipe

    XSLT - unable to put my logic to code...

    I have XSLT transforming my XML Spreadsheet. Works well except for one part. On the worksheet my cells would look like this: HeadingName1 bike1 True bike2 False HeadingName2 Car1 True Car2 False Car3 True The XSL looks...
  14. Sniipe

    XSLT - finding values

    I have an XML document that looks somewhat like this <Workbook> ... <Worksheet ss:Name="x"> <Table ...> <Row> ... </Row> <Row> <Cell> <Data ss:Type="String">MPRCode</Data> </Cell> <Cell ss:StyleID="s77" id="MPRCodeVal"> <Data...
  15. Sniipe

    XML Spreadsheet to XSLT

    Hello all, unusual subject I know, XML to XSLT... What I have firstly is an excel sheet, which I've saved as XML spreadsheet. When I open it, its essentially a spreadsheet. I want to use this sheet as a template as such and input XML into it. Eventually I would like this XML spreadsheet to...
  16. Sniipe

    NumericComparer ??

    I have a compare function as follows: Private Class QuoteSorter Implements IComparer ' Calls CaseInsensitiveComparer.Compare with the parameters reversed. Public Function Compare(ByVal x As Object, ByVal y As Object) As Integer Implements IComparer.Compare...
  17. Sniipe

    arraylist in VB6

    Hello all, I use arraylists in vb.net in an application. This application is called by a vb6 application and it falls over when it tries to deal with arraylists... It would be easier to change the vb6 code rather than the .net code. What would I need to do?
  18. Sniipe

    I can't get around the error: &quot;Prefix 'xmlns' is not defined.&quot;

    I have an xslt file which can be called 2 ways; 1) the user clicked on excel download 2) the user clicked on html download I can get the html download working, but not excel download. When I try to add in the code I want, neither work and I get the same error: "Prefix 'xmlns' is not defined."...
  19. Sniipe

    horizontal rule in HtmlTableRow

    I have a table populated with cells and rows. I'm looking to add <HR> to a tableRow. any ideas? tRow.InnerHtml = "<HR>" won't work. and there is no HtmlInputText
  20. Sniipe

    xml file has been encoded to use &amp;quote; instead of &quot;

    I have an xml file which I am passing from one page to another. I don't have access to the page its being passed to so I can't change anything there. The XML is in string format and posted to form by a button to its destination page. <form id="frmGenerateReport" method="post"> <input...

Part and Inventory Search

Back
Top