Recent content by adale

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.