Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2010
    Posts
    36

    Unanswered: How to run append queries programmatically+mulilanguage

    Hi;

    I have two issues. The response highly appreciated.


    1.
    in my database i have created a number of more than 100 append queries. i need a code to programmatically switch a button to run all the append queries in my access database.

    2.
    i would like to make my database wich is in ms access to add multilanugate option. Do you guys know or have an access database that have this functionality or you guide me.

    thanks;

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    1. Create a table that will contain the names of the queries to be run:
    Tbl_Queries
    Query_Name: Text(128)

    2. Use this code:
    Code:
    Sub BatchQueries()
    
        Dim dbs As DAO.Database
        Dim rst As DAO.Recordset
        
        Set dbs = CurrentDb
        Set rst = dbs.OpenRecordset("Tbl_Queries", dbOpenSnapshot)
        With rst
            Do Until .EOF
                dbs.Execute !Query_Name, dbFailOnError
                .MoveNext
            Loop
            .Close
        End With
        Set rst = Nothing
        Set dbs = Nothing
    
    End Sub
    Have a nice day!

  3. #3
    Join Date
    Nov 2010
    Posts
    84
    The attached is a solution to the first question.
    The second question I do not understand.
    Attached Files Attached Files

  4. #4
    Join Date
    Dec 2010
    Posts
    36
    Thanks

    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.

    tnx

  5. #5
    Join Date
    Nov 2010
    Posts
    84
    Several of them complained about the zip file is attached. It is not clear to me where the problem is.
    my email: zoran.eremija@gmail.com

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •