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

    How to counting group?

    Thanks for both of you! I have used Pete's suggestion and it worked!
  2. bloomlight

    How to counting group?

    I have a report with groups....and need to count total grouped records at the end...how could I do that? example: Name ServiceDate ServiceType John 03/02/13 B John 03/11/13 A John 04/01/13 B Sandy 04/20/13 C Sandy 05/20/13 C John 06/10/13 F the customer may use same...
  3. bloomlight

    symbols get lost while converting from word 2007 to word 2010, how to fix?

    I have an user who just got a new PC with word 2010. Some of her files were created before have moved to new pc. Most of files converted Ok with word 2010. But a few of her files contain a lot of symbols. After the conversion, those symbols became 9. It seems that number 9 replaced all of the...
  4. bloomlight

    Help needed: IF...Then...Else

    I am creating a report and need help. My report needs to show the certain referral source (1 or 2) . the IF statement is like this: IF {typecode} = "ReferringSource1" then display the record else IF {typecode} = "ReferringSource2" then display the record How to ask Crystal report...
  5. bloomlight

    switch domian controller....help!

    We have 2 domain servers in the network, one is the main domain controller, and another one is the backup domain. The main one is too old and we don't have budget to replace it. Is there a way to switch the backup domain to domain controller? If so, how? Since I don't have very much experience...
  6. bloomlight

    How to put back "System Volume Information\_restore" folder?

    We have a PC which has the virus in the "System Volume Information\_restore" folder. I found the way to access the folder and then deleted the folder. Will it cause problem to run the computer without this folder? Is this a system folder? How can I put this folder back to the machine? Thanks.
  7. bloomlight

    Logon Script -- how to add a link?

    I have the "Logon Script" batch file assigned to all of our users. It have been worked perfectly for number of years. Now, I need to add a link to the batch file. The link would look like this: http://myapps.company.net The purpose is to let the user see the link showing on IE "Favorites" list...
  8. bloomlight

    domain controller update -- what to expcet?

    Thanks ShackDaddy. I did the update from SP1 to SP2 last week. It worked. Just wanted to say thank you for your advice and encouragement. I truly appreciate your time and help.
  9. bloomlight

    domain controller update -- what to expcet?

    We have 6 HP server systems running Windows 2003 server. Most of them have Window 2003 server SP2 installed. Only One server (the primary domain controller) is still running SP1. I am planning to update that server to SP2 so that all of our server systems would have OS & SP on the same level...
  10. bloomlight

    Office 2007 stuck

    It worked!!!!!! THANKS.
  11. bloomlight

    Office 2007 stuck

    We bought a computer with office 2007 purchased & preloaded about 3 years ago. At that time, I only received 25 character product key for office 2007. It says that "Medialess License Kit--No Discs Included". It worked OK with no issues. But the PC crashed about month ago. I had to re-format...
  12. bloomlight

    SQL permission issue???

    SQL 2005 server. She just needs to be able to run query reports. And be able to "drop view" or "create view" if needed.
  13. bloomlight

    SQL permission issue???

    I have an user who is having the permission to access the database and run query reports. Everything seems working just fine. But when she is trying to drop view or create view, she gets the following erroe message: "Msg 3701, Level 14, State 20, Line 1 Cannot drop the view 'Hospice_LOS'...
  14. bloomlight

    Remote desktop connection issue

    I thought it has. How to check it? Thanks.
  15. bloomlight

    Remote desktop connection issue

    I have an user who needs to access server to do some reports. I am trying to set up her with Remote desktop connection but having a problem. She has the "remote desktop user group" right. But error message is saying that the user need to be granted to have "remote desktop user group". What...
  16. bloomlight

    word2007 - read only problem. how to fix?

    I have an user who is using MS office 2007. One of her word files is having problem. When she is trying to open it, she got message saying this is "read-only" file. then she made some changes and save the file with a different name. when she is opening the new one, it is still saying "this is...
  17. bloomlight

    How to split the field?

    I have tried: Split({MyTable.MyField}, ',', 1) But got the error message saying: The result of a formula cannot be an array. Did I miss anything?
  18. bloomlight

    How to split the field?

    I have a field looks like this: BCCH, ROOM#1 BCCH, ROOM#123 BCCH, ROOM#523 OHHCO, APT#6 MAWESTTOWN, FLOOR3, ROOM 302 MAWESTTOWN, FLOOR7, ROOM 732 What I need is to show 1st part of the filed to the report. Then sub-count and Total-count the 1st part. In another words, the report would be...
  19. bloomlight

    How to make report records with correct date?

    Thanks for getting back to me so soon. I got it right. What happen was I put the formula under the "formula fields" with other conditions under "formula editor" area. As soon as you mentioned - this is not the entire formula, I moved the formula to the same place where other conditions are...

Part and Inventory Search

Back
Top