Detecting a user disconnect

[BHuett]

I have an Access 2007 app running in a virtual machine environment. I would
like the app to be able to detect when the user disconnects from the virtual
machine. Any suggestions?

 

[John Spencer]

You are not doing anything wrong. When you use Down then Across in a
subreport, Access is unable to determine (for some reason) where the page ends
as far as the subreport is concerned.

You're stuck with using Across then down if you want to have a multi-column
subreport.

I've worked on some complex code to render down then across in a subreport,
but have not yet fully succeeded. If the lines are consistent in size (no can
grow/can shrink) and the records can be ranked uniquely, I've come close, but
my last page still prints out with across then down order.

The code figures out the page number, the column number and the overall order
by performing arithmetic operations of the ranking number. It is definitely
NOT ready for any use at this time.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County