General discussion
Modality of message boc
Forums
Hello all,
Any idea on how i can set a message box in such a way that it appears infront of a dialog box and not behind it?
- Read more about Modality of message boc
- 2 comments
- Log in or register to post comments
ODBC Import - Date Filter
Forums
Hi there,
Does anyone know how data can be imported using the ODBC connection feature in IDEA with applying a filter on a date field? I have tried numerous formats for dates ('YYYY-MM-DD') and ('MM/DD/YYYY'), using both a live Oracle database and Excel practice files but nothing seems to work. I can filter on character and on numeric fields with no problems, but date fields do not seem to work.
Does anyone know how to fix this or is this a bug in IDEA with the ODBC connection?
Any help would be appreciated!
Mike
- Read more about ODBC Import - Date Filter
- Log in or register to post comments
Access Import Format not found in Import Assistance
Forums
Hi All,
Can any one help me in this issue please , i did not find in the Import Assistance Tab the Access Format and I am using IDEA 10.3.0.1139 (X86 Unicode) Thanks
- Read more about Access Import Format not found in Import Assistance
- Log in or register to post comments
Site will be offline during July
Forums
Hello everyone, I just want to let you know that the site will be offline sometime in July for an upgrade along with a move to a new host. Depending on how things go this could be over several days.
Brian
- Read more about Site will be offline during July
- Log in or register to post comments
Internal Auditors
Forums
How many people here are internal auditors? I'd love some ideas on ways to use IDEA in all sorts of areas. I work for a tribal govt in Internal Audit and am also a CFE. I use IDEA in a variety of ways usually for special projects like the new Covid 19 payroll, and determining turnover but would love to develop some weekly/monthly recurring analysis using the data I can get from our accounting system and the HR system. Eventually I'd like to get access to the gaming data. How many have the IDEA certifications? I've been looking at jobs and a lot of
- Read more about Internal Auditors
- 5 comments
- Log in or register to post comments
How to make a join with scripting - Criteria problem
Forums
Hi!!
While I was studying, i tried to make a join between 2 databases that I already have both IMD files.
I have a criteria inside IDEA, but I can't use the same criteria using IdeaScripting..
Would you mind helping me to fix it? Please!
Set db = Client.OpenDatabase("SR3_STEP1.IMD")
Set task = db.JoinDatabase
task.FileToJoin "SR3_STEP2.IMD"
task.IncludeAllPFields
task.AddSFieldToInc "ID_SR"
CIDA
Forums
Just got an email that I qualify to take the CIDA exam and wonder how useful having that certification actually is? I'm a CFE and have the IIA's Certified Govt Audit Professional.
- Read more about CIDA
- 1 comment
- Log in or register to post comments
Complete Guide to Auditing with Data Analytics Tools
Forums
I have this and it breaks down various areas to audit (AP, AR, GL, etc) and gives a list of things to do but no examples of how to do them using IDEA? Is there somewhere that provides this information? Is there a script out there or in the Analysis area? Thanks in advance.
Webinar on Custom Functions
Forums
I did a webinar for SAMA on custom functions. It is not available on YouTube if you want to see it. It is about 45 minutes long, first 30 minutes is my presentation and the rest is questions. I go through three items, one is a simple custom function to show how they can be created, two is showing how you can take a fairly difficult equation in the Equation Editor and make it more readable as a custom function and third is creating custom functions that aren't available in the Equation Editor.
- Read more about Webinar on Custom Functions
- Log in or register to post comments
Empty Tables corrupting joins
Forums
Hello,
- Read more about Empty Tables corrupting joins
- 1 comment
- Log in or register to post comments