Search:

Here's some more info on the error...

Error # - 20515
Error in File C:\report.rpt:
Error in formula <Record_Selection>.
'{report.sample_ref_no} = 32623'
This field name is not known.

I hate to resurrect this thread, but I'm still struggling with this issue. It appears that ANY report which has a sub-report is throwing this error. If I delete the sub-report then it works, but I...

I've been Googling like crazy and trying to find a solution and haven't found anything that works. I need to display TIF images in a PictureBox on a XP machine. I understand that VB6 doesn't...

Hm, I don't think Windows is corrupted. I'm trying some workarounds.

You're right! The Err.Description was being written to the MsgBox and it was blank! (Sorry, I'm a C# dev and VB6 is new to me)

Ok, so I added in the Err.Number and Err.Source and got this...
...

I restricted the query to only return the top 10 records and I still got the blank MsgBox...

30935

I got a RecordCount from adoBrowseRS and it is returning 22,000 records. Is that too much for the grid to handle? Seems to work fine on other machines though.

Interesting. That got me further, even though I don't think I'm using DOA. Now this is the line that is just showing a blank MsgBox...

Set grdBrowse.DataSource = adoBrowseRS

Wow, so I added some MsgBox statements into my code to test on a couple of these machines and I have narrowed it down to these lines...

Set adoBrowseRS = New Recordset
...

I agree and I checked that, but the machine I checked where my app isn't working has SP3 installed.

Also interesting, the OLE32.dll versions are different between the systems...

WORKING: 5.1.2600.6168 (xpsp_sp3_gdr.111101-1829)

NOT WORKING: 5.1.2600.5512 (xpsp.080413-2108)

What...

I just ran Dependency Walker on a machine with a brand new install and here's what I'm seeing...

30933

I'm distributing that with my app. The weird thing is that my app works on some machines but not others. Really getting confused as to what is causing this!

Here's a screenshot of both References and Components. I don't see Sheridan or SSOLEDB specified.

30929

30931

Everything is on XP.

Stupid question, how do I get the SSOLEDB version? What DLL does that come from?

Ya, I figured it was one of those but I can't figure out which. I have every file from the deployment wizard in my INNO script and still nothing. Is there an easy way to find out what files it's...

I've got a VB6 application that I'm trying to distribute and I'm using INNO to create the installer. I love INNO and it works great, but I appear to be missing some components. When I run the...

Looks like it was the sub-report! I removed it since it doesn't dynamic content and it worked. Thanks!

Alright, here's the 'meat' of the code and the values being passed...

strConnect = "DSN=server;UID=username;PWD=password;DSQ=DBName"
strSelect = "{ANALYTE_MANIFEST_JOIN.RELEASE_RESULT} =...

Sure, I will get that together and post it. It may be tomorrow though.

No, it works every time without issue when I run it from the IDE. This is only when my VB6 application calls it. It works the first time, but fails every time after that. I looked at every...

Several times

Here you go...





Crystal Report Professional v8.5 (32-bit) - Report Definition

1.0 File Information

I keep getting an 'Error in Formula' message that states that the 'field name is not known' in the record selection when I open my report a second time from my VB6 application. It works perfectly...

How do I find out what the current database driver is? It looks like I need to change the driver, but I need to know what it currently is so I can change it back.