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 dencom 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: bloomlight
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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.
  6. 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...
  7. 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...
  8. 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...
  9. 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'...
  10. 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...
  11. 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...
  12. 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...
  13. bloomlight

    How to make report records with correct date?

    I have a query in Crystal report with the following formula: {StartOfCareDate} <= DateTime (2012, 01, 31, 0, 0, 0) and (IsNull ({Discharge}) OR {Discharge} >= Date(2012,01,01)) Basically, I need a report which will show all active patients in the month of Jan. 2012. But with the formula, the...
  14. bloomlight

    How to add 14 days?

    Crystal Report question: How to add 14 days to the StartDate? I need to make a report which will show the date (mm/dd/yyy) of our client's (startdate + 14). Here is what I needed: Name StartDate 14-days ====== ========= ======= Client#1: 12/01/2011 12/15/2011...
  15. bloomlight

    XP system restore tab missing???

    An user reported to me that she is having issues with the computer in the office. The PC is running XP pro sp3. I was trying to use system restore. And then the message says something like this:"You do not have sufficient security privileges to restore your system.......". The user has the...
  16. bloomlight

    Excel 2007 saving multiple copies, why???

    One user is having trouble saving an excel file. When she is done modifying a file, she clicked "save as", then she selected the original name and clicked "save". Then she got the message saying that the file is already exist, if she want to replace the existing file, she clicked "yes", then...
  17. bloomlight

    How to ask for &quot;date is null or greater than 8/31/2011&quot;

    I am creating a query using Crystal report and need some help. Basicly, the report is going to show "Active patient as of 8/31/2011". * Patient discharge date is null * OR discharge date is greater than 8/31/2011. I know how to put IsNull(field), but don't know how to combine them...
  18. bloomlight

    where to insert the IF statement???

    I am writting a report using Crystal Report. And I don't know where or how to insert the IF statement. I have fields on the report with emp last name. Now, I need to make a report with: If lastname start with 'B' then go to "Group-1" else go to "group-2" any idea how to make IF statement to...
  19. bloomlight

    PC works for a local user only -- why????

    I have a PC in the office with weired situation. It only works with a local user log in. Here is the situation: * If I login as the local user, it is OK to connect to Internet and domain server. But it won’t allow to install any program because she does not have local admin permission. * If...
  20. bloomlight

    Excel keep creating .png file... HELP!!!!

    I have a user who needs to copy data from Excel file to webmail. When people received her e-mail, it appears as .png file. Is there a way to make it not happen? Thanks.

Part and Inventory Search

Back
Top