Search results

In the table design set to your ID 's index to "No duplicate". Then under "Validation text" type in "YOUR MESSAGE WHEN DUPLICATE OCCURS".

I believe that is done under "Design View" of your table under "Validation Text" ! That text is displayed everytime an MS Access error occurs! U can also define error traps in which text is also displayed under "Validation Rule"!

Yes, but then if search criteria will be any other word such as "abcdef", then the output will be those records where columns contains "abcdef" with empty ones, which isn't correct. I need this to work with any search criteria! If user types any string in text box then it works fine. The...

OK, my problem is: I have a search query. If I don't use criteria then it works fine. It displays all data stored in table. Even those rows where some columns are empty. I use left join, of course. But when I use asteriks as criteria, those rows where column on which criteria is used is...

Hi! I'm new in Access and VBA so mybe this question will be ... I have a main form with a lot of subforms and textboxes aswell as combo boxes and command buttons! The problem is the TAB ORDER that I can't figure it out how to achieve the tab order that I want. Like from text box on a main...