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 Chriss Miller 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. groovygarden

    Hooking laptop up to TV - no S-video on laptop...

    Thanks all. Another possible option - how about if I bought a cheap Express slot graphics card with TV Out & an s-video connection? Would that let me connect to a TV? Something like...
  2. groovygarden

    Hooking laptop up to TV - no S-video on laptop...

    Thanks. I was hoping for a nice, cheap solution like that! The product details do say though that "This adapter works with graphics cards that have TV-Out function capability through the VGA connector. Check your Video Card manual or manufacturer to make sure that your VGA card has TV-Out...
  3. groovygarden

    Hooking laptop up to TV - no S-video on laptop...

    Hi all, I (stupidly?) ordered a Dell Vostro 1510 last week, and it's due to arrive tomorrow. I had to order it in a bit of a rush, so didn't do my research properly, and have only just realised it doesn't have an s-video port (I thought s-video was pretty standard these days?). This is a...
  4. groovygarden

    Calling a function from an IF statement in Excel

    I've been trying to figure this out for the last couple of hours. Any help appreciated! I have a cell, say B2, and want to add an IF statement to it. If the statement returns true, I want to run a function which will change the colour of B2. I think that IF statement would look something like...
  5. groovygarden

    Sorting on over 100 columns in Excel

    I'm back, and I'm stuck (again) I need to sort a lot of data in Excel. I could potentially have about 180 columns and 500 plus rows. I need sort A3 to IG500, using column F to column IG as Keys (rows 1 and 2 are Headers). How can I do this without having to write Key1:= ... Key2:= ...
  6. groovygarden

    How can I set the cell reference of a variable

    Perfect! Thanks so much. Can leave the office happy now!
  7. groovygarden

    How can I set the cell reference of a variable

    I'm stuck again! I've created 2 variables, ChangeStart and ChangeEnd, and have set their cell addresses. Dim ChangeStart As range Dim ChangeEnd As range Set ChangeStart = ActiveSheet.Cells(Target.Row, 5) Set ChangeEnd = ActiveSheet.Cells(Target.Row, 10) I need to take the range of cells...
  8. groovygarden

    How can I set the cell reference of a variable

    Yay! Thank you both for the quick replies! Have spent ages today trying to work this out! Much appreciated!
  9. groovygarden

    How can I set the cell reference of a variable

    Hi I haven't used VBA much, but have managed to muddle together a small macro. However, I'm stuck on one thing and I'm not having much luck googling it, as not really sure what words to search for... My macro starts: Private Sub Worksheet_Change(ByVal Target As range) Now, I need to create...
  10. groovygarden

    Cheeky question? What skills do I need?

    Having worked on intranets for several years, and now faced with redundancy, I am thinking about relaunching myself and trying to get a job developing web (internet) pages, and, if possible, writing content for the pages too Bit of a cheeky brain-picking question perhaps, but I was wondering...
  11. groovygarden

    Loop a formula in Excel?

    ...run a formula which said: =IF(C2 = A3,B3). And if that didn't match: =IF(C2 = A4,B4) and so on (hope this is making sense!) Column A holds 6000 values so a nested IF / ELSE IF can't be used (I think). Is there a way I can loop the formula and increment A* and B* until a match is found...
  12. groovygarden

    Loop a formula in Excel?

    ...run a formula which said: =IF(C2 = A3,B3). And if that didn't match: =IF(C2 = A4,B4) and so on (hope this is making sense!) Column A holds 6000 values so a nested IF / ELSE IF can't be used (I think). Is there a way I can loop the formula and increment A* and B* until a match is found? Thanks
  13. groovygarden

    CSS - Link Text Decoration Problems!

    Hi, thanks very much for the reply. I'm not sure I explained myself well... I only want the underline to appear when the mouse pointer is hovering over the link. As I said, this works ok with links which haven't been visited before, but on visited links, when I hover over them, the underline...
  14. groovygarden

    CSS - Link Text Decoration Problems!

    ooops, I meant to say that on visited links the underline is never there
  15. groovygarden

    CSS - Link Text Decoration Problems!

    Hi, I'm trying to set it up so that the links on my nav menu are not underlined unless the user is hovering over them. To do this I added some stuff to my style sheet: <style type=&quot;text/css&quot;> <!-- a:link { text-decoration:none } a:visited { text-decoration:none } a:hover {...
  16. groovygarden

    Play movie clip when button released

    Great! Thank you very much!
  17. groovygarden

    Play movie clip when button released

    Hi apologies in advance for the really basic question coming up.... I've created a movie clip symbol called MovieOne (I put a lot of thought into the name!) and I want to make an instance of it play when a user clicks a button. I get that I have to use actions to make this happen, but that's...
  18. groovygarden

    Problems uploading - &quot;No such file or directory&quot;

    Hi, Line 14 is copy($testfile, &quot;\files\myfile.txt&quot;); where i try to copy $testfile to a permenant location. I also get the same error when I use unlink: unlink($testfile); The only variable I'm setting is $testfile and that comes from the form...
  19. groovygarden

    Problems uploading - &quot;No such file or directory&quot;

    Hi, I'm trying to write code to let users upload a file to my server. The form I use is like this: <form enctype=&quot;multipart/form-data&quot; action=&quot;/admin/preview.php&quot; method=&quot;post&quot; name=&quot;add&quot;> <input name=&quot;MAX_FILE_SIZE&quot; type=&quot;hidden&quot...
  20. groovygarden

    Comparing Strings- Problems with differently encoded spaces

    Hiya, I'm trying to compare two strings. One is an array, $list, generated from a select statement, the other is a value, $selected, which holds the value a user has chosen from a <select> drop down. $list[$i]==$selected Problem is, even when the strings should match, they don't. The...

Part and Inventory Search

Back
Top