Search results for query: *

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

Thanks-could not find it anywhere!It worked.

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

Also, when I get the login box-the Oracle ODBC driver connect, and I hit Cancel, the box comes up back again. This happens every time I hit Cancel and I have to eventually close the application, if I wish to quit. Any suggestions would be helpful.

The application links to "dba tables" and thats why the dba or system user can connect fine. But if some other user attempts to connect, I simply want to have a MsgBox saying "login denied" etc. after the user puts in username/pwd in the Oracle ODBC Driver Connect box.Thanks

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

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

Thanks-will give it a try.

Great-this works but does not "refesh " itself, if I go back in the form and it already has the selections in the first combo box, it does not display the message again unless I click the first combo box again. Thanks

What do I do with it- which event do I link it with ? Thanks

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.

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?

Option 1 works but how do I requery the subform?

The main form does not have its recordsource.I created a blank form and placed the combo boxes on it which of course have their own record sources.

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