Selecting Database and Dialogs/Variable

mkeiffer33

Forums

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!

Brian Element Sun, 10/11/2020 - 16:43
Hi mkeiffer33, If you look at any of the scripts on the site most of them do something similar to what you are interested in. So check them out and if you have any questions please let me know. Thanks Brian

mkeiffer33 Sun, 10/11/2020 - 17:52

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