You need to scrape the screen name and then use a Select Case statement. Physedo code below
Select case Myscreen.Getstring(x,y,l)
case is=Screen 1
open doc for screen 1
case is=Screen 2
open doc screen 2
......
You may experiance problems with the Do While xstatus<>0 because if the users enters an invalid character or other varous situations the xclock can stay at different values therefore creating an infite loop. I have had this situtation in the past. But you can add a select case statement to the...
What do you mean by disable? I don't think there is a way that you can have access just ignore the event but you could use Global Variables to just not do anything in the events. For example create the below global vairables in a module
Public blnFrm1 as boolean
Publicl blnFrm2 as boolean
...
Sorry but I don't usnderstand what you are trying to do. Can you please give an example of what you are trying to achieve and I am sure someone could help you out. I know I can for sure but I don't understand the question.
Why not just trap the error and then prompt the user to close the table.
Actually, why not check to see what database object are open (ie tables, queries, forms) and if any objects are open prompt the user to close them before deleting the tables.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.