Results 1 to 7 of 7
  1. #1
    Chuckd is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2021
    Posts
    14

    How to Step Through Macro from Form Event

    Good Morning,
    I am very green (very Green) in learning Access so forgive me if I don’t give the right terminology in my description of my issue.
    Can someone tell me how I can step through a Macro once I’ve initiated the event in a form?
    I think that this would lead me to resolving a couple of roadblocks I have on my project.



    Thanks for any help, it would be greatly appreciated.

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,614
    I'm not sure about stepping through macros but I don't think that can be done.
    You could use the wizard to convert all the macros used on a form into VBA which can definitely be stepped through.
    VBA code is what most advisers here are most familiar with.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,821
    Hi

    It would help if you could give us a more detailed explanation of your current roadblocks.

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    I've only run macros single step interactively, but there is a SingleStep action.

    Put that as your first macro command. Remove when done.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    Chuckd is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2021
    Posts
    14

    Thumbs up Solved

    @Welshgasman, @mike60smart, @ BobFits
    Thank you for answering up on the call for help. I will reply back to each in a moment, but I just wanted to thank all 3 of you.
    The problem has been solved and I primarily follow what the @welshgasman advised. Stepping through the problem lead me to fixing 6 issue that was causing the one major headache.
    Good to see that things still get done when you get a bit of help.
    Again thank you all.

    - Chuckd

  6. #6
    Chuckd is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2021
    Posts
    14
    Bob thank you for your reply.. I really do appreciate it. Welshman suggestion helped me step through the macro which in turn help me solve the problem.
    Again thanks for the reply.
    I still have a lot to learn of course.

    - Chuckd

  7. #7
    Chuckd is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2021
    Posts
    14
    Welshgasman,
    Hey thank you for your response. It really help me in finding the cause of my issues and as a result I was able to resolve the problem I was experiencing in my form.
    I still have a lot to learn, but it is great that I was able to solve the issue with a bit of help from friend.

    Again thanks for responding

    - Chuckd

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

Similar Threads

  1. Skip a step in Macro
    By lmh329 in forum Macros
    Replies: 1
    Last Post: 08-29-2017, 09:15 AM
  2. Replies: 2
    Last Post: 10-21-2016, 11:26 AM
  3. Macro Single Step Error
    By cfspartan in forum Macros
    Replies: 6
    Last Post: 04-25-2015, 12:05 AM
  4. Replies: 1
    Last Post: 02-26-2015, 11:31 AM
  5. Replies: 7
    Last Post: 07-12-2013, 01:49 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