Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    Sydney Australia
    Posts
    369

    Unanswered: Running code that is OnClick on labels

    I have four labels on a form that have code on the OnClick. This code in each case opens Word and inserts field data into BookMarks and each Word doc is linked to two queries. The code then then copies the Word doc and pastes it back to a memo field in Access and prints the Word doc and closes Word without saving. I am using Access 95.

    Is there anything I can do to make each of the four codes run one after the after. Perhaps some sort of code in one of them to run the other three like one uses a macro to do runmamcro actions

    By the way my knowldge on code is quite limited. This data base has about 3000 macros and 2000 queries and only a few labels containing code to open Word so you get the idea

    Thanks for any help

    Mike

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Call myLabel1_Click()
    Call myLabel2_Click()
    Call myLabel3_Click()

    Of course you may want to make sure each WORD session is finished before executing another new session.


  3. #3
    Join Date
    Apr 2004
    Location
    Sydney Australia
    Posts
    369
    Thank so much

Posting Permissions

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