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 Wanet Telecoms Ltd 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: *

  • Users: jwoodland
  • Content: Threads
  • Order by date
  1. jwoodland

    Mail merge from excel vba - select sheet problem

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

    Export to Excel using a dynamic query

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

    multi select list box problem

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

    Problems with a tricky cross-tab!

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

    Need to convert some SQL into a Crystal formula

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

    Changing between EQUAL and LEFT OUTER JOINS in ODBC

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

Part and Inventory Search

Back
Top