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 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. Herdrich

    SQL Query Merge Records

    Thank you!!!!!!
  2. Herdrich

    SQL Query Merge Records

    ...is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. The running this query select * FROM cos_attribute WHERE AssetID = 14 provides a result of AssetID bunit system_type priority 14 Personnel Services NULL...
  3. Herdrich

    Finding Parent Groups of users groups

    I was just looking for the parent groups so it worked perfectly :)
  4. Herdrich

    Finding Parent Groups of users groups

    Nice! Looks to be working. Just have to fix up my inputs and outputs. Thanks :)
  5. Herdrich

    Finding Parent Groups of users groups

    Hello All, I am trying to loop this until it hits the top level parent groups. Currently I get the users group then the group of those groups. I want to be able to go up until I hit the top group. I could probably nest a few more foreach statements but there has to be a cleaner way to do this...
  6. Herdrich

    Filter by server name Get-ADComputer -Filter {Name -Like $filter}

    Nice that works I knew it had something to do with -match because I only found references to [0-9] about -match and not like.
  7. Herdrich

    Filter by server name Get-ADComputer -Filter {Name -Like $filter}

    ...and SACCTX\d{3} but it pulled no servers in my full code. Also found out today that I can run the commands I needed on all of the SACCTX* servers so I will just leave it as is. Thanks for the recommendations. I will still toy around with it to see if I can find a solution. My work around was...
  8. Herdrich

    Filter by server name Get-ADComputer -Filter {Name -Like $filter}

    I will try the SACCTX[0-9][0-9][0-9] in the morning although I believe I have tried that already. I am trying to get things that are like SACCTX123 and NOT like SACCTXABC.
  9. Herdrich

    Filter by server name Get-ADComputer -Filter {Name -Like $filter}

    ...extra servers that I do not need I have tried SACCTX[0-9], SACCTX### and SACCTX/n. Does anyone know what I should be using? $filter = "SACCTX*" $ADDomain = "OU=Citrix,OU=Servers,OU=DDC,dc=deltads,dc=ent" $servers = Get-ADComputer -SearchBase $ADDomain -Filter {Name -Like $filter} |...
  10. Herdrich

    Script to retrieve AD CA issued certificates: Sort it

    Try out | Sort-Object $cert
  11. Herdrich

    Working with error traps

    I am working on a script that adds a local administrator to remote systems. This is what i have so far but on some of the systems the account might already exists so the first part changes the password for it the second two add an account and add it to the administrators group. Everything works...
  12. Herdrich

    Append records to table using variable on form

    Well guess i asked too soon figured it out CurrentDb.Execute "INSERT INTO Training (SSN, Task, DateCompleted, DateDue) SELECT SSN, '" & Me.Combo14 & "', Date(), Date() From PersonnelMain"
  13. Herdrich

    Append records to table using variable on form

    Last line of code is actually From PersonnelMain
  14. Herdrich

    Append records to table using variable on form

    Having a bit of trouble getting this to run i found this http://www.1keydata.com/sql/sqlinsert.html witch talks about what you gave me but i cant get it to run tried it the way you had it this way and without the currentdb.execute still no luck. CurrentDb.Execute INSERT INTO "Training" ("SSN"...
  15. Herdrich

    Append records to table using variable on form

    ...table I want to pull the SSN from there then use the data from Me.Combo14 for the training type then use Date for DateCompleted and DateDue. I just cant figure out a route on how to do this any guidance would be awesome PersonnelMain.SSN = *, Type = Me.Combo14, DateCompleted = Date, DateDue...
  16. Herdrich

    Query criteria from textbox Help

    Dang I should have known that answer I have used code like this before I guess I was just getting frustrated with it. Thank you for all of your help.
  17. Herdrich

    Query criteria from textbox Help

    ...how to use your code properly I tried this but ended up with Run-time error 3075 Dim strwhere As String Dim strSQL As String strwhere = Forms!Test!Type2.Value strSQL = "SELECT * FROM QuestionsWrong WHERE QuestionID IN (" & strwhere & ")" DoCmd.OpenReport "Questions", acViewPreview, , strSQL
  18. Herdrich

    Query criteria from textbox Help

    I repeated it because when i had it the other way it kept putting OR in front of the first append no matter what so i just changed it to that. I was missing the <> so that should solve that problem. This is the SQL code i am using. Not being able to pass the operator into the query is the...
  19. Herdrich

    Query criteria from textbox Help

    I have a text box that uses this code to append numbers together for a criteria for a query. Dim AddText As String Dim NewText As String Dim strOr As String If Forms!Test!Type2.Value = "" Then strOr = "" Oldtext = Forms!Test!Type2.Value AddText = Me.QuestionID NewText = Oldtext &...
  20. Herdrich

    DoCmd.OutputTo and DoCmd.SendObject

    Got it figured out and this is how. Dim strtype, strwhere, strDateField, strsubtype, strname As String Const strcJetDate = "\#mm\/dd\/yyyy\#" strDateField = "[DateDue]" strname = "[Name]" strsubtype = "[Type]" strtype = Me.txtType If Not IsNull(Me.txtsubtype) Then strwhere =...

Part and Inventory Search

Back
Top