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

    WP 12 crashing thread67-1167171

    I been looking into this problem and seems every since WP8 this has been ongoing issue with Word perfect has anyone found fix other then the work around I posted below this quote " ngagne (TechnicalUser) 19 Dec 05 12:58 WP 12, SP1. If I use File-->Open to open a WordPerfect doc, the...
  2. wwgmr

    Reboot and login scripts

    Hi, I wanted to ask if anyone can help with this issue, I searched for info on it and seems everyone post had no replies. What I'm looking to do is write script to reboot windows and relog into the same user. I have found many ways, but I don't want to request or enter in the user name or...
  3. wwgmr

    Remote reboot windows

    Hi all, Having trouble finding a script that can run in windows to have system reboot and log back into windows under same user from remote location. I am wondering if it is possible to do this with the need for the user name and password. As I want to keep this information private for user...
  4. wwgmr

    Access 2003 Calls per hour

    Hi everyone hope things are going good. Hope more that you can help me ;) lol I posted this under MS Office but I think maybe I should have posted here. Here is my problem. I'm good in excel but access I just seem to fight with. I have Excel sheet with list of calls we take over 31000 rows...
  5. wwgmr

    Access 2003 Calls per hour

    Hi everyone hope things are going good. Hope more that you can help me ;) lol Here is my problem. I'm good in excel but access I just seem to fight with. I have Excel sheet with list of calls we take over 31000 rows which is why I feel access should be beter to work with. I have brought it...
  6. wwgmr

    Changing Help window background color

    Hi, I am wondering how either in registry or setting could I change default color of the winxp Help window from that blue to another color like red. Is this possible? Would the font of text also be there? Thanks all
  7. wwgmr

    Infopath 2003 linking to Access Database.

    Hi all, I am new to Info path and was thinking it would be easy way to link to table in Access. Sofar it seems to be. I am looking for help with this problem or maybe being pointed to great site with information on this in way of step by step guides. I have Access Database with 3 tables...
  8. wwgmr

    Excel-Center on cell view

    Hi, this should be easy Just can't find it in search or in my books. I have simple button that shows or hides a range. The problem I am having is I want to have it setfocus on the first cell in that range when it unhides it. I tried range(BF5).Select or activate but it doesn't set the view...
  9. wwgmr

    Sending excel sheet with just values?

    Hello everyone, Quick question I hope. I have excel sheet we use for that has grown with my vba work in it. I want to send a simpler version with out code, just values if possible keeping formats of course. Is this possible? IE no modules inclued. Thanks
  10. wwgmr

    Command button will not press/work

    Hello again, this has me very confused and I am hoping its simple fix. I have placed on one of my sheets command buttons using the VBA Control Toolbox. I wrote the code for the buttons and and even tested them, each worked perfectly just as they should. I saved and closed the workbook and then...
  11. wwgmr

    Counting cells by color

    Hi all question I have formula that counts cells by their color, my problem is it doesn't count the cell if you enter any numbers into the cell first and then fill the cells color. I can't understand why? Here is the code. Function CountColor(rColor As Range, rSumRange As Range)...
  12. wwgmr

    CR 8 Sorting by field in PH before Group sort

    Hi all, I wanted to see if anyone could help me with this. I have a report built and it sorts by Emp IDs in my Group. My problem is sorting these employees after I print by hand to put them into their departments. I have field in PH that lists Dept, is there a way to have it sort the reports by...
  13. wwgmr

    Is it possible Autofilter Rows ?

    I am wondering if it is possible to use excel to autofilter Rows instead of Columns the way it works by default? I have a table that because it uses times I want to sort the number of columns I show by a rows value. Just like you would using Autofilter, but I don't see a way to do this in Office...
  14. wwgmr

    Clear cell with out calling worksheet_selectionchange event

    Hi all, I am wanting to clear cells on a sheet that have a Worksheet_selectionchange event tied to them when someone clicks on that cell. In my code for resetting the spread sheet, I am selecting many cells with range("Multible cell address").select to then clear selected. My problem...
  15. wwgmr

    Taking a cell value to use in namerange lookup?

    Hi all, I wanted to find out if it is possible to take the value in a cell say c1 on a sheet. I even named that cell to try to make this easier. Name is First I want to take the Value for First and add another word to it to use to look up a value. NewName = [First]&"Name" I can...
  16. wwgmr

    Help with command button setting it visable

    Hi I seem to be having a problem with a command button. On the click event I have this happen cmbCallEvent() cmbcallevent.visable = false call Macro1 end sub The problem I am having is when I try to reset my Page and bring all my buttons back I cannot seem to set it to visable...
  17. wwgmr

    Excel send sheet as email attachment in outlook

    Hi all, I am trying to write a macro sub that will use named ranges from my sheet as values in the subject lines and other places. I seem to be having trouble with the code suggested in 2002 excel book and also in this forum. Here is what I have so far with some Rem lines showing variations I...
  18. wwgmr

    Extracting only text from cell in Excel VBA

    Hi, Is there way to extract just the text from cell? There maybe spaces between words. Thanks I know this should be easy but I am not finding it right now. lol
  19. wwgmr

    Setting a textbox value from a form.

    Hi all, I tried to search for textbox in forums and found nothing. So I throwing this out. I have excel sheet where I have added check boxes in 5 rows down and 7 rows across. I have linked each one to a cell so that when you click the Check box(cbHours) it brings up a Userform I have created...
  20. wwgmr

    Custom Function that uses times for case

    Hi all I am trying to write a custom function that will be pasted in a row along a columns that are starting at 12:00 AM and move across till they reach 11:45 PM in 0:15 min increments. The row is 4 and 12 am starts at N4. The function will look to the row its in starting at n4 and compair that...

Part and Inventory Search

Back
Top