Recent content by itsmythg

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

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

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

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

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

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

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

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.

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

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

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.

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

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

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

You guys are the coolest, THANKS for the help.