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 derfloh 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: *

  1. maryjo2001

    ODBC failed Win2000 Acc97 Transferdatabase

    we did reinstall oracle on the machine but not sure what "client install" means? maybe we missed something.
  2. maryjo2001

    ODBC failed Win2000 Acc97 Transferdatabase

    yes it is setup in admin. i also checked in the tsnames.ora file and it appears to be fine as well. in the mean time i have reverted back to my old machine till we can figure out this issue. thanks for the reply i do appreciate it.
  3. 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...
  4. maryjo2001

    Subreports using Distribution Expert in 8.5

    i figured out what was going on. the dsn name was different on my machine than the one on the client's machine. after correcting that it worked fine.
  5. 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...
  6. 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...
  7. 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.
  8. maryjo2001

    Unable to link Unique Identifiers

    I can do this however then i will need to create a user group to access the area on the lan where the query will be stored. i did not want to have maintain that if it can all be done in crystal. do you know how to do that?
  9. 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...
  10. maryjo2001

    multiple distribution of reports

    i figured out how to distribute many reports at once. click the add button. duh, on my part. now i am looking to figure out how to add reports to that distribution list. lets say that i have those 130 on the LAN and want to add one more to that group of distributed reports. do i have to...
  11. 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