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

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

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

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

Dear all, As a beginner with Access, I have spent a lot of time searching this issue but cannot find an answer that works... So I am hoping that by posting my request, your great minds will definitely help me out...!!!! This is Really Really URGENT - From MS Access, I'm trying to Retrieve...