Cash Flow Modelling

Resolved · Low Priority · Version 2003

Fri 19 Jun 2009, 16:35 Delegate David said...

David has attended:
Excel VBA Intro Intermediate course

Cash Flow Modelling

What's the best way to aviod iterations in a cash flow model using VBA?

Mon 22 Jun 2009, 11:22 Trainer Stephen said...

RE: Cash Flow Modelling

Hi David

Thank you for youir question

Could you please expand upon your question with a specific example. In particular can you explian what you mean by iterations in this context

Thanks

Stephen

Fri 4 Sep 2020, 20:50 Maira Bode (guest) said...

RE: Cash Flow Modelling

If you have your own business or you are just planning to open it, remember that the most important thing is to control cash flows and the vision of accounting documents, otherwise you may start having problems. I honestly admit that I'm not good at this, so I turned to https://finmodelslab.com/templates/12-month-cash-flow-statement/ for help, you can use this template to create a cash flow forecast. You have to keep in mind that one of the biggest challenges in running a small business is the 12 month cash flow forecast. If you want to avoid problems, but are poorly guided in this area, then you undoubtedly need help.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.

Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.

To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.

Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.

However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.