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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by twospoons

  1. twospoons

    MOSS 2007 Task List Question

    Hello, I have a MOSS 2007 site with a task list. I am trying to limit the Assigned To field to only people in a specific group. I have configured the Assigned To field as follows: Require that this column contains information: No Allow multiple selections: No Allow selection of: People Only...
  2. twospoons

    Problem with form writing to table...

    Thanks, that worked!
  3. twospoons

    Problem with form writing to table...

    I have tried troubleshooting this by adding the following to my cmdRunReport_Click() function: MsgBox Start_Date.Value CurrentDb.Execute "UPDATE Control_File SET Start_Date = " & Start_Date.Value & " Where Control_ID = 1" The date appears correctly in the message box, but it does not save...
  4. twospoons

    Problem with form writing to table...

    Hello, I have a table called Control_File, which stores Start_Date, End_Date and Div_Nbr. I built a form using the Create Form Wizard and selected the Start_Date and End_Date fields. Next I added a button to the form and used the visual basic editor to automatically loop through a set of...
  5. twospoons

    date time format???

    hello, i have a linked table to an oracle datebase with a time stamp as the primary key, TXN_DATE. I am trying to write a query in access that selects the records where TXN_DATE >= [Date_Range].[Start_Date] AND TXN_DATE <= [Date_Range].[End_Date] Date_Range is a local table inside of...
  6. twospoons

    Unresolved SIDs

    I am wanting to know if anybody knows of a way that I can remove unresolved SIDs from Security Groups when a user object is deleted from Active Directory. I have searched and searched and I'm not coming up with anything definate. Any ideas?
  7. twospoons

    Restricted Groups and Remote Desktop Users???

    I can't seem to figure this out for the life of me... I have a user that is doing documentation on all the hardware for some of my servers for me. I want the user to remote desktop into each of the servers look at the device manager and document it. So I created a GPO and attached it to an OU...
  8. twospoons

    Zone Not Loaded by DNS Server

    just an update for everyone: I have spent many hours on the phone with m$ trying to resolve this issue. m$ recommendation is to remove the zone from being active-directory integrated, wait for replication to occur and then add the zone back into the directory. however you can't remove the...
  9. twospoons

    edit registry SetStringValue LegalNoticeCaption and LegalNoticeText

    fixed it... sorry i was getting frustrated... i was looking in the wrong... place... long night i guess.
  10. twospoons

    edit registry SetStringValue LegalNoticeCaption and LegalNoticeText

    hello all, i'm wanting a message to pop up before a user gets to the desktop that displays the terms and conditions of using the pc. this can happen either before the loging or after as long as they have to click on something that shows that they agree to the terms and conditions. one idea...
  11. twospoons

    Zone Not Loaded by DNS Server

    What would happen if I just deleted the zone and recreated it? Possible side effects?
  12. twospoons

    Zone Not Loaded by DNS Server

    I have 10 different zones listed in the Reverse Lookup Zones. Three of these are giving me the same error message and same error event in the Event Log. Not all 10 of these zones are listed as a subnet inside the AD Sites and Services snap-in. Only one of the ones with errors is listed. And...
  13. twospoons

    Zone Not Loaded by DNS Server

    Hello All, I'm new at this and just need pointed in the right direction. I've got a few reverse lookup zones that aren't loading. I'm getting the typical: "Zone Not Loaded by DNS Server The DNS server encountered a problem while attempting to load the zone The zone data may not be available...
  14. twospoons

    help combining queries please

    awesome! i got it working... thanks a million
  15. twospoons

    help combining queries please

    ok... thanks phv... i think i'm moving in the right direction now... i've never used left join before... how exactly does that work?

Part and Inventory Search

Back
Top