Who can help me?
I have command button which working whith more then 20 cursors (query command).
I have to run this command again and again (for example on seperate dates).
The problem is that if the cursor existed I get message 'Alias name is already in use' (Error 24).
I have two options:
1. To start the code with the following commands:
if used ('cursor1')
use in cursor1
endif
if used ('cursor2')
use in cursor2
endif...
2. To start the code with 'close all'.
The problem with the first option is that I have to use with about 50 lines for to prevent the problem, and with the second option I have other problem (Fore example loosing my combo boxes row source, my oApp etc...).
How can I say simply 'If the cursor existed, replece it with the new one'?
Thank you for answer
Thank you
Chaim