Search results

I apologize for delay response, i appreciate your efforts and suggestions, these are valuable for me. i am not much familiar with Forums, and also my English is not good, hope you understand. i have another table where same details are stored in multiple columns please refer my new post 22...

Sorry for delay reply, i can understand and accepted all my mistaks. 9 # it is my reply where i just posted what exactly my requirement with example (attached Image) 10 # there was you suggested me to split customer information in multiple columns 11 # again my reply and here i was given...

Dear All, I really appreciate your efforts and suggestions, sorry for late reply. Previously I was not aware of cross posting rules that's why i was posted this requirement on multiple Forums for quick result. Now i read and understand cross posting rules and next time i will take care about...

Dear jdraw, I need query result where at-least 80% string matched. please refer Attached Image here i am trying to explained what exactly my requirement.

Thanks for your valuable advice, if i split customer details column in to multiple rows (For every strings) then my database table record-set will be reach ~ 100 Millions because every customer details will split in to average 31 rows, already in my table having 3.1 millions of records.

Dear The Doc Man, I am trying to explain what exactly my requirement on Image Attachment, kindly refer the same. I have a master table where almost 31 millions of records, there are two columns one is the Account Number which is Primary Key of this table and another is the...

Dear The_Doc_Man, You are the correct, please refer attached Access Macros for your reference. Search string "TATA HITACHICONSTRUCTION MACHINERY COMPANY LIMITED TELCO CONSTRUCTIONEQUIPMENT LTD 4066332069 9246397641 CONSTRUCTION EQUIPMENT 5-3-338 2ND FLOOR ABOVE UTI BANK ROAD. HYDERABAD 500003...

Dear All, I need your help for MS Access VBA Search Result performance improvement, below is the code which i used, i want to get the result based on string matching on % basis, this code is correct but it is taking too much time to perform almost 25 Minutes To 30 Minutes for Single String. I...

Hi, Can you please modify this code for working hours (From 9:00AM To 6:30PM)

Dear All, I need your help on Access VBA 2007, How To system will automatically update Logout Time in LoginLog Table when user is sudden disconnected on Network Connection OR sudden removed LAN cable from their Laptop. Below is my Login_Form VBA Code, here i am using Sub Form_Close() event and...

If C or B or E only one person is online then all tasks will assign only one user. please refer attached image for your reference.

Dear All, I need your help to solve my problem, I have 2 Tables : (1st ) tblTaskDetails (2nd ) tblOnlineUsers as below sample data 1st Table : tblTaskDetails (ORDER BY INCIDENT_DATE ASC) Account_Number INCIDENT_DATE 201200178 04-Apr-16 07:34:09 AM 921858299 04-Apr-16...