Actually, try the codestring "DoCmd.SetWarnings False", instead of using the assignment operator as listed above. At least when using MSAccess97. Took a little while for this novice to figure out the cryptic error message "Argument not optional" when I used the equals sign.
Would someone know of a way to recover/restore form(s) that were accidentally deleted from a Microsoft Access 97 database (.mdb file)? Am worried that several days worth of form development have been lost. ;-(
I suppose I neglected to mention why a space had to be returned in the case where a NULL value exists in a cross tabulated column. The reason is that when I use a NULL instead of ' ', and I do an ODBC-connect to the Oracle view through MSAccess, Access cannot, for some reason, read most of the...
Wow, that's great, thanks for responding.
But now I have another question. Using the query you so generously took the time to provide, I find that I get the error message "ORA-01467 sort key too long" if I use that max(decode) function more than seven times. I have seventeen...
Hey, Daniel - since you're experienced in using the CASE statement to imitate a crosstab query on SQL Server, you can similarly use DECODE statements to imitate a crosstab query on Oracle.
I could just leave the answer at that, but heck, I might as well explain things a little better, and...
I am trying to write a "crosstab" view on some joined tables, within an Oracle database. (I have already joined the tables in a view; now I would like to write a crosstab style view based on this view.) In MSAccess, this is ridiculously simple to do with a Crosstab query. In MSSQL...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.