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 SkipVought 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. itsmythg

    Write record for empty AD Group

    I have this VBscript that searchs AD for specific AD Groups. what it does is list users in group it suppose to print the group name [fh.writeline ";;;Groupname"'] if the group is empty but its printing group name for every group. I'm lost as to how to get it only to print when group is empty...
  2. itsmythg

    Access 2007 send email using FORM record

    I currently have a 2007 Access db i use to audit VPN user information. At this time i call a module that opens a report running a query tat requests ID# then opens a word doc with user information and instructions. Trying to eliminate some steps. I would like to after entering my form...
  3. itsmythg

    VB Script adding text to end of line of output from AD Query

    ok i posted too fast i figured it out. thanks anyway.
  4. itsmythg

    VB Script adding text to end of line of output from AD Query

    The script below queries Active directory looking for a specific security group it works great, but what i want is for it to write the name of the group to the end of every line it creates. EXAMPLE Hoffa, Jim xxxxxxx myadgroup1 the myadgroup1 i want to add to every line of this group query...
  5. itsmythg

    Access 2007 shortcut MAM

    Trying to create Shortcut MAM with Access 2007 Macro to run thru Task scheduler. I have done this a 1000 times in access 2003, cannot figure it out in 2007. Any help would be greatly appreciated. Thanks Roxanne
  6. itsmythg

    Query to Break Table Data down into more fields

    You guys are a great bunch!!! thanks for your help. I will be sure to save my code this time so I will remember how to do it in the future. Thanks Roxie
  7. itsmythg

    Query to Break Table Data down into more fields

    my error, i should have shown more data every line has the exact same data but because user names are different the number of characters will be different. I want it to stop when it sees "spi" i have done this before but for the life of me i am getting so forgetful i am going to loose my way...
  8. itsmythg

    Query to Break Table Data down into more fields

    Thanks but i don't hink i explained in right i only wnat the information about the user and want to cut off every thing after likeSPI: ttttttt. Dump of failed hash follows.
  9. itsmythg

    Query to Break Table Data down into more fields

    I have a table that has data i want to parse out part of for a separate column in the query. THE LINE READS; IPSec ESP Tunnel Inb: Packet authentication failed username: xxxxxx\xxxxxx SPI: ttttttt. Dump of failed hash follows. I WROTE; IIf(InStr([Detail1],"authentication...
  10. itsmythg

    using outlook form fields in email

    ok i have stolen enought code to get to the place i can create an email with a custome message but i am stuck at trying to add some information from some of the fields in my database. I need to add the data in field called networkid and others. Private Sub Command20_Click() Dim...
  11. itsmythg

    format email sender info

    I realize i can do that but since i am sending email from other admin accounts and bouncing back and forth the time wasted wouldn't gain me anything, What i am doing is changing the from box before i send, i was just wondering if it could be automated a little more. Thanks again.
  12. itsmythg

    format email sender info

    Maybe the problem is what i am trying to do i am not being clear about. I have the database open on my machine but instead of the email sending from my personal work email I want the email to go out from an admin email account that i am owner of admin@mycompany.com I also need to BCC a copy to...
  13. itsmythg

    format email sender info

    I thought later i should have included this, sorry. Dim mess_body As String Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook =...
  14. itsmythg

    format email sender info

    i am sending this email all is working but i want it to always send from this spcific email address. i cannot seem to get the format right. SenderEmailAddress = myname.company@com
  15. itsmythg

    How do i create multipule lines in body of html VBA email

    You guys are the coolest, THANKS for the help.
  16. itsmythg

    How do i create multipule lines in body of html VBA email

    ok I am stuck here and i am sure this is something so simple i am missing it. I would really appreciate some input. I am creating an email i send out of a access database to notify users of acces. I can get it to work with one exception, only get one line of data. i would like to have 2...
  17. itsmythg

    Send report via email not as attchment using email address in table.

    this problem may have already been addressed but after hours of looking thru these posts, I havn't found one that is clear enough for me to understand, being that i am a little slow about understanding unless i see my field names in the code. i have decided to post my question. i have an Report...
  18. itsmythg

    time calculation in access

    i have a log that i am running reports against it has a field, "Time" data is import as date/time shows in table as 01:00:00 i need to run a report only showing the last 24 hours of activity. I would really appreciate help with this.
  19. itsmythg

    vbscript to parse data out of file

    ok this site has been so helpful in the past will ask for help again. I am trying to a log from our cisco concentrator and parse out the information looking for all failed logon attemps. years ago i wrote pearl scripts like this but the cobwebs won't clear and since i am using a access...
  20. itsmythg

    Help parsing data sql code needed

    I am going to parse in perl, thanks for the help.

Part and Inventory Search

Back
Top