The Looping Search App identifies specified keywords in a table or large database to help identify potential red flags, such as the purchases made at unapproved merchants. For example, the user can decide whether to allow “spa” to bring in all words starting with those letters, such as “space,” or only search for the word “spa.” This new capability will help look for specific words or fragments for a more refined search when analyzing large data sets. This App now includes a dialogue box providing users with the choice to perform flexible or exact keyword matches. This App is highly effective for P-card and T&E audits. The Looping Search offers the ability to tag data in a subfolder for easy access to analyze.
The App automatically creates a subfolder to store the database with the final results, which is flagged to make it easier to find. Results are ordered from highest to lowest based on hit rate to quickly identify potential fraud or infractions. Need to search large databases for specific words or phrases, but don’t have time to perform individual searches? The Looping Search App conducts multiple searches at a time across single or multiple fields using keywords or wildcard fragments contained in a second file. Search one or multiple fields using a list of key words or wildcard fragments to quickly identify fraud. Instructions for tagging databases are provided in the User Guide, provided with the suite. If these fields are not available in one database, a database can be created by performing a join of HR Master Data and Payroll Transaction Data in IDEA using common fields, such as employee ID. This requires access to both HR Master Data and Payroll Transaction data. You will need to tag individual fields in order to run the tests.
The final scorecard database includes action links to drill down into the data to see more details. Employees who fail the most individual tests are sorted in descending order from highest to lowest. To collect an overall risk rating by an employee, the user sets the risk level to high, medium or low for each test. This complete suite contains a dialog box allowing users to select which tests to run, input additional information needed for specific parameters and control how scores are weighted. Quickly identify employees who are potentially violating payroll processes or controls with this suite of 14 tests that can be run in various combinations, including the ability drill down for greater detail. ' Inhalte des Datensatzes lö' Datensatz speichern.rs.Suite of tests designed to analyze employee and payroll data to rank potential violators by risk level in a scorecard format. ' Ersten Datensatz aus der Datensatzgruppe ermitteln.rs.ToFirstSet rec = rs.ActiveRecordrs.Next' Anzeigen, dass der Datensatz Daten enthält.'MsgBox "NR = " & rec.Value("NR_V") Hier wird festgelegt welcher Datensatz gelöscht wirdrs.Criteria = "NR_V =" & ResultLöschen ' Datensatzgruppe aus der Datei ermitteln.Set rs = db.RecordSet' Kriterium für RecordSet definieren. Maybe I need to re-index? How can I do that?ī) is there anyway which is shorter/nicer to remove a record from a database?
I close an re-open the database to invoke a GUI update, then I extract the with NR_V >= 1 th get rid of the one cleared line.Ī) My script only works one time. Actually it is not deleted but it is "cleared". I ask the user to supply a Numer (NR_V) and then "delete" that record.
My Comments is in German but the Code works a bit. That Data is used for Comparison and so it's OK to edit it. I would like to add or remove records from an IDEA Database.