Search results for query: *

I have a niggling problem with automating a mail merge from an excel command button. Any help would be appreciated. I am running Office 2003. All the steps in the follwoing code work except Word propmts me to select the sheet in the workbook to merge from. I would like the process to be...

Thanks for these replies. CauitionMP: The form is not bound at all and is simply a 'criteria' select form. The stored query run is a query linking 3 tables. I have successfully used AlexCuse pointer to buils the SQL string required but am now havinbg diificulty passing this string into the...

I am currently exporting into Excel using the 'OutputTo' method and a stored query. I have a form with two combos on to filter the rows exported. This works fine. However I want to take it to the next stage and add some check boxes to the form which would (when checked) remove some of the fields...

I know, I know this isn't 'grammatically' correct but this is only a simple single user database to input questionnaire responses and perform simple analysis, so this technique fits the purpose for this database. Thanks anyway PHV!

The list box has two columns (number and description) and stores the values in the field text 'HowMany' like 1,2,3 etc....

I have the following code in the AdfterUpdate event of a simple multi select listbox. The code puts the selected items in order (separated by commas) and works fine. However when I scroll through other records, the listbox doesn't update to show the current selection in the new record. Here is...

There are hundreds of diffrent spec's and each record (index) has a start and end date (amongst other things). The cross-tab in essence will have end date by month as the column headings and spec as the row headings (groups) with a count of distinct consultant episodes (codes). Hope this makes...

Using Crystal 8.5 I'm having problems with the following situation: Code(string) Index(#) Spec(string) IC000009 1 501 IC000009 2 501 IC000009 3 502 IC000009 4 502 IC000009 5 501 IC000010 1...

I need to convert the following string of SQL to a crystal report formula, and (t1.f1) = (select max (t1.f1) from (t1) where (t1.f2) = t2.f1)) {where t = table and f = field} any help would be greatly appreciated

I am using this method. Thanks Jwood

When trying to convert the joins from equal to left outer (or any other) I recieve the message: ODBC error : [Informix][Odbc Informix Driver]General error. Syntax Error Then Error detected by database DLL. I am using Crystal Reports 8.5 and with an ODBC database. I'm unsure what other...