I would like to add to my script a dialog box where the user selects the database that is to be opened and tested. I also want another dialog box where the user can enter a part of a output database name (like the year) and use that value in a variable to name part of the output table, if that makes sense.
So part of the output database name would be static, like Duplicates Payment Test and then add the variable for the year at the end.
Thanks in advance!
Hi Brian, thanks so much for the quick response. I will go ahead and look at some of the attached scripts here and see if I can grab what I need.
Another quick question for you: do you know of any scripts or functions that I can use in IDEA to replace multiple characters in a string field in one attempt? I know there is the @Replace function in IDEA but I think this only works for single find and replaces.
Let me know what you think!
Mike