i'm trying to hide by database with this code: Application.CurrentDb.TableDefs(CurrentDb.TableDefs(i).Name).Properties("Attributes").Value = dbhiddenobject from some reason it doesnt work
Is it possible to open an existing access query, modify the criteria before save and closing using SQL? I know that I could use SQL to code the query, but I want to make the changes using SQL and then run a seperate query that is based on the