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. Guthro

    Revert to default component naming convention

    Revert to default component naming convention Does anyone know how I can make the free Delphi standard edition stop giving me shorthand named components when I place one on a form ? I had the option and ticked it for "don't ask this again" but its in the not asking again and give me shorthand...
  2. Guthro

    BT Loopback problem - finally resolved.

    thread581-1739531 My original BT hub died with an electric spike. After finding that out, the engineer gave me a new Home Hub 5 replacing the Home Hub 3. The HH5 doesn't require a separate router for Infinity fibre optic like the HH3. After the HH5 was up and running, I tried my original game...
  3. Guthro

    Can I convert .aspx to .htm?

    When I said "community is free", it's a version of the software that is free called Community edition. Might be of use in the future. It's an excellent piece of software. Sometimes walking away from such projects is best or starting from scratch. Good luck.
  4. Guthro

    Change value of row / field in table A depending on value in table B

    I've been pulling my hair out on this for the last week or so now. I used a third party SQL program and trying on MSSQL Studio without verifying, I was receiving errors saying that NEWID was invalid and that IDTABLE was out of bound. Looking up the errors, I find the issue relates to scope. For...
  5. Guthro

    BT loopback problem

    I need to connect to my second pc from my first pc using a game client that connects using an external IP. Both my pcs are behind the BT hub which is set to route all incoming traffic to the first pc. The BT hub doesn't allow loopback and I can't connect at a local level using 192.168.x.x...
  6. Guthro

    Change value of row / field in table A depending on value in table B

    I changed the tables and field names to match my actual database but the structure is the same. On MSSQL Studio 2012, if you enter SQL in the pane, you get the option to verify the SQL. I always do this. It then puts the code how it likes it, with any brackets, tabs, separate lines etc. Sorry...
  7. Guthro

    Change value of row / field in table A depending on value in table B

    I've reached a point where I had to put this into practise. I entered this into the SQL Pane of the old child (items) table. Using verify, it gets the ok from MSSQL Studio 2012. UPDATE RES_STDITEMS SET NEWID = IDTABLE.NEWID FROM RES_STDITEMS INNER JOIN IDTABLE ON RES_STDITEMS.ID = IDTABLE.oldID...
  8. Guthro

    Change value of row / field in table A depending on value in table B

    Thank you both for your reply. I will try them on some backup tables and learn the SQL used.
  9. Guthro

    Change value of row / field in table A depending on value in table B

    I have a table that has records removed and the underlying index order no longer matches the order of the numbers in the ID field. As soon as a new record is added, SQL studio shifts it somewhere else according to the original row orders. I have reordered the master table and now want to assign...
  10. Guthro

    Save site data DW8 and Win7

    Thanks, but no joy.
  11. Guthro

    Computer not accessible on XP wireless LAN

    Are you working as "admin" on both machines ? Have you tried setting the IPs manually rather than dynamically, maybe in the range 192.168.0.2 and 192.168.0.3. ? Some routers like a name for each pc and also might require the mac code to be entered into a limited access table. I realise this is...
  12. Guthro

    Save site data DW8 and Win7

    How do I make Dreamweaver 8 save login info and site data in Win 7 pro. I have to re-add the login ID and password each time. Thanks
  13. Guthro

    Copy/Paste a <script>

    You can copy the entire source of a page and save it to a new blank page in Dreamweaver. This assumes you have the rights to do so. Simply open your new page in code view and paste over any initial code that is present. If you mean the actual script itself and its hosted in a different directory...
  14. Guthro

    change cell colour in formula

    Hello. Is there a method to change an excel cell colour (or font attribute etc.) based on the result of an expression ? ie. =if (A1>0,(A2,color,green)) Thanks
  15. Guthro

    How to prevent loss of positioning when page is minimized or maximized

    I always use the following CSS to make the wrapper sit central to the browser view. This works even with lowly IE6. You can then place your elements within it. A very basic example. #wrapper { margin-left: auto; margin-right: auto; }
  16. Guthro

    AppEvent Scheme

    Thanks Linney, useful links there.
  17. Guthro

    Recovering from from mouse cursor

    Not sure if this is resolved after all this time but I would say the answer is no. I would also question the use of changing the cursor. The problem can occur in countless situations. Often Windows is looking for an unresolved path or even something like crosslinked files can lock the mouse...
  18. Guthro

    AppEvent Scheme

    How do I add a sound to a third party program using Windows AppEvent sounds ? I understand where in the registry the actual sound would be placed but how does windows see the event ? I use a remote hosted forum and was looking to assign a "you've got mail" type .wav file when the inbox is...
  19. Guthro

    Columns not even

    What page is it in question ? All that I can see via your url seems ok to me in IE8.
  20. Guthro

    Excel : ignore letters in cell during calculation

    Thanks Brad and the other guys who spent time and replied here, very useful help. I use Excel alot but it does have a habit of throwing curved balls at me ! Cheers.

Part and Inventory Search

Back
Top