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 strongm 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. JeroenB

    Excel formula - filtered array for frequency

    Hi, I'm struggling to get the following formulas written. Would appreciate any help. Number of unique Accounts per Year; I manage to get the unique Accounts but cannot filter per year... =SUM(IF(FREQUENCY(B2:B100;B2:B100)>0;1;0)) Number of unique new Accounts per Year (So Accounts that...
  2. JeroenB

    table: onmouseover onmouseout and onclick

    Hi all, I have a table consisting of 6 table cells (td's). I would like to do the following: Change the color of a table cell when moving over the cell (onmouseover); change it back to the original color when moving out (onmouseout); and highlight the cell that is activated (after clicking)...
  3. JeroenB

    space separated list using NMTOKENS (XML Schema)

    How can I define a space separated list of values for an attribute using NMTOKENS. The values one may use must be predefined! The below code does not seem to work. The attribute value does not allow for the containment of a LIST of the values; yet appears to be restricted to one value only...
  4. JeroenB

    link en freeze sections in MS Word?

    The reason why I am working with section is because the page orientation may vary within the document. So, while text-boxes would solve the linking problem; I would still need sections to control the page orientation. And by introducing the sections, you loose the lock and linking effect of the...
  5. JeroenB

    link en freeze sections in MS Word?

    hi, I have several sections in my word document (let's call them sections A, B, and C). Now, I want to achieve the following: 1) Section B should correspond with a specific page in my document e.g. page 30. As a consequence, Section A always consists of 29 pages. 2) I would like the text of...
  6. JeroenB

    recolor a Object

    Microsoft Powerpoint (2002) has a recolor feature (in the 'Picture' tab of the 'Format Object' pop up). I notice that the 'Format Object' popup in Microsoft Word 2002 does _not_ support this feature. Does someone know, how I can recolor an Object in MS Word? thanks j
  7. JeroenB

    page numbers

    I would like to add page numbers to my word document, from the fourth page onwards. So the fourth page should start with number 1, and so on... any ideas? j
  8. JeroenB

    "tab space after" in table of content in MS Word 2002

    hi all, How can I change the "tab space after" of the headings that are displayed in my ToC. E.g. the "tab space after" value of heading 1 is put to '1.5', however this value is to high for display in my ToC. I would like to adjust the layout of my ToC independently. thanks j.
  9. JeroenB

    excell - pass parameter?

    hi all, I am puzzled with the following issue; hope someone can help me out... PROBLEM DESCRIPTION: I have a first Excell Worksheet (sheet 1) with a list of dates: [COLOR=red] (Sheet 1 - Column A) 1 15-May-95 2 16-May-95 3 17-May-95 4 18-May-95 5 19-May-95 6 20-May-95 7 21-May-95 8...
  10. JeroenB

    Onclick should pass parameter

    Hi all, I would like to do the following; hope someone can help me out. I have an input field in a webpage in which I can enter a variable (name="VAR"). Now, by clicking on a href link (not a button!), I would like to pass this variable (together with some fixed parameters) to a...
  11. JeroenB

    QUERY COUNT?

    Hi all, I seem to have a little bit of a problem with this -at first sight- rather simple query; hope someone can help me out... I would like to do the following; the query must return a list of records for which the value of the LINK field occurs more than twice in the Access table. For...
  12. JeroenB

    multiple formatting in texbox

    Hi, in have the following table: author - title - location In want to have ONE textbox in my report showing the value of the three fiels separated by a comma and TITLE MUST BE ITALIC. So I could add the followng in the control source of the specific texbox: =[Table1.author] +...
  13. JeroenB

    different formatting in one field ?

    Hi, in have the following table: author - title - location In want to have ONE textbox in my report showing the value of the three fiels separated by a comma and TITLE MUST BE ITALIC. So I could add the followng in the control source of the specific texbox: =[Table1.author] +...
  14. JeroenB

    FileMaker Pro to MS Access

    Hi, is it possible (maybe by adding plugins) to import filemakerpro files into MS Access ? Thanks Jeroen
  15. JeroenB

    convert filemaker pro to access

    Hi, is it possible (maybe by additional plugins) to import filemakerpro files into MS Access ? Thanks Jeroen
  16. JeroenB

    SELECT COUNT ???

    Hi I have the following SQL-statement in MS Access SELECT TYPE_DEUREN.[TYPE-NR], count ([5_Deuren].[Deur-nr]) AS AantalDeuren FROM TYPE_DEUREN INNER JOIN 5_Deuren ON TYPE_DEUREN.[TYPE-ID] = [5_Deuren].[TYPE-ID] ORDER BY TYPE_DEUREN.[TYPE-NR]; I get the error "You tried to execute a query...
  17. JeroenB

    documpent.write ?

    Hi, I have a js file and a html document. I have made a function which generates a menu onclick Now I want to put the text which has to appear in that menu in my js-document. How can I do so (by using document write ?) Thanx in advance J //Start js var isNS=(document.layers)...
  18. JeroenB

    Undefinied

    Hi, can somenone tell me where the &quot;Undefinied&quot; is coming from, when running this script in IE and how I can solve this ? thanx in advance, J <HTML> <head> <title></title> <style type=&quot;text/css&quot;> </style> <script language=&quot;JavaScript&quot...
  19. JeroenB

    change position alert box !

    Yeh right, but this popup-method is quite long-wided when dealing with multiple successive alert messages... anyone ? j
  20. JeroenB

    change position alert box !

    Hi, is there anyone who knows if it is possible to influence the position of a Javascript alert box ? I want the determine the position of alert box dependent on the position of the current html (popup)window. thanx j

Part and Inventory Search

Back
Top