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

    Delete confirmation

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

    Restoring deleted forms

    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. ;-(
  3. drbilbrey

    Crosstab view in Oracle possible?

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

    Crosstab view in Oracle possible?

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

    Crosstab view in Oracle possible?

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

    Crosstab view in Oracle possible?

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

Part and Inventory Search

Back
Top