Search results

I have seen the other posts in the same vein as this question but I've been unable to solve my problem. I have a search function and when the search is executed I would like to view reports based solely on the search results. The code I am using is as follows: Dim stDocName As String stDocName...

This has got me stumped. I am getting the ambiguous outter joins message in a query with only 2 tables. One table contains a list of names. The second table may contain those same names (once or multiple times) or it may not. I want the join property to display all entries from this first table...

I have a form with a button that when pressed brings up a search form. The search form searches a query from which the primary form data is extracted. No errors are being reported with the search, but the search is not functioning properly. I get a message saying the search has filtered the...

When I enter information into two of my five subforms I get the following error: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data...

Hello. I am a new here and have found this resource to be vastly informative. Much thanks to everyone. With that said, I am struggling with the following issue: Currently, the only way I know how to retrieve information from my database is by writing a query or using a filter. Writing a query...