Search results for query: *

Answered my own question. After reading some more documantation came across LAG function.

Is there a way to get the difference of dates for consecutive records for a grouping. Example: Customer Service Date DaysBetweenService Bill 1/1/03 Null Bill 1/5/03 4 Bill 1/30/03 25 Joe 1/15/03 Null Joe...

Nevermind, after hours of frustration I figured it out. The sendkeys needed to be sent before the openreport method occurs. I was able to get the following example to work with three picklists. Sub Main() Dim objImpApp as Object Dim objImpRep as Object Set objImpApp =...

i don't have the capability to do what you suggest. we're very limited in what we're allowed to do. i would like to explore using the sendkeys. i understand the theory but i can't get them to work. it seems that in the macro when the report opens and the picklist appears, the macro comes to a...

The report I'm running is never used by anyone else. We're using impromptu as a query tool only. I'll be the user and on a quarterly basis I get a list of IDs that I need to query for. I don't want to do this in the SQL writer because I don't want to lose all the functionality of impromptu. I...

Has anyone ever successfully used sendkeys in a macro to automatically select all values in a picklist? After searching the posts it doesn't look like this can even be done.

Does anyone know what causes DB2 to stop working after loading Oracle on the same machine. When connecting through ODBC I get a message that Setup routines could not be found. It seems that if the PC is re-imaged and Oracle is loaded first then DB2 it works. I would like to get to the bottom of...