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 Mike Lewis 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

    How to I merge multiple rows of data from the same table with the same ID. I have tried group by by I get the following error Column 'cos_attribute.bunit' 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...
  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}

    I tried SACCTX[0-9][0-9][0-9] 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...
  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}

    Hello all, Im trying to sort by servers named SACCTX001 - SACCTX999 but everything I have tried seems to not work. What I have currently brings up some 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 =...
  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

    I have a database that keeps track of employee training completion and due dates and im trying to figure out how to append a new training record to everyone’s record in the database. what I have now is if a new user is created a template is put into their record with all of the required...
  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

    I switched my if than statement to be more efficient and changed it to 10,30 instead of 10 or 30 like dhookom recommended. I dont know how currentdb.querydefs works so i tried the bellow code. Do you know the problem with the code bellow or can you tell me how to use your code properly I tried...
  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