Search results for query: *

I didnt get a response to this one, but figured it out anyway. The reason Access crashes is because it cant make sense of an error that was being generated when the recordset opens. If you should encounter such a frustrating situation as I've described, then take the SQL and check that it runs...

The following code attaches to an Oracle database to draw data into Access. It works about 25% of the time and crashes the rest. The crash is horrible as it doesnt show me an error message, but instead closes the database pops up a window saying "Microsoft Office Excel has encountered a problem...

I'm sure it would work if I had VS.Net, but I only have VB.Net. The best I can get is for the report to be pointed at the server before being referred to in the app.

Has anybody managed to get the ActiveX reporting object to work. We have the regular CrystalReporting object working, but it lacks the cool search/filter function. We're using CR10 with VB.Net to a SQL server. Here's the code we used in VB6 that worked. Dim secSecurity As...

I couldn't find an example that works. Here's what I have at the moment, though it changes as I try different things. I dont attached recordsets to the reports as I want to use the DR designer independantly, and only have sufficient code in the app to show users a menu, then load the report...

Unfortunately I've got VB.Net and CR10. The functions in VB.Net are as closely tied to CR as the whole Visual Studio .Net package.

Has anybody every seen example code for the active X viewer that comes with CR10. The examples on the Business Object site are all for the Crystal Report Viewer which doesn't have the funky data filter function. Thanks

Sorry for being dumb, and thankyou for the quick response, but I couldn't make out what I should be using from the exmaple. I'm looking for something small and simple that tells me the PID of active an program.

We are trying to write code to interogate which application a user has running on their PC prior to our code attaching to that application. We tried different ways like using error codes, so if one app isn't there the code would try the next one, but that didn't work. So we are now looking at...

As luck would have it, I did get the error again after I wrote that email. Then I found some further email therads that said the .val file related to the bad tables can sometimes get confused. They can be deleted and will get recreated by the database automatcally. Since I deleted those .val...

I think I've found what part of the problem is now. The production files are moved to a reporting server and in that process one of the .val files wasn't getting updated. I totally refreshed the report server copy of the files and am not getting the error so much now. I've also stopped the vb...

The whole thing runs on a desktop PC with WinXP. I'bve just found out that it's 2 service packs out of date so am updating that first. The user either runs a VB app to populate the database, or goes into Paradox itself and uses forms & reports. Normally they would use each method exclusively...

Worst offending table is 308k. It has a primary and secondary index and 3 lookups too. Next worst is 8,316k. Block size is at the default 2048

I am experiencing loads of issues with indexes breaking on heavily used tables. Is there a known bug that requires indexes to be rebuilt almost on a daily basis?

I've got the answer now from http://www.tek-tips.com/faqs.cfm?fid=5374. Tested and working well on all reports. Thankyou again for your help.

After days of pulling out what hair hasn't already fallen out from the stress of the impending UAT date, your code is so welcome that I might have to go out and celebrate. Thankyou

Did you ever find the code to switch between servers. I've been having this problem for ages and can't find anything that does it correctly. Or rather, I can onyl switch it for bog standard tables or SPs that use no parameters. Thanks

Have you got an example of the code? I'm trying to repoint reports designed in CR10 and attached to VB6 as dsr's. I can't find anything to repoint that works. I cant get a lovely ADO recordset working, and that repoints, but the recordset wont attached to the reports. And the reports have up to...

Still no good I'm afraid. I'm trying to go another route now. Specifically, to use a DataEnvironment in the project, then link the reports I import to that. I started on the idea based on the example files installed with CR10. There should be a way of pointing reports to the DE, but I haven't...

I ran the code in the form as you suggested and it did what it's been doing all along. It runs the code, opens & executes the recordset fine. Then it opens the report against the default server/database asks for the parameters and shows me development data. This code cant be the right road to...