Hi Mihail,
Thanks for the reply.
I have used the following code to close all the queries, tables opened.
Sub close_all_queries()
Dim qry As DAO.QueryDef
For Each qry In CurrentDb.QueryDefs
On Error Resume Next
DoCmd.Close acQuery, qry.Name, acSaveYes...
Hi Mihail,
Thanks for your reply.
But i am not using any object to make them null.
Each field of the form are binded with the table.
When the user starts typing in any of the field of this form, we are generating accordingly in the other form using "Filter" Method.
Please let me know if you...
Hi All,
I am getting the error "Bugs: Error 3014 - Can't Open Any More Tables" at the below highlighted code.
main_query = Right(main_query, Len(main_query) - 5)
Form_PersonenÜbersicht.Filter = main_query
Form_PersonenÜbersicht.FilterOn = True...