Results 1 to 5 of 5
  1. #1
    okan is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2017
    Location
    Switzerland
    Posts
    4

    Question Button should execute another invisible button

    Hello AccessForums.net

    Can someone help me?
    The macro-builder allows only 255 characters and I need more, now I thought, I could say on the first button, go and execute the secound invisible button for additional 255 characters.

    But my problem is, I don't have any Idea how to give an command like this.


    Can someone help me maybe with an example?

    Thank you very much


    Regards

    Okan Koc

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Macros can call VBA functions, not subs. So you can have VBA function that calls the button click event.

    Suggest you convert to VBA code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I never use macros. But the command you are looking for is "RunMacro"

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Tried this. Can't seem to call Embedded Macro.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Well, that is the Help file for you....

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Create button to execute other buttons
    By olepkord in forum Programming
    Replies: 1
    Last Post: 09-20-2016, 05:23 AM
  2. Replies: 9
    Last Post: 03-31-2015, 04:13 PM
  3. Button to execute graph data
    By MFS in forum Forms
    Replies: 6
    Last Post: 08-11-2014, 10:44 AM
  4. Replies: 4
    Last Post: 02-12-2014, 12:49 PM
  5. Form Button to Execute Disabled Ribbon Command
    By stwalke2 in forum Programming
    Replies: 5
    Last Post: 04-29-2013, 01:00 PM

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
  •  
Other Forums: Microsoft Office Forums