Search results for query: *

Ken, Thanks for the link - most useful! I now know what a list is and how to create one! I have also used the data vaildation so that my users can select from the entries on book 1. I now want to ensure that they cannot enter data into the 2nd workbook cells other than choosing from my list...

Thanks but how do I name my list? And what is a list? I have tried the inbuilt help and an Excel book but can't find "What is a list and how to create one" anywhere.

I have a worksheet which records client details - each client has a unique reference number as the first column. I then have other worksheets which record (for example) client placements (date started, date ended and type). Each of these also has the unique client reference number as the first...

Thanks guys, I'll try out Madawc's suggestion and seek some advice on the SQL solution. I'll re-post if still a problem, Dave.

Naith, How would I do that? I know VB and Crystal but have no SQL knowledge or experience. Dave.

Brian, The method I have used successfully in the past is as follows: 1. The detail line for each vendor should have 3 counts (1 count per year, 1 year per column) and each of these will be a formula. Formula A (for 2001) will be something like... "if ({orders.RecDate} >= Date...

I have a report which works fine but I need to exclude "Invalid" records from the totals. Records are indicated as Invalid by the existence of a record in the "InvalidDets" table. E.g. a user marks a Referral record as invalid and a record is created on the...

CORRECTION : Remove all SQL Queries and RecordSelectionFormula coding from any .rpt report before importing it into Visual Basic!

After many hours of hair-pulling, I discovered that I had to go back to the original .rpt version of the report and remove the code from the SQL query found in Database|Show SQL Query and also the Record Selection Formula Editor found in Report|Edit Selection Formula|Record option. I then had...

I have imported my Crystal Report into the RDC in VB6 and followed the guidelines for converting from OCX to RDC. Everything is fine except for date ranges. I am applying them thus: Dim vReport as CrystalReport1 Dim a as String a = "{Table.DateField} in Date(2002,1,1) to...