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!

Register Log in
  • Congratulations Chriss Miller 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: donjohnson
  • Order by date
  1. donjohnson

    Multiple layer Data Validation

    You all have given me some good things to work on here. I took a quick look at Debra's site, and will pursue that further when I get back from some business traveling. Thanks for your help - it's great to be part of a team like this! Don
  2. donjohnson

    Security report for audit requirements

    Thanks for the tip - I will look at Lakeside soon! Don
  3. donjohnson

    What should go on a DC?

    Thanks for all the guidance. I have ordered a new server, and will leave my old machine as the DC with DHCP, DNS, time, etc. - everything but files. The new machine will be primarily a file server (we also want to move user files from their desktops to a centrally managed location, since they...
  4. donjohnson

    What should go on a DC?

    We have a star topology in our enterprise, with 6 locations. At the hub, someone a long time ago decided to use the DC (which is also the primary DHCP server) as also a central file repository accessed by people from all the other locations. We are currently at a point where we cannot reset a...
  5. donjohnson

    Security report for audit requirements

    Does anyone have any suggestions for security reporting? Don
  6. donjohnson

    Security report for audit requirements

    Hello! We have a request from an auditor to produce a report of logon failures (bad password, user unknown, etc.). They would like to see a report by userid (to identify multiple cracking attempts) and by IP or machine (to identify attempts at multiple logonids). Being new to AD and event...
  7. donjohnson

    Multiple layer Data Validation

    Skip, I understand most of what you say, and will be glad to try it out. First, a couple questions. How can I get a list of unique cities for the user to select? I have tried an array formula, but realize that as the table changes, I would need to constantly update the city list. Second, in...
  8. donjohnson

    Multiple layer Data Validation

    It seems that I may not have been clear before. The data looks almost like this: Huntington Best Western 3441 Rte 60E 736.9772 Huntington Comfort Inn 249 Mall Road 733.2122 Mt. Hope Holiday Inn 340 Oyler Ave 465.0571 Mt. Hope Courtyard 124 Hylton Lane 252.9800...
  9. donjohnson

    Multiple layer Data Validation

    Hello, I am trying to create a variable data in a spreadsheet which will create travel request forms. I cannot use VBA as many of the users have macros disabled due to paranoia. Consequently, I need to use in-sheet functions. Here is what I would like to do. Starting with a list of cities and...
  10. donjohnson

    Systray IP address tool

    Hello! I am somewhat new to VB, and would like to write a small app that would run in the systray, and either clicking or hovering would display for the user the current machine's name and IP address. We have just hidden the VNC icon from the users, and need an alternative to be able to support...
  11. donjohnson

    Enabling SNMP through GPO

    Hello! We have implemented SNMP monitoring of our servers, and would like to begin monitoring some of our key desktop units. Since these machines are located in different sites and are a mix of Win2K and XP, we were hoping there would be a way through GP to enable SNMP. Can anyone tell me...
  12. donjohnson

    Using derived field in aggregate Select

    Okay - my mistake here. I was getting a div/0 error, and so tried to use a case statement, and that is what gave me my first error about a non-aggregate field. Consequently, I will add a WHERE clause to only take records with a goal > 0, and then use a UNION ALL to get the rest of the records...
  13. donjohnson

    Using derived field in aggregate Select

    ...each list, and there can be multiple lists per program. If I could derive a field call GoalHours for each list using this: ((sales/hours)/goal)*hours I could then sum the GoalHours and divide by sum(Hours) to get what I need. However, I was not able to use this calculation, since I was...
  14. donjohnson

    How to Select Summary and detail together

    Thanks for the help, it was the UNION ALL that I didn't understand before - I now have my query giving me what I want! Thanks again! Don
  15. donjohnson

    How to Select Summary and detail together

    ...Refusals (summed) Accept/Hour (computed field here, and computed in totals) Also, I pull a field, Rate from a WorkOrder table to calculate Revenue (Hours * Workorder.rate, also computed at totals), and sum(Revenue)/sum(Hours) at the totals. Can anyone help or direct me here? Thanks! Don
  16. donjohnson

    Merging two columns into a single list

    Boy, do I feel stupid! I tried a union at one time, but did it in the SQL pane of Enterprise Manager's tables function, rather than in the SQL Query Analyzer. Once I moved there, the union worked fine. Thanks for your help - now on to some other recordset problems I have with email! Don
  17. donjohnson

    Merging two columns into a single list

    Hello! Here is another question that should be easy, but has me stumped. I have a table with Name1 and Name2 columns (among others). I would like a distinct list of all the entries in Name1 and Name 2 as a single list. For example, if I have Name1 Name 2 Bob Bill Joe Larry Don...
  18. donjohnson

    How to join & sum (cartesian join problem)

    Wow! Thanks for the help! I knew it couldn't be <too> difficult, but that it was over my head. I hope I can help someone down the road someday! Don
  19. donjohnson

    How to join & sum (cartesian join problem)

    Here are the two distinct queries: SELECT Production_Date AS PDate, Location AS Site, SUM(Hours) AS Prodhours FROM production_details WHERE (Production_Date = '10/18/2004') GROUP BY Production_Date, Location and SELECT Payroll_Date AS Pdate, Location AS Site...
  20. donjohnson

    How to join & sum (cartesian join problem)

    Hi! I am new to SQL, and have done some easy queries, but have a problem I can't get past - thanks for your help in advance. Here's the deal: Table H contains records with hours columns (QA, IT, Vac, HR), with a key of Date, Site and Shift (one rec/Date,site,shift) Table D contains recs with a...

Part and Inventory Search

Back
Top