[AccessD] Docmd.GoToPage when Access loses focus

The best workaround for this I've found is to use a tab control instead
of form pages.  

Charlotte Foust

-----Original Message-----
From: Joshua B [mailto:lists at jbsolutions.com.au] 
Sent: Thursday, July 03, 2003 3:33 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Docmd.GoToPage when Access loses focus


Group: 

I have created an Import/Export wizard which uses page breaks in a form
to go to each step. The final processing step shows a "status bar" of
sorts which lets people know the wizard is working. 

When processing is done, the code DoCmd.GoToPage (4) takes the user to
the final screen (export successful, yada yada yada).

The problem is, the processing takes around 20 seconds to do, and during
that time one of my users decided to check their email or something. As
a result, they get the error "Error 2046: The command or action
'GoToPage' isnt available now. It seems that Access can't change pages
unless it has focus.

Does anyone know of a workaround for this or do I (a) Tell users not to
switch windows... (b) Redesign my wizard?

Best regards. 

Joshua B                
lists at jbsolutions.com.au 
www.jbsolutions.com.au               
2003-07-04                


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com