1. Create a table that will contain the names of the queries to be run:
2. Use this code:
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("Tbl_Queries", dbOpenSnapshot)
Do Until .EOF
dbs.Execute !Query_Name, dbFailOnError
Set rst = Nothing
Set dbs = Nothing
But when i want to unzip the file it gives the following error message.
"cannot open file: it does not appear to be a valid archive."
regarding my second question:
i have created a small database. i want to view the forms and reports in at least three languages. the language will be selected by user from a list of pre-defined languages for example, english, french and arabic. i want my database forms and reports in 3 languages. Do you have such experience of designing multlanguage support for ms access.