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

    trying to hook up router on host PC but losing internet...

    hey yall... i am setting up a network in myhome and am already having trouble... i followed all the directions step by step, and my DSL LED lights looked good... the power and internet lights were lit on the router, but the only way to get any of the LAN lights to light up on the router...
  2. cmpgeek

    can you network 2 PCs if one is 98 and one is XP?

    hey yall, i am fixing to network my home PCs, but wanted to check on something... my PC is on windows XP, but both of my roommates are on windows 98 or 98 SE... is it still possible to network these PCs, or do i need to "downgrade" to 98 SE? i dont notice much difference...
  3. cmpgeek

    Can you change the sort order depending on Group #1?

    i hope this will make sense to someone... i have a report that is grouped like this: group #1 itmcat.itm_prodcat group #2 case.case_caseserv group #3 case.case_casedate group #1 only has 2 options: "tissue implants" or "others" what i want to do if possible, is to...
  4. cmpgeek

    IF THEN statement in Excel

    i want to set a cell up in an Excel worksheet that will show a value depending on what appears in another cell... there are 4 variables that will be involved... ex: if D1 is < 5 then W else if D1 < 10 then X else if D1 < 20 then Y else if D1 > 20 then Z does Excel have a basic...
  5. cmpgeek

    how do i get Excel to calculate # of years worked?

    hey yall, i have looked through the FAQs, but can not find one that helps me... what i am trying to do is set up a cell that will take the date entered in a separate cell, subtract it from today's date, and then show the # of years worked. example: cell B1 will hold date of hire information...
  6. cmpgeek

    ODBC error: [Oracle][ODBC][Ora] ORA-01652:

    i was wondering if someone can explain this error message to me. i get it when trying to run the follow report... the report i have written gives me a cost / charge analysis of each surgeon within the date range i select... I upgraded the report by adding a group for SERVICE so that all the...
  7. cmpgeek

    using 'ALL' as a paramter option

    we have several reports where the writer gives you several options to choose from within one parameter. usually &quot;ALL&quot; is one of those options. as you would think, if you choose &quot;ALL&quot;, the report runs as if you choose all the other values one by one and added them. i...
  8. cmpgeek

    clean export to excel

    i know this sounds like something trivial, and the solution is probably staring at me, but what is the secret to getting a report to export to excel without 4 or 5 lines in between each detail section? thanks in advance... my vital stats: Crystal 8.5 / Oracle database / Windows XP... ...
  9. cmpgeek

    inserting a movie clip into a powerpoint presentation

    my boss is putting together a powerpoint presentation and is wanting to put a small clip from a movie in it. she has the movie on DVD and is wondering if there is a way to &quot;pull out&quot; the scene she wants to use and save it as a file by itself and then out a link to it within the PP...
  10. cmpgeek

    can you make report/page headers print even when report is empty?

    is there anyway to make crystal print the report &/or page headers even if the report you are running is empty? i dont know if wanting that makes sense, so let me explain what is leading up to this... i wrote a report to show me any cases that are scheduled in a given room. the person selects...
  11. cmpgeek

    does OE have an alert box for new email?

    hey yall, i am stuck using OE at home because my online classes are set up through newsgroups and Outlook will not work with newsgroup servers... i have always used either outlook or incredimail before i started back to school for my bachelor's degree, and what i am wondering is if OE has...
  12. cmpgeek

    Can you trick Outlook into working with newsgroups?

    i prefer outlook over outlook express any day of the week. unfortunately, outlook does not deal with newsgroups and my online classes are all set up via newsgroups... is there a way to trick Outlook so it doesnt know it is looking at a newsgroup? i mean, if everything comes from the NG via...
  13. cmpgeek

    choosing the product of a formula for a parameter...

    i have a report that i want end users to be able to run easily, but there is 1 parameter field that is giving me trouble. The end user has to choose which surgeon they want to look up, but they do not have access to the surgeons system ID. We have surgeons that share last names, so the end...
  14. cmpgeek

    Excel ? - can you lock certain cells and not others?

    is there anyway to lock certain cells so they can not be changed without having to protect the whole document? i have a on call worksheet that was made up for others i work with where they choose a name out of a dropdown list... when they do that the home phone# shows up in the next cell to...
  15. cmpgeek

    do locked formatting macros exist?

    i am not sure if that even describes it corretly... i have created an excel spreadsheet using very basic VB that i was able to pick up from a help page. the problem is that when anyone else opens this same file on thier PC their formatting is competely different... the C column is 1 1/2 times...
  16. cmpgeek

    formatting formulas in reagrd to &quot;self&quot;

    hey yall - i know there is a way to set up a formatting code where crystal looks at the field and, based on what the total is, performs the formatting. what i am wondering is if the is a way to write the formula where instead of typing a specific field into the formula it couls say...
  17. cmpgeek

    Keep group together exceptions

    Hi guys! Is there a way to have a grouping that keep the group together except on the first grouping? It wouldn't be a problem if the first group wasnt a long one, but it just so happens that the first one in this report is a long one so i end up having nothing but the report & page header...
  18. cmpgeek

    problem with CD driver - needing DLL

    does anyone have c2receng.dll on file that they can send me? we are trying to salvage a hardrive that is on its last breath and are unable to get the CDRW to work properly... also - where do we need to place the DLL once we get it? if you have one, plaese email it to mystKathryn@hotmail.com...
  19. cmpgeek

    i need a chart showing time range

    hey all, i am not sure there is an answer to this, but what i need is a chart that will take this information: pt 1 came into the unit at 8am and left at 10 am and then graft it across a chart shading the blocks that represent the hours of 0800 - 1000. i need it to repeat this for each...
  20. cmpgeek

    changing my bios

    until i was looking at a different thread in this forum, i had forgotten you could change your bios so that it would look to the CD ROM drive first instead of the floppy... i am needing to do this so i can take Windows ME off my old system and reload Windows 98... (my best friend was convinced...

Part and Inventory Search

Back
Top