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!

  • Congratulations SkipVought 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. hgraybill

    Print a 2D array to text area

    I'm working on a program and don't have any java experience, so it's been a bit stressful. Below is my code and it's supposed to record input each time you click the "enter" button and then output the array to a text area when you hit the "run report" button, but I can only get one value of the...
  2. hgraybill

    Crystal Reports Access through VB6 - Subreports

    I was able to get the subreport to load using the first code example that was given when I loaded in the two separate connection strings. Thanks for the help!
  3. hgraybill

    Crystal Reports Access through VB6 - Subreports

    I'm on vacation until December 1st, so I won't be back in the office to test it until then. I will post my findings when I find out, though!
  4. hgraybill

    Crystal Reports Access through VB6 - Subreports

    Thank you both! I will give both a try and see what I get to work. Thanks again! Heather
  5. hgraybill

    Crystal Reports Access through VB6 - Subreports

    Thank you so much! I will give it a try.
  6. hgraybill

    Crystal Reports Access through VB6 - Subreports

    Yes, I've used subreports in program code before and had them come up fine in other programs. I don't recall ever having to use a separate connection string, though. Maybe your sample would help me. I can show a sample of my code that has successfully used subreports from the same database...
  7. hgraybill

    Subreport Access in VB6

    I didn't have any success with posting this in the VB6 subforum, so somebody suggested I post it here. ---------------------------------------- I am trying to call a Crystal Report (CR10) that has a subreport (the subreport connects to a different database than the main report) through my VB6...
  8. hgraybill

    Crystal Reports Access through VB6 - Subreports

    Thanks for the response! I will try the Crystal Reports forum to see if anyone knows the answer. If not, I'll give the temp tables a try!
  9. hgraybill

    Crystal Reports Access through VB6 - Subreports

    I forgot to include my code correctly and didn't see a way to edit the post Dim Report As CRAXDRT.Report Dim SubReport As CRAXDRT.Report Dim App As CRAXDRT.Application Dim Sections As CRAXDRT.Sections Dim Section As CRAXDRT.Section Dim RepObjs As CRAXDRT.ReportObjects Dim SubReportObj As...
  10. hgraybill

    Crystal Reports Access through VB6 - Subreports

    I am trying to call a Crystal Report (CR10) that has a subreport (the subreport connects to a different database than the main report) through my VB6 program. I usually don't have a problem calling reports with my code, but I've never done a report that has a subreport that connects to a...
  11. hgraybill

    Copy Data Over Based on Another Cell

    I don't want to waste your time on this little piece anymore. You helped me a lot already with that line of code that I was missing. I'll figure out the rest! Thanks so much for the help!
  12. hgraybill

    Copy Data Over Based on Another Cell

    I meant it will go to A25 if I hit those keys again.
  13. hgraybill

    Copy Data Over Based on Another Cell

    Yes, it skips to A2 when I do that. If there isn't anything in A3, it will then go to A25.
  14. hgraybill

    Copy Data Over Based on Another Cell

    The selected area jumps down one cell, so basically moves to the next cell in the column.
  15. hgraybill

    Copy Data Over Based on Another Cell

    That almost works perfectly, except my range starts at A1 and it is pasting the value into A27. A3 is the first blank cell.
  16. hgraybill

    Copy Data Over Based on Another Cell

    I'm trying to create a macro in Excel that will copy data from a couple of cells (if another cell is equal to true) and paste the copied data into the first blank cell in another sheet. So basically (because I'm sure the above isn't very clear!), if cell K16 is equal to true, copy cells B16 and...
  17. hgraybill

    Cross Tab and Showing Past Dates

    I have a cross tab that shows the dates and qty's on Customer Orders, like below in Cross Tab 1. The problem I'm having is I want past months to show as 0, like the second example, Cross Tab 2. I tried doing this in a manual cross tab, but I don't know how to do it without making a formula for...
  18. hgraybill

    Passing Comma Separated Values in Parameter

    That works perfectly. I didn't need the quotes in Crystal. Thank you very much!
  19. hgraybill

    Passing Comma Separated Values in Parameter

    I've searched for the answer to this, but to no avail. I have a parameter on a report that is setup to accept multiple discrete values. For multiple values, the user has to enter each one and then hit the add button. Is there a way for them to copy a comma separated list into the parameter...
  20. hgraybill

    Week Count Formula

    Yes, that's exactly what I needed. Thank you for the help!

Part and Inventory Search

Back
Top