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!

Register Log in
  • Congratulations Rhinorhino 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: maryjo2001
  • Content: Threads
  • Order by date
  1. maryjo2001

    ODBC failed Win2000 Acc97 Transferdatabase

    We just upgraded to a Win2000 under NT machine using access97. When we used to use a regular NT machine with access97 i used a module with the transferdatabase method to import data from an oracle table. This worked just fine till we got the upgrade to Win2000. Now it tell me that "ODBC...
  2. maryjo2001

    Subreports using Distribution Expert in 8.5

    i have created a report that uses subreports. i compiled and ran the distribution export with no problems. i installed on desired machine and upon open i encountered a print engine error "cannot open sql server". just to make sure i could hit the datasource i ran a test from...
  3. maryjo2001

    Help with Most Recent Field

    I am trying to select the most recent room number based on the maximum row identifier. Table1 contains these fields: UID,Date,Room,PatientID Data in Table1: 1,7/1/02,456B,Amy74 2,7/1/02,234C,Amy74 3,7/1/02,457D,Amy74 Data I would like to see based on query: 3,7/1/02,457D,Amy74 Code I wrote...
  4. maryjo2001

    return field name

    does anyone know how to return a field name from a table? for example table1 had field1, field2, and field3. i have created a function that returns the maximum value of the three fields. what i want it to do now is to tell me the field name of that field with the maximum value.
  5. maryjo2001

    Unable to link Unique Identifiers

    i have two tables one is a decode table and the other uses a variation of the unique identifer along with other information. however i am unable to figure out how to link them in crystal. it is easy to do in access as i can create a function to delete the irrelevant numbers. for example table...
  6. maryjo2001

    multiple distribution of reports

    i am new to crystal reports and was wondering if there was a way to create a set of distributed reports at once. i have only found it to work for one report at a time. we are converting from msaccess to crystal and have 130 reports to convert. any ideas? i read about the subreports...

Part and Inventory Search

Back
Top