Results 1 to 5 of 5
  1. #1
    fluffyvampirekitten is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jun 2015
    Posts
    108

    Macro can't run. No error pop out.

    I copied a button from another form. I pasted this button in Form B but when I edited the macro , the macro isn't running .
    Why is that so ?
    Any ideas ?


    Thanks in advance .

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I don't use macros, only VBA. Macros are harder to debug.

    Have to review code. Post code or db for analysis.
    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
    fluffyvampirekitten is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jun 2015
    Posts
    108
    Click image for larger version. 

Name:	Capture.JPG 
Views:	9 
Size:	83.5 KB 
ID:	21616


    The image above is the macro that I'm trying to do .
    I'm not really confident with access vba , I have only use vba on excel hahaha..

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    So is this an [Embedded Macro]? What is in the button Click event property?

    If you used VBA in Excel, should be able to do well enough with it in Access.
    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
    fluffyvampirekitten is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jun 2015
    Posts
    108
    Quote Originally Posted by June7 View Post
    So is this an [Embedded Macro]? What is in the button Click event property?

    If you used VBA in Excel, should be able to do well enough with it in Access.
    I got it. I just used vba and its easier to debug that way . Thanks for the tip.
    I'm not familiar with the access vba yet.

    Most of the time when I embedded macro , it isn't working properly. And I have no idea why.
    So , I used vba instead.

    Thank you for the help! I really appreacited it.

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

Similar Threads

  1. Replies: 1
    Last Post: 01-13-2015, 01:33 PM
  2. Help with Error in Macro
    By Sousuke81 in forum Macros
    Replies: 14
    Last Post: 09-10-2014, 11:09 AM
  3. Macro Error
    By enquiries in forum Access
    Replies: 6
    Last Post: 04-16-2014, 10:44 PM
  4. Replies: 2
    Last Post: 05-05-2012, 02:34 AM
  5. error in macro
    By nawaray in forum Access
    Replies: 0
    Last Post: 02-10-2009, 12:06 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