Hello guys,
The situation is the following: I have a data table for the records, and 1 record includes 12-14 different information.
I have a form for creating new records, but sometimes I have to update previously created records. The database is protected, the user just clicks on the Add record or the Search record button, everything else is disabled.
So currently searching is done by a parameter query with the 2 most important information, which displays the findings in the same form format as it was recorded.
However my users let me know that sometimes they do not know this information, but something else and they should be able to search based on that information too - they identified that iso of 2 paramters they would like to search 5-6 parameters.
However, 5-6 small popup window is pretty annoying, 2 is OK, 6 is ridicoulous.
I tried to solve it with Query by form, creating a search form with the neccessary parameters, but the problem is that it gives the results back in a data table view - which I would like to avoid, and use a form.
The other problem is that the records are too complex, and access often gives the following error message after running the search a few times: ERROR: THe query is too complex!
So I tried to solve it with coding, like Allen Browne's example
but the results cant be updated with this method too
could you please advise, what could be the best solution in this case ? or link a few databases I could use as reference ?
I think the best would be something like allen b.'s solution (with VBA coding) but giving back the results in a form view or in an updatable view
The situation is the following: I have a data table for the records, and 1 record includes 12-14 different information.
I have a form for creating new records, but sometimes I have to update previously created records. The database is protected, the user just clicks on the Add record or the Search record button, everything else is disabled.
So currently searching is done by a parameter query with the 2 most important information, which displays the findings in the same form format as it was recorded.
However my users let me know that sometimes they do not know this information, but something else and they should be able to search based on that information too - they identified that iso of 2 paramters they would like to search 5-6 parameters.
However, 5-6 small popup window is pretty annoying, 2 is OK, 6 is ridicoulous.
I tried to solve it with Query by form, creating a search form with the neccessary parameters, but the problem is that it gives the results back in a data table view - which I would like to avoid, and use a form.
The other problem is that the records are too complex, and access often gives the following error message after running the search a few times: ERROR: THe query is too complex!
So I tried to solve it with coding, like Allen Browne's example
but the results cant be updated with this method too
could you please advise, what could be the best solution in this case ? or link a few databases I could use as reference ?
I think the best would be something like allen b.'s solution (with VBA coding) but giving back the results in a form view or in an updatable view