Search results for query: *

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!

Hi, I've distributed a simple VB 6.0 report viewer to some of my colleagues here at work, and two of them get error messages when they try to open Crystal Reports that are pointing to an Oracle 9i database. The errors are, in order: First window: Prompting failed with the following error...

Hi, I'm trying to setup a report in a VB application that uses the RDC. (I'm using CR XI) There is a chart that has two characteristics (on change of): Failure Location and Cause Code. I need the "Recycle" Failure Location to always be tan, and the "In Service" Failure Location to always be...

Hi, I'm having difficulty merging pdf's that I export from CR XI. I'm using Adobe Acrobat 5.0. When I open one of the files I've exported, then try to insert another file (both have been exported from CR XI), I get the error message "these documents contain subset fonts that have the same name...

Thanks! I'll figure out the range stuff.

Hi, I have a viewer in VB that works really well, and even gives the user a message when there are no records for the parameters they've entered (I'm using Crystal to handling parameter input, not passing them through VB). What I'd like to do is show the parameters they selected in the message...