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 bkrike 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: trialerror
  • Content: Threads
  • Order by date
  1. trialerror

    Connecting to Oracle via Access- width of a Unicode text column

    I have an application with Access 2000 as the front-end connecting via ODBC to Oracle tables. I can look at most tables except some which give the following message when I try to view them: "The width of a Unicode text column must be an even number of bytes". Also the queries run on these tables...
  2. trialerror

    using substr in Access query does not work

    I have a query in Access 2002, which is using the substr function, as in ---substr(owner,1,9) but Access is throwing an error and saying "undefined 'substr' function in expresion." Any suggestions? Thanks
  3. trialerror

    linked tables to Oracle-error handling

    My application has an access 2003 front-end and Oracle 9i backend( tables are linked). When I connect I get the standard connect box to enter in Oracle SID,username , pwd. This works fine when I connect as "system", but when I connect as any other user like Scott, I get a bunch of errors. I...
  4. trialerror

    Error handling-connecting as dba or other user

    My application has an access 2003 front-end and Oracle 9i backend( tables are linked). When I connect I get the DNS connect box to enter in Oracle SID,username , pwd. This works fine when I connect as "system", but when I connect as any other user like Scott, I get a bunch of errors. I would...
  5. trialerror

    If no data found-return message in form

    I have 2 combo boxes on my form. Based on what I select in the first one, the second one is populated using an underlying query. But what if there is nothing matching the selection in the first-I would like to have a message displaying like "No data found" etc. Thanks for all your help.
  6. trialerror

    sorting a string

    Is it possible to sort a string field on the middle 2 digits? If a string has 6 digits , can it be sorted on the basis of the middle 2 digits?
  7. trialerror

    linking a combo box with a subform

    Hi, I have a main form with 2 combo boxes.The values in the combobox1 come from a query .Also the values in combo box 2 are limited by the selection made in combo box 1-(already finished this part).Next, I want to display in a subform (or some other way) all the other details of a table ...

Part and Inventory Search

Back
Top