Search results for query: *

Crystal XI Server is $7500 for a 5-user license. I can't see the benefit of upgrading just for the sake of adding Email capability AND I'm sure there must be some way to do it, if everything is setup properly.

Hi, I was brought in to write some ASP code to collect data for a customer. They use CR 8.5 to generate reports, which I 'think' I can use to generate reports. They want to be able to email directly from the Crystal Reports Viewer. They use Groupwise as their email client. Can this be done? Thanks!

Close. With 12:00:00, it displays "12:00" - but with "2:00:00", you guessed it, "2:00:" Thanks, Mike

How can you change the time format from HH:MM:SS to HH:MM?

Thanks xwb, Can you enlighten me? Do you need a snippet of code? When I make changes, the webbot seems to overright everything. Thanks, Mike

Hi, I'm using FP 2000 with MS Access. I used the FP wizard to generate an .ASP page from the Access database and it works great, except the time is formated in HH:MM:SS xM format. Can I change this? Everytime I try to do something and change it, then save it, I get a message that it will...

I don't remember how I setup the combo box but I don't have a problem finding the record I want, I just have a problem, once I find the record, to update the other fields on the form automatically... e.g. JobNumber JobName Contractor [ ] [ ] [ ]...

That was it, and not having quotes around BillDate. Thanks!!!

Hi, I've got a form with a JobNumber (unbound combo box), JobName (text box), and Contractor (unbound combo box). The user either selects the JobNumber, if they know it, and clicks a cmdButton that opens a report OR selects the contractor, which opens a drop-down list of...

No, I can't get it to work. The form name is 'frmWorkSchedule' - The field is a text box called 'BillDate' I've tried: a) Me.Controls("BillDate").DefaultValue=""""&Me.Controls("BillDate").Value&"""" It seems it doesn't like the .DefaultValue because it doesn't come up for me automatically as...

I go to the Events tab for that field and create this small sub (plus error trapping) so, if my variable is WorkDate, it is: Private Sub Form_AfterUpdate() Me.Controls("WorkDate").DefaultValue = """" & Me.Controls("WorkDate").Value & """" End Sub This will set the DefaultValue...

Hi all, I'm trying to set as the default date for the second record on in a form to be equal to whatever date was entered in the previous record. I have someone who enters a week's worth of work schedules at a time and has to re-enter the date everytime and using Date() as the default date...

My lack of accounting background has failed me again. It does make sense that if we are trying to compare the date on the packing list with the date promised, we need to wait until we have an invoice. I haven't been able to generate the report yet, but it does make sense to tie the ARN to the...

I'm trying to tie/link the SO1/SO2 tables to something that has a valid Invoice Date. We're trying to compare whether vendors are matching their promised dates with the packing list date. In our case, it's the ship date v. invoice date. Any thoughts on a reliable link between two tables? Thanks...

Wayne, Thanks for the info. I don't think I'll have any problem designing my report in Crystal, but how do I prompt the user for the Start Date/End Date/etc. like it does in the canned report? Thanks again, Mike

Hi, I'm a newbie to this forum and my solution may be simple, but after 'playing' with the Report Master without documentation, I'm a little confused. I'm trying to track a vendor's ability to match their expected delivery date for materials with the actual date we receive it. The Expected...

The field with the duplicates is PONum. If PONum is a duplicate, I want a sum of all the AccAmt and StdCost values stored. Once I have the sum, I want to delete the duplicate PONums and store the sums in the PONum record I'm keeping. SELECT [COMBINED].PONum, [COMBINED].StdCost, [Vendor...

I have a query that has some duplicate records in it (duplicate PO numbers). I have some invoices that have two or more checks cut against these duplicate POs. What I want to do is to total the amount of the invoices against the PO, sum them together and place the total in a field (new or old...