Search results for query: *

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

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

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

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

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

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

I need to create a formula that will count the week numbers from the current date, but I'm stumped. I've tried the datepart() formula, but haven't come up with anything. Here's an example of what I'm after. If I was to run the report today, I would need each week numbered. For example this...

Crystal Reports version 10 Accessing a SQL 2000 database I have a report with a parameter called {?SMART_CODE} that prompts the user to enter a code. In the field where the code is stored there could be more than one code, for example AA,BB,CC or there could be a single code, AA. I want the...

I want to password protect my delete command, so only users that know the correct password can delete the record. I'm really not sure how to go about this, because I'm still a beginner, but my code for the delete command is below. Any help is appreciated! Thanks, Heather...

There's a program I'm trying to modify (VB 6) that contains a section of code that looks for an Excel file (according to a file name snippet in another program). At this point it will only go out and look for one file and add that total to a report, but I would like it to go out and look for...

I have a report that calculates inventory that was on hand at a certain time. To do this, when selecting a date range the user has to select no lower bound (i.e. "No Lower Bound" to March 1, 2007). I was looking for a formula to suppress a section in the report by the upper bound that is...