Search results

Hi All, In Access 2007, in a table “Source” -> "UserName" column, I'm trying to truncate and extract value in the string: a. Value within the parenthesis preceded by "\". b. Value outside the parenthesis preceeded by “\” “Source” table contains the column ‘UserName’...

The database is going to be used for Reporting purpose and will be used by just 1 person only. This is not a SPLIT DB. As my requirement is quite Unique, the compact operation needs to be performed on a click of a button on a specific occasion ONLY !! This is the reason Compact ON Close has...

Hi, I'm struck with an issue "how to COMPACT the DB by introducing delay of 10 seconds and then close the DB" In the Database, I'm able to accomplish the "Compact" the database using the function below. Function Compact() SendKeys "%(FMC)", False End Function As my...

Thank you sir. I was able to write the recursive function and complete the rest. Thank you so much.

Sir, I need your guidance. I tried writing the function for extracting Members from the Nested group and it did not work :( From google search, i found (http://gallery.technet.microsoft.com/scriptcenter/List-All-Members-of-a-2ff57ca3#content) which would List GroupMembers Including members...

Sir, Please let me know if I'm correct here... In the DistinguishedName, "OU=Groups" is what diffrentiates the Group to Users.

Thank you for the guidance Sir. I will try and implement your suggestions.

Extract USERS from Nested Active Directory groups into Access Dear Sir, I managed to update the code to lookup from the table in access and then extract these specific ADgroups and Users associated to this Adgroup (without hard-coding the ADgroup Names in code). This is working fine now...

Dear Sir, I managed to update the code to lookup from the table in access and then extract these specific ADgroups and Users associated to this Adgroup (without hard-coding the ADgroup Names in code). This is working fine now :) ATTACHED IS THE UPDATED DATABASE Here are the updates: With...

Hi All, This is regarding "Importing TEXT file" into Access's table. The Issue is with "Long file naming". This is working fine. In the attached Database, On the button click, I'm importing data in TEXT file into table called "TABLE". "DoCmd.TransferText acImportDelim, "Text_Spec", "TABLE"...

Success, I was able to loop through the record set. Found, I was looping incorrectly. Hurray !! Learnt using record set and code is working :) :)

Thankr JHB, the code worked as anticipated. On another button click, I'm trying to convert values in "expected_output" to "source" table format. ' OR name ' is getting concatenated to all the rows and I'm unable to put the values in a single cell :(

Hi JHB, In the attached DB, I added the code on the Button's click event, But the code doesn't seem to trigger. Can you please advise on what could be missing.

Dear Sir, My apologies if my statement "request you to prioritize" irked your sentiments; from the bottom of my heart, i have not written this in the demanding mode. It was more on a requesting/pleading. Definatly sir, I'm gradually learning and i have tried good amount of permulations in...

Bob, The intension is not to have the hard-coded values in the code at all and instead lookup from a specific table's column. Please provide your valuable guidance. Tnx

Hi Bob, Just writing to see if the file opened in the expected file format.

Hi Bob, Please find attached the DB in Access 2003 MDB format. Kindly help

Dear all, In the attached Database (Access 2007), there are 2 tables - "Source" and "Expected_Output" 1: Table "Source" contains values CONCATENATED in a single row with concatenation string ' OR name = ' With limited knowledge in Access, i tried to perform text-column trying to see if some...

Dear all, In Access, via LDAP the system is retrieving the list of users assigned to the specific ActiveDirectoryGroups. In the SELECT statement below, the lookup values in the WHERE clause has been hard-coded to accommodate nearly 50+ ADgroup names with OR operator via string "name = 'ABCD' OR...

Really URGENT - Active Directory to access | Hard-coded values in SELECT statement's ADgroup name lookup string Dear Sir, In Access, via LDAP the system is retrieving the list of users assigned to the specific ADGroups. In the SELECT statement below, the lookup values in the WHERE clause has...