>Hi all:
>
>I have a crosstab that is generated each time a user clicks a date. The results are fine, but what I see also is the VFP message that says "Generating ..." each time i click the Olecontrol.
>
>Is there a way of preventing that message from showing up? Thanks in advance.
You can call LockWindowUpdate() with the hWnd of the Form owning the Olecontrol before calling the crosstab, and releasing it on completion of the crosstab; VFP 7 publishes the hWnd of a Form as a Form property; you'll need to use FOXTOOLS or an API call to get the hWnd for earlier versions. The prototype for LockWindowUpdate() is
DECLARE INTEGER LockWindowUpdate IN WIN32API INTEGER hWnd
To use in VFP7:
* Prior to calling the crosstab:
=LockWindowUpdate(thisform.hWnd)
* call the crosstab, and when it completes:
=LockWindowUpdate(0)
A less extreme measure that might work would be to set the LockScreen property of the Form to .t. before calling the crosstab, and resetting it to .f. on completion; I'm not certain if a contained OLEControl obeys the VFP Form LockScreen property or not.