Search results

Hi All, I have a problem with implementing my filter that is pieced together in my VBA code when the filter gets too long. Everything works fine for everyone in my database (1000's of people) except for 4 people. The problem happens in a search for all documents associated with a person when the...

Ahh well that sounds like the for sure way to avoid problems!! What would that macro look like. I'm not very experienced with macros...

Thanks Guys! :)

I'm sure this is an easy one but what is the best way to import a table and replace an existing table with it. I know I can use the import data option in a database. I was just going to import the excel file, delete the original table, rename the newly imported table the same name as the old...

Actually I figured out my mistake. I just had to change the 'Limit to List' property to 'yes' so that the 'NotInList' event would trigger. I guess it doesn't even trigger if the 'Limit to List' property is set to 'No' But I do have a related question. Is there some easy code that I could put in...

Hello all :) I'm trying to figure out the best way to add a value that is not in a drop down combo list. After doing some searching online, I found this code: Private Sub Trait_NotInList(NewData As String, Response As Integer) If MsgBox("The Item Entered is not in database, would you like to add...

Hi All:):) I'm building a database in English but it has arabic people. One of the features that I need to include is some text boxes next to the names in english that will automatically display the name in arabic when the english version is typed in. So far I had added the language update back...