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 Wanet Telecoms Ltd 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. beasleyd

    Browsing Non-Sharepoint Directories

    I just recently (yesterday!) migrated our Sharepoint 2000 site to a Sharepoint 2003 setup. Wow. Lots of big differences, chief of which is the fact that the entire website is now stored in a database file. My only complaint is this: We shared our previous Sharepoint site with OTHER web apps...
  2. beasleyd

    Stop Error Definitely Linked to Video Driver - how to fix?

    Here's the situation: One of my company's HR personnel needed an upgraded computer to replace her extremely slow, outdated machine. Using Acronis with Universal Restore, I took an image of her old machine and put it on the new hardware with the Universal Restore function (which strips the HAL...
  3. beasleyd

    Program for File or Disk Monitoring and history?

    Has anyone heard of a tool that can be run on Server 2003 (or even NT 4.0 if possible) that you can monitor disk usage and file history? The reason I ask: We've got users that love to store mp3s, pictures, whatever onto the user backup server and take up all the space. Sure, we could manually...
  4. beasleyd

    PCMCIA Device Could Not Start... weird bug

    I've loaded an incredibly old laptop up with WinXP and everything seems to run great... except for the PCMCIA cardbus. On Windows bootup, my wireless utility and network connection do not show up in the system tray. I go to the Device Manager and see that the PCMCIA cardbus controller could not...
  5. beasleyd

    Printer Migration Automation

    Hello! I'm currently running a network with two NT 4.0 servers as the PDC and BDC. I have been diligently migrating files over to the soon to be solo Windows 2003 server. The PDC and BDC NT 4 servers will then be decommissioned. While doing this I had a horrific realization. All network...
  6. beasleyd

    Strange Freeze in Explorer when Accessing Network

    Sorry about my delayed response... I thought I would receive an e-mail when someone replied to my thread! No, it doesn't look like we're running through a WINS, at least not on the workstation front. All of our IPs are assigned (whether dynamically or statically) at a central server way up...
  7. beasleyd

    Strange Freeze in Explorer when Accessing Network

    Hey everyone. Thought I'd come to the best website on the planet for asking questions in plain English so that a helplessly confused IT admin (me) can get something fixed. Anyway. Problem: Our current network consists of 40+ machines all on XP attached to one NT4.0 PDC and one NT4.0 BDC...
  8. beasleyd

    Excel 2002 from '97 Pivot table reference woes

    Oh. My. God. A month later... I'd forgotten I even made this post. Thank you so much for finding that out. This time of year the number of reports based on pivot data is skyrocketing, so I needed a fix for this... it was annoying manually changing formulas or using Find & Replace. You get a...
  9. beasleyd

    Excel 2002 from '97 Pivot table reference woes

    Hey everyone. Having a slight problem referencing a Pivot table in Excel 2002. I do a performance report that tracks the sales of the agents of my company. I pull raw data from Access and paste it into Excel. I then take all that data and create a pivot table. Next I go to our pre-made...
  10. beasleyd

    Horrible Outlook 2002 Hotsyncing error... please assist...

    Hey everyone, I've been upgrading all of our 98 and 2000 machines to XP (Windows and Office) and I have recently come upon a problem. Well, all the computers were set for central time before I reformatted, but when I re-loaded the OS, it was on Pacific time. The problem is that the HOUR was...
  11. beasleyd

    Multiple calculations in one report, Access 97

    Paul, Thanks again, that did the trick as far as I can tell. I appreciate all your help, you've been a life saver :) -David
  12. beasleyd

    Multiple calculations in one report, Access 97

    Paul, Okay, that threw an error... The error: Can't Have Aggregate Function In Expression =Sum(IIf([Plan_Type]="Special Life" Or [Plan_Type]= "Special DI" Or [Plan_Type]= "Special-LTC", Sum([Annual_Commission])/0.325*[Plan_Ratio]...
  13. beasleyd

    Multiple calculations in one report, Access 97

    Uh oh.. you didnt think you could get rid of me that fast did you? One last request has been made of me. Okay, I'm displaying the Credits in a field that uses the above formulas we've been working on. Is there a way that I can create a variable that totals the credits for each plan, and...
  14. beasleyd

    Multiple calculations in one report, Access 97

    PaulBricker - You rock for sticking with me. dhookom - You rock for finding that stupid mistake. Thank you both. It works perfectly now. I know where to come now for any help regarding access (oh plenty more questions to come I assure you...I can almost hear you both groan). Truly...
  15. beasleyd

    How do I create an automatic BCC: for all outgoing mail??

    Well, interestingly...I seem to have figured it out completely by accident. As I said, I'm using the method linked to above, and the FIRST step you take is adding a REG_DWORD value with the name No Local Delivery and setting its data to '1'. Well, I figured maybe this would be an On/Off switch...
  16. beasleyd

    Multiple calculations in one report, Access 97

    Wow, thanks. Okay, we're getting somewhere, but a new problem came up... =IIf([Plan_Type]="Special Life" Or "Special DI" Or "Special-LTC", Sum([Annual_Commission])/0.325*[Plan_Ratio], Sum([Annual_Commission])*[Plan_Ratio]) That's what I have down. Premiums are...
  17. beasleyd

    Multiple calculations in one report, Access 97

    PaulBricker, Thanks so much for the help. It worked perfectly. The only request they have for me now is to do something that I don't think is possible without some extensive VB knowledge, which I don't have. I'll tell you what it is, but if it takes more than 20 seconds to think of a solution...
  18. beasleyd

    Multiple calculations in one report, Access 97

    Okay, I suppose I can do that. Can you help me with the table though? So I need records to have the plan type, a percent... and what else? Once I get those, how do I query the correct information, then implement it? I appreciate all of your help, I'm really happy I found these forums.
  19. beasleyd

    Multiple calculations in one report, Access 97

    I'll explain it as best as I understand it... I'm just the IT guy, I let those crazy financial planners do their own thing :) It's really done off of percentages, I was just using ratios as another means to describe my situation. Let's say Life's % is 100... or 1:1 I wouldn't need a...
  20. beasleyd

    Multiple calculations in one report, Access 97

    Thanks for the reply :) No, we don't have a table with that set up, that's why I was wanting to make the calculation within the report. Now that I have the report up, I can describe it a little better... In the "Plan_Type header" area, it displays... of course, the [Plan_Type] and...

Part and Inventory Search

Back
Top