Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. crimsntyd

    Konica Printer Bug in Visual Basic Crystal Report Add-in

    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...
  2. crimsntyd

    Graph label format

    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...
  3. crimsntyd

    Run-time Error 3265 - XP vs Win2000?

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

    Run-time Error 3265 - XP vs Win2000?

    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...
  5. crimsntyd

    Run-time Error 3265 - XP vs Win2000?

    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...
  6. crimsntyd

    Run-time Error 3265 - XP vs Win2000?

    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...
  7. crimsntyd

    CreateQueryDef, OpenRecordSet Only returns 1 Record

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

    CreateQueryDef, OpenRecordSet Only returns 1 Record

    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...
  9. crimsntyd

    CreateQueryDef, OpenRecordSet Only returns 1 Record

    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.
  10. crimsntyd

    CreateQueryDef, OpenRecordSet Only returns 1 Record

    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 =...
  11. crimsntyd

    (Automatic) Scales in CR XI

    Sorry. Any way around this?
  12. crimsntyd

    (Automatic) Scales in CR XI

    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?
  13. crimsntyd

    (Automatic) Scales in CR XI

    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...
  14. crimsntyd

    (Automatic) Scales in CR XI

    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!
  15. crimsntyd

    (Automatic) Scales in Crystal Reports

    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!
  16. crimsntyd

    Crystal Report ActiveX Viewer Error

    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...
  17. crimsntyd

    Static Chart Color

    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...
  18. crimsntyd

    PDF Merge Problems

    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...
  19. crimsntyd

    Displaying Parameter Values in a Message Box or String

    Thanks! I'll figure out the range stuff.
  20. crimsntyd

    Displaying Parameter Values in a Message Box or String

    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...

Part and Inventory Search

Back
Top