Tab form displayed and updated whilst running VBA

[Brombrough]

Hi,

Thanks in advance.

Many years ago, I was shown that its possible to display full screen type form, display only, could not save, form that shows completed actions whilst running a lengthy vba code.

The best way to describe it is a progress sheet (Not Bar) that rolls up the page when another line is added.

list would look something like this (Example shows 1 & 2 complete and 3 incomplete:-

Record No | no of address| Currency |total Account Value | Time Started | Time Ended |
1 | 45 | AUD | $459,256 | 08/Nov/2017 (11:49) | 08/Nov/2017 (12:53) |
2 | 457 | GBP | £457,885 | 08/Nov/2017 (11:43) | 08/Nov/2017 (13:14) |
3 | | EUR | | 08/Nov/2017 (13:14) | |



Hope you get the gist.

 

[ranman256]

the form can be set:
recordsetType = snapshot
allowedits = false

you can set a timer to refresh the form every X seconds:
timerInterval = 10000 (10 seconds)

put a requery to update the form, in the TIMER event

Private Sub Form_Timer()
SubForm.Requery
End Sub