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