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

    How to check for invalid triggers and procedures?

    Hello, Our software manufacturer wants us to check for invalid triggers and procedures against our SQL Server 2000 database. Can someone please school me on how this is done? Thank you. -Jeremy
  2. Jeremyjm

    User's Outlook continuously synchronizing in afternoon.

    Hello, I have a user on Outlook 2003 that's having some sync issues. Every day from about 1pm to 4pm her Outlook synchronizes off and on enough to bog down her computer when it's running. Nothing in her settings have changed and Outlook is running in cached mode. Does anybody have an idea to...
  3. Jeremyjm

    Changed DNS for hosting and lost incoming mail and OWA.

    Hello, we are in the middle of switching over hosting to the people who did our new website. I switched the DNS to point to their server and they updated our MX record which points to Message Labs, a company that checks our mail for virus and spam. Message Labs point their mail server to our...
  4. Jeremyjm

    Changing DNS for website and mail

    Hello, We will be changing our DNS address for both our website and mail this weekend. Last time we tried this we had problems pushing the change through and had to revert back to the original DNS address. During the time our registar servers were pushing the address through, dialing in through...
  5. Jeremyjm

    OWA timing out, mail being stuck in SMTP Virtual Server...

    Hello everyone, I'm having major problems here and I don't even know where to begin. First all my users are having problems accessing the server through OWA. I just found out they can't connect through Citrix either. Our network is being bogged and all I could find was a bunch of mail stuck in...
  6. Jeremyjm

    Need totals from embedded subreport.

    Hello, I have a subreport in my main report that I would like totals from and I don't have the slightest clue how to do this. The subreport brings in three fields into my detail line. I'd like totals for each group including a grand total for the report. My report looks like this in the...
  7. Jeremyjm

    Expired accounts

    Hello, I can't seem to get past this one. Is there a way to show a list of expired accounts or a utility that will delete them? Thank-you. Regards, Jeremy M. Systems Administrator Disclaimer:This person recently stepped in a pile of $#!^ and inherited a sys. admin. position. Although he has...
  8. Jeremyjm

    If statement with IsNull not working correctly.

    Hi, I'm trying to pull the promise date on the order if there isn't a promise date for each line item. I've used this type of formula with ship dates, but I can't pull the promise date from the order. If IsNull ({PURC_ORDER_LINE.PROMISE_DATE}) then {PURCHASE_ORDER.PROMISE_DATE} else...
  9. Jeremyjm

    HP4100 returned to network not responding.

    Hello, I had a fuser go on a HP4100(#1) and replaced it with another HP4100(#2) from a different location on the network. The IP was changed and #2 worked like a charm. #1 is now repaired and tested offline, but I can't get anything to print to it from the network. I printed out the config...
  10. Jeremyjm

    Users won't drop off GAL after hiding from Exchange list

    Hello, Our sysadm has recently moved on and I've been chosen to "hold down the fort". I have a few users that I need removed off the GAL. I've gone on the Exchange(2000) server's ADUC and checked the Hide from Exchange list on the advanced tab for that specific user and nothing happens. What am...
  11. Jeremyjm

    Rename Formula

    Hello, I have a field named .PART_ID in a report and whenever this field comes up blank, I'd like to insert a "No Part ID Assigned" message. I've tried doing an IF statement but I always end up getting an "A boolean is required here" in the beginning of the formula. What am I doing wrong...
  12. Jeremyjm

    Changing databases and fields

    Hello, I was fortunate enough to receive a Crystal Report from a colleague. The fields are the same for both of our databases and I was wondering if there is an easy way to change the database name they point to. Can this be done? CR Developer 8.5

Part and Inventory Search

Back
Top