Recent content by crimsntyd

Hi- I'm in charge of a fat client VB application at my company. A couple of years ago, we came across an issue where when the user brought up the Crystal Report viewer in the application, a Microsoft error would pop-up, and the whole program would crash when the user selected "send report" or...

Hi, I'm trying to graph a report that shows hours along the x-axis (group axis) and a query-generated result along the y (data) axis. But, the group axis keeps showing two decimal places, and I don't know how to get rid of them. I rounded the numbers in my database, so they're no longer...

Yes, I'd agree with Bob that the earlier version of the code had errors in it. Thanks again.

Call off the dogs, everyone. I went back to the conference room this morning, and an older .exe was on the machine. I put the current one on the desktop, and it worked fine. Weird thing, when I was in the meeting yesterday in the conf. room, we copied the .exe down off the network, and it...

BobRodes, I'm sorry, but I'm not seeing your logic. How can the record come up in its entirety on the Win2000 machine (more than one, by the way) and crash on the WinXP machine? If the recordset wasn't declared correctly, wouldn't it hose the Win2000 machine, as well? vbSun, Thanks for the...

Hi, I'm using a VB 6.0 app to connect to/edit/create records in an Oracle HTMLDB database. The application works fine in Win2000 (my PC), but gives the following error on WinXP machines when the user brings up a record to edit: Run-time error '3265': Item cannot be found in the collection...

I forgot that you have to do the MoveFirst then MoveLast then back to the first for the RecordCount to work. Thanks.

Hmm...I'm using DAO, not ADO, could that have something to do with it? I get the song in my database titled "Amazing". That's the whole title. Just FYI, when I search on '*rhythm*', I should get two records but I only get "Rhythm of the World". The other song is "Rhythm of Heaven". So, the...

OK, I tried that. It gives me NO records. Remember, if I type the query in SQL view in query designer in Access, I get 7 records, as I should. It's something to do with the VB app, I think, that for some reason is just giving me ONE. Any other ideas? I'm really stumped on this one.

Hi, I'm trying to populate a flexgrid in my VB 6.0 application with values from a query of an Access table: sql = sql & "SELECT * " sql = sql & "FROM SongInfo " sql = sql & "WHERE " & Sec1 & Sec2 & Sec3 'Populate flexgrid Set db = OpenDatabase(Appl) Set qu =...

Sorry. Any way around this?

I've tried that already. Doesn't work, because with the automatic reports I'm using for different analyses, the quantities change drastically, so I can't give it a definite maximum, minimum or "step" grade. Any ideas?

Hi, Madawc- What I'm after is this: I'm getting minor complaints when my reports come up with only one or two quantities, and thus the chart shows 0.2, 0.4, 0.6, 0,8, etc. when in actuality there's no chance of having 0.4 of something. I'm reporting on whole units. I tried your ToText idea...

Hi, Anyone know how to get CR XI to get rid of decimal points if the quantity of what I'm showing in my bar graph is only 1 or 2, or even tell Crystal that the max scale is always at least 3? I know how to manipulate it in VB, but I don't have that luxury in this case. Thanks!

Hi, Anyone know how to get CR XI to get rid of decimal points if the quantity of what I'm showing in my bar graph is only 1 or 2, or even tell Crystal that the max scale is always at least 3? I know how to manipulate it in VB, but I don't have that luxury in this case. Thanks!