Search results for query: *

John, Have you tried using the ActiveX Designer Run Time? I've always had much more difficulty using the Report Engine... I encountered various errors when using the Report Engine but was able to pull it off seamlessly using the ActiveX library. Benjamin Scott thename@mindless.com

John, I do the same thing. You export the report and then work through Outlook (I'm assuming you use Outlook which is likely dumb of me). Const FILE_NAME As String = EXPORT PATH AND FILENAME Const REPORT_NAME As String = YOUR REPORT PATH AND FILENAME Const RECIPIENT_ADDRESS As String =...

Once you have the reports set up it's easy to write a VB app to automatically export them to a file. General VB code to export a report to Excel: Dim crApp as new CRAXDRT.Application Dim crReport as CRAXDRT.Report Dim crExport as CRAXDRT.ExportOptions Set crReport = crApp.OpenReport(REPORT...

MissingNo, Check out Microsoft's Knowledge Base article 266717 at http://support.microsoft.com/support/kb/articles/Q266/7/17.ASP?LN=EN-US&SD=gn&FR=1&qry=dcom%20sample&rnk=10&src=DHCS_MSPSS_gn_SRCH&SPR=VBB It outlines the steps for creating a simple DCOM application and the basics of using...

Jerry, I e-mailed the sample database to you and the only query I've been able to come up with to pull records with different Event_Location. I can send you the queries to update the first and last events if you'd like them for reference purposes. Thanks! Ben Scott

Addendum: I should add that I've now pulled records where the Event_Locations did not match while the Claim_IDs did but end up with extra records. For example, using the data posted previously I come up with: Claim_ID a.Event_Loc b.Event_Loc a.Event_ID b.Event_ID 10114 1073 1075...

Thanks Jerry! Though my example was populated with idealized data and the actual Event_IDs are not sequential, recursive linking was useful. Unfortunately, it didn't get me too far; I can pull the distinctive locations but, again, can't compare them to their surrounding records. I appreciate...

Well, had a consultant run away and drop the huge project he couldn't handle in my lap. I'm thus forced to figure out and implement a single query before a go-live tomorrow morning. Any SQL references I've been able to peruse haven't put me on the right track... So here's my problem: I've got a...