General discussion
empty tables for export
Forums
Hello,
How to control if an extraction is empty, which macro continues to export and does not give me a stop. o Idea does not export empty tables?
- Read more about empty tables for export
- 1 comment
- Log in or register to post comments
installing a menu called macros
Forums
Hello,
I recently finished a menu that invokes various macros or scripts, and created the project that is going to contain that menu, set it up in the IDEA ribbon.
the question is:
where do the macros or scripts reside do they have to be projects too?
What are the best practices for this menu to work and not give me an error?
have the programs in the menu project in the library macros.ILB ?
Thanks it's my first application in IDEA Scritps
- Read more about installing a menu called macros
- 2 comments
- Log in or register to post comments
IDEA programming book
Forums
Hello.
Does anyone recommend me a book on script programming in IDEA with VB?
- Read more about IDEA programming book
- 2 comments
- Log in or register to post comments
pass two dates as parameter captured in a TextBox
Forums
Hello everyone,
I am making a menu which has several cases, in each case I have to do the date conversion routine, what I need is to create a function where I return the values in the desired format, so as not to have to repeat the codes of conversion of the date in each case.
Thank you
Example.
Case 0
- Read more about pass two dates as parameter captured in a TextBox
- Log in or register to post comments
No. of Records in Multiple database
Forums
Is there any way to crate a list of databases name and count the no. of records in each database of a folder?
- Read more about No. of Records in Multiple database
- 5 comments
- Log in or register to post comments
Multiple Excel Sheets Importing
Forums
I have an excel file with more than 20 sheets and the header row is the fifth row. Is there any way to import multiple sheets of a single excel file? Also, can we consider 5th row as my header row?
- Read more about Multiple Excel Sheets Importing
- 1 comment
- Log in or register to post comments
For Looping (First, Second, Third, Fourth,.....)
Forums
Set db = Client.OpenDatabase("Working\Management Fees Final.IMD")
Set task = db.TableManagement
Set field = db.TableDef.NewField
field.Name = "FIRST_DDN_MGMT_FEE"
field.Description = "Added field"
field.Type = WI_VIRT_NUM
field.Equation = "-FIRST_DDN_AMOUNT*COL2*FIRST_DDN_DURATION/365"
field.Decimals = 2
task.AppendField field
task.PerformTask
How to call folders in file explorer
Forums
Hi Brian
I hope you are doing well.
I have question for you. I would like to create a drop down list for lots of folders in a folder (these folders are not in the project folder or directory).
Suppse we have a folder in our computer and in that folder we have 35 folders. So these 35 folder should be in the drop down list in the dialog box (instead of writing the folders name in my dialog box, I would like to pick the name from the list)
Is it possible to do that?
I have attached the dialog box I created
- Read more about How to call folders in file explorer
- 2 comments
- Log in or register to post comments
which function can do the same thing as seekv
Forums
which function can do the same thing as seekv, I have two databases and I want to lookup a value in one and return it in the other. tks
- Read more about which function can do the same thing as seekv
- 1 comment
- Log in or register to post comments
Thousands separators in the dialog box
Forums
Hi Brian,
I have a question for you. I was wondering if we could use the Thousand separators while we type in the edit boxes?
I mean when we type 12000000, it automatically turns to 12,000,000.
Thanks,
- Read more about Thousands separators in the dialog box
- 2 comments
- Log in or register to post comments