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 TouchToneTommy 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: pjmdesigns
  • Content: Threads
  • Order by date
  1. pjmdesigns

    Text to Columns and then Copy Column Data to Rows on seperate sheet...

    I have a workbook with two sheets. I intend to use sheet1 to paste a COLUMN of data into column ‘A’; this will always populate 74 rows, formatted as follows: First Name, Paul Last Name, John Address 1, 5, Newton Close Address 2, Walthamstow ...and so on On sheet2 I have a row of headers from...
  2. pjmdesigns

    The Novice's Firewall, which is best?...

    I am setting up a Small Business network of 8 PCs which is likely to grow to 10 max, this is currently peer to peer but at the weekend will have a dedicated server running SBS, with all client PCs sharing the server's internet connection. The thing I am having trouble with at the moment is...
  3. pjmdesigns

    Creating a Message Board - Intranet!!

    Hi I hope someone can help? I have created a very simple site in Frontpage, effectively a procedure guide for our staff; this will only be used internally with a link on each user's desktop to the index.htm file on our server. What I need to do is add some sort of Message Board; I want...
  4. pjmdesigns

    Excel - Something Simple - How to Subtotal?

    Hi I have a table of data which is about 6,000 rows deep; by way of an example this might contain the following: Employee Monthly Bonus otherdata1 otherdata2 etc 111 1,000 111 1,500 111 1,254 254 5,254 254 6,854 122 1,111...
  5. pjmdesigns

    XP Pro - After Login There is Nothing!!!

    Hi, hope someone can help! I'm Going Crazy here! We have a PC on our Network running XP Pro, when you boot the PC it seems fine, however once you have logged into Windows all you get is the Wallpaper, absolutely nothing else, the right click on the mouse does not work, all you can do is...
  6. pjmdesigns

    Cannot create file C:\WINDOWS\System32\hwnd32.dll ??

    Hi All, hope someone can help, I am running XP Home on my home PC (sorry nothing for this on tek-tips!), the PC has two Administrative users set up, and i have just created a third user with restricted access, the thing is when I log in as the new user I keep getting a dialog box appearing...
  7. pjmdesigns

    CREATING REPORT OVER MULTIPLE PAGES

    Hi All I have a very simple report that occupies one page, and is written in the Report Header. Very simply; I need this report to repeat over four pages, with the only difference with each page being that they have a different footer, e.g. File Copy, Client Copy, Duplicate Client, Accounts...
  8. pjmdesigns

    <B>CHART - LEGEND LABELS</B>

    CRYSTAL V8 I've created a basic Bar Chart where the values are being taken from two formulas @%Claims and @%Costs, on my chart the legend is labelled with the formula names, I want to change these but can not seem to find where to do this, can anyone help? - Please!!! Thanks PJ
  9. pjmdesigns

    Installing XP Over ME

    I have two PCs, one running Windows ME and the other XP Home. As the One running XP is at home and the other is at work I wanted to install XP on the work machine, is this possible? Or what problems might I face? Would I need to purchase an upgrade? Cheers PJ
  10. pjmdesigns

    CAN IT BE DONE?

    Hopefully this makes sense: I have a view, as an example this might display the following: Company Companyid Holderid ABC Ltd 001 004 Zeen Ltd 002 004 Americo Ltd 003 002 Ucase Ltd 004 <null> In the Details...
  11. pjmdesigns

    NEW PAGE FUNCTION - CRYSTAL 8

    I have a report with 1 group. My question is simple - I want each group header to be displayed on a new page. I have tried using the 'New Page Before', but then get a blank page at the start of the report, I assume I'm using the right function, but how to I get rid of the blank page? Thanks PJ
  12. pjmdesigns

    Formula - Text Case

    I have a field(string) {FIRSTNAME} where the Text Case is inconsistent, i.e. I want to display &quot;Andrew&quot; but the field may contain &quot;aNDrew&quot;. At the moment I am using: (Uppercase(left({FIRSTNAME},1)))+(Lowercase(mid({FIRSTNAME},2,20))) Is there a quicker way or even a...
  13. pjmdesigns

    WINDOWS 98 - VPN

    Can anyone help? I am trying to connect to my work network using a VPN. I have used the wizard in windows 98 to create it but when I try to access the IP address given to me by the IT people in my office it displays: The remote computer did not respond within a reasonable amount of time. If...
  14. pjmdesigns

    Desktop Themes......

    A very Important question!! where do I find desktop Themes on windows XP pro?
  15. pjmdesigns

    Enable Macros - Excel 2000

    I ran a Macro in Excel yesterday and it was fine, today when I try to run it I get the following error: 'The macros in this project are disabled' How do I enable Macros?
  16. pjmdesigns

    EXCEL2000 - Inserting Lines

    I have a spreadsheet of a couple of thousand consecutive rows of data, i.e: 1 2 3 I want to insert 3 blank lines between each of these, now that's got to be easy? You may have gathered I no Excel Expert. Cheers All PJ
  17. pjmdesigns

    CABLES - 10-Base T ? Cat 5 ?

    I have 3 client PCs on an NT network (my network knowledege is not good!), anyway I am adding a fourth PC and need to buy an 10m Ethernet cable, I've been told to get a 10-Base T cable but when looking on the net I see most cables are CAT-5? What determines which type of cable is best? And what...
  18. pjmdesigns

    W2000 - User Logs

    I have three networked PCs all running window 2000, what I want to do is see a log on each PC showing when each user logged on to and then off of their PC, I have a log file on my PC MAIN.LOG which does the trick, however this is not on either of the other two, is there an alternative log file I...
  19. pjmdesigns

    Download Internet Explorer 5 or Above for W95?

    I have a client with an old PC running windows 95 SP1 and IE3, I have asked them to upgrade the browser to version 5 or above so they can access certain secure sites, however I can't find any sites to download 5 or 5.5 anywhere on the net, and Microsoft seem to have killed all their links? Has...
  20. pjmdesigns

    Linking - Strange happenings

    Hi All, This is a really simple &quot;back to basics&quot; question as the results I am getting at the moment are not in tune with results I expect. Basically, 2 tables with an EQUAL join on LOSSID, tables may look something like: TABLE 1 LOSSID WHATEVER 1001 a 1002 b...

Part and Inventory Search

Back
Top