Search results

Hi all, I need to input a string into a column named "EventType". The code should first check if the column "Agent Name" contains any strings. If there is none, it will input "IBM Director" into the EventType column. Once it has looped through the agent names, the code will then loop through...

Hi all, My friend was able to provide me an idea on how to do my program, however, I think he's logic is for Excel VBA instead of Access. Can someone help me translate what he's trying to say into Access VBA? Open file Set arrayidx = 0 Initialize Array While not EOF Do Read file If...

Hi all, I need to write a code that checks if every 6 lines in a table contains a string. If it contains the string, then carry on looping, but if it does not, it will delete the current line and the previous 6 lines before it. The program should then continue looping through the entire table...

Hi all, Is there a code that will replace the empty fields by shifting the bottom fields up for access? I am planning to write a code that will delete unnecessary items in my database, however, that will cause the database to have "holes" in it.

I have a text file that details every single incident that happened in the system. This means that it is extremely messy and non-comprehensible to a normal person due to the use of codewords and all. Is it possible to scan through the document and insert the data into access, such that the...

Hi all, I need a search function that will not just open files based on their names but also drill into the documents and search based on what's in it. The only way I can see now is to use the Window's search function (the one at the start button). Is it possible to call that function into...

Hi all, forgive me if I use any wrong terms as my VBA isn't very strong. I have been tasked to create a multi-keyword search form, however, my form isn't working right and only the first record of the table is opened. Public Sub txtSearch_AfterUpdate() Dim strWhere As String Dim...

Hi all, I managed to create a form that is able to search keywords on Access 2007. However, the keyword search must be exact to what is contained in the table. For example, I stored "red blue yellow" into the database, and I can only search "red blue yellow", "red blue" or "blue yellow" in...

How to search and open a Word document from Access? Hi all, I am fairly weak at VBA coding, so forgive me if I use any wrong terms. I was tasked to create an application where by the user enters keywords into an Access form, and when he clicks the button, it will run the keywords against...