Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Macros _ Omg Help....looping A Macro Until A Field In A Table Hits 0

Posted by: jconverse May 17 2020, 05:58 PM

Thanks in advance!! I really have been out of VBA and Access for 5 years and have lost some of my edge. I need to loop a macro from a Function until a field in the Table [MakeRatio]![ASK] reaches 0. I can take care of the counting within the macro but I need to call a function from RUNCODE in a macro.

Posted by: June7 May 17 2020, 06:16 PM

Why a macro, why not just VBA?

Posted by: theDBguy May 17 2020, 08:14 PM

Hi. Welcome to UtterAccess!

welcome2UA.gif

Just FYI, https://www.access-programmers.co.UK/forums/threads/i-need-a-function-to-loop-a-macro-until-a-field-reaches-0.311676/.