Hello:
I use an AutoExec routine which does the following:
1. Imports 10 tables where table names have prefix "Step_4_*"
2. Renames those 10 tables and removes prefix "Step_4_*" so that table names now start with "tbl_*"
3. Re-Imports same 10 tables (again) but now leaves prefix intact.
As a result I have 10 tables with prefix "tbl_*" AND 10 tables with prefix "Step_4_*". The latter works great and DOES NOT need modification.
Upon execution of the 1st import function call, the following message box is thrown:
Now, when I get to step #3 and I re-import the tables a 2nd time, I end up w/ the "Message #1" again. Instead, however, I'd like to throw the second message box instead.
I tried including a simple counter (e.g., n = 1)
Unfortunately, I only get to see "Message #1" since n will always equal = 1 (in this case).
Does anyone have a suggestion how to throw message #2 (vs. #1) when the same function is called a 2nd time?
I use an AutoExec routine which does the following:
1. Imports 10 tables where table names have prefix "Step_4_*"
2. Renames those 10 tables and removes prefix "Step_4_*" so that table names now start with "tbl_*"
3. Re-Imports same 10 tables (again) but now leaves prefix intact.
As a result I have 10 tables with prefix "tbl_*" AND 10 tables with prefix "Step_4_*". The latter works great and DOES NOT need modification.
Upon execution of the 1st import function call, the following message box is thrown:
Code:
MsgBox "Message #1"
n = n + 1
Now, when I get to step #3 and I re-import the tables a 2nd time, I end up w/ the "Message #1" again. Instead, however, I'd like to throw the second message box instead.
Code:
MsgBox "Message #2"
I tried including a simple counter (e.g., n = 1)
Code:
If n = 1 Then
... throw 1st message
Else
... throw 2nd message
End
Unfortunately, I only get to see "Message #1" since n will always equal = 1 (in this case).
Does anyone have a suggestion how to throw message #2 (vs. #1) when the same function is called a 2nd time?