Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Location
    Gatineau, Quebec Canada
    Posts
    151
    Provided Answers: 1

    Unanswered: Dynamically Changing Reports and Queries in Compiled Programs

    Greetings all,

    I recently discovered that we could dynamically change reports and queries. The former via, for example < set qdf = db.queryDefs("qryAname")>. We are actually modifying MS Access objects (reports and queries). Hog heaven. Then I compiled the modified program (to make it an ACCDE). Errors every time I tried the new routines.

    I gather one cannot change at least some Access objects via VBA in compiled programs. Anyone know what objects (queries, reports, etc) one can and cannot change in compiled programs. I am, but the way, running Access 2007 and 2010.

    J. Smith

    Aylmer, Quebec

  2. #2
    Join Date
    Mar 2009
    Location
    Gatineau, Quebec Canada
    Posts
    151
    Provided Answers: 1
    Hmmm. After some experimentation...it seems like we can modify queries, but not dynamically modify report sort orders after a program is compiled

Posting Permissions

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