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...
...DoCmd.SetWarnings False
' User Setup Info
DoCmd.OutputTo acOutputReport, "RemoteDestopSetup", "RichTextFormat(*.rtf)", "c:\temp\Access.rtf", True, "", , acExportQualityScreen
DoCmd.SetWarnings True
All the help i found on this was older versions of office and cannot seem to...
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.
...SPI: ttttttt. Dump of failed hash follows.
I WROTE;
IIf(InStr([Detail1],"authentication failed"),Right([Detail1],InStr(1,[Detail1],"Username: ")*1))
Results;
xxxxxx\xxxxxx SPI: ttttttt. Dump of failed hash follows.
I ONLY WANT;
xxxxxx\xxxxxx
I TRIED;
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
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...
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.