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

    Tables relinking and ODBC

    And for more background, plauriz is using: Office Access 2003 versus an Oracle 10gR2 database. All the tables relinked are in Oracle.
  2. snerting

    Fill cache table fast

    Hi, I didn't know this was possible in Access, but it turned out the syntax is just significantly different from Oracle. I just did a "SELECT * INTO blah FROM (....)", and it's almost exactly 100 times faster. Problem solved, thanks for pointing me in the right direction, I should have looked...
  3. snerting

    Fill cache table fast

    Hello Problem: * A big table in Oracle being queried with one predictable where-clause and then additional clauses depending on the feature turned out too slow to do through ODBC runtime. Working in the forms ended up unusable. The same queries run instantaneous on the Oracle shell, so it's not...
  4. snerting

    Auto spelling with underline

    The reason for my perhaps "sharp" response was that you missed the question by a mile. I wasn't talking about the physical storage at all, just the forms you create on top of it. These form controls already support all the other autocorrect stuff out there, like double upper-case letters in the...
  5. snerting

    Auto spelling with underline

    ???? I'm fully aware of what a database is, and remember that MS Access is not simply a datbase, it's a tool to make front-ends to the database. You will in lots of cases write text into databases that is supposed to be valid words - for example if you're putting simple articles into a...
  6. snerting

    Auto spelling with underline

    Hehe, sorry, I meant of course Word, or MS Office really. I hoped that common office features were not application-specific like you suggest but I might be wrong. If they could underline spelling errors in winword they should also be able to in access text controls.
  7. snerting

    Auto spelling with underline

    Hello I see that Access has spelling checking, but I cant find a way to make it underline spelling errors with red and gramatically wrong sentences with green etc, like windows does. Is it possible to enable this for text controls?
  8. snerting

    Access text encoding

    Hello Is it possible to make access use regular latin1? The text is stored in an oracle database and used by non-windows systems, so it becomes a problem when people are using ellipsis, weird windows-versions of ' etc.
  9. snerting

    IsNumeric() returns crap

    Of course I can use regexp. I can use a lot of things to solve this pretty simple problem. That's not the point. I wouldn't say that the function text: "IsNumeric returns True if the entire expression is recognized as a number; otherwise, it returns False." ..in any way states that what will...
  10. snerting

    IsNumeric() returns crap

    It seems like the "KR" ones are valid numbers as I'm from Norway (as I guessed in my initial post: currency). If I change my regional settings to United States it will state "False". But then it will claim that IsNumeric("1000$") is a valid number - which is False when I change back to...
  11. snerting

    IsNumeric() returns crap

    ...IsNumeric("KR75") True debug.print IsNumeric("9D44") True What!? Is it taking like hexadecimal numbers and currency into consideration or what the **** is it doing? :) I just want to see if a string contains anything else than 0...9 Guess I have to write a little algorithm myself or use regex.
  12. snerting

    Access goes into readonly on string-filtering a string-field!

    ...though, where a string-field in the database is in a normal databound text control in my form. Everyone can filter this freely with wildcards like "*john*" and still edit the form. One user, though, with the exact same version of access as the rest of us (he even has office SP2 like me), has...
  13. snerting

    How to requery after update/insert/delete

    Well, strangest thing. The error message actually went away. Possibly because I removed most of the timres. Don't know. Can't recall the exact sound in the error message when calling Me.Requery in AfterUpdate, but it suggested that the operation was not permitted. My new problem now is that the...
  14. snerting

    How to requery after update/insert/delete

    Hello Due to the structure of the database and how our meta-data versioning of the data works, I have to do a requery on each form after update. I'm not allowed to call Me.Reqery in the "AfterUpdate" event, so I didn't see any other way of doing it than put the requery in a timer (if...
  15. snerting

    break point on errors

    Thanks, I changed from "Break on unhandled errors" to "Break on all errors" And it seems to work like a charm :). Thanks TheAceMan1 !
  16. snerting

    break point on errors

    Hi I have certain access 2003 VBA applications where code errors tend to break at a much prior point in the "call stack" than the actual error. With long while loops etc, it is really painful to debug as stepping to the place where the actual code breaks takes lots of time. Not to mention cases...
  17. snerting

    MS Access SQL - Bit-wise and

    That worked, thanks!
  18. snerting

    MS Access SQL - Bit-wise and

    I have a bitfield in a database represented through a Long integer. I want to run sql to check if certain bits are set. Example: A field in the db is (64+32=96). I want to see if bit 5 is set. Using regular VB6: Debug.Print (96 AND 32) 32 However, using "WHERE 0 > (myBitField AND 32)" won't...
  19. snerting

    Problems reading from registry

    chiph: I tried RegCloseKey but it didn't fix the problem. The application is actually polling this registry setting frequently (through a timer *yack*), but it actually seems like the problem surfaces when there is a substantial time since last time the application was run.
  20. snerting

    Problems reading from registry

    Nop, I'll try that and see how it turns out. After all, this problem is only surfacing once and a while.

Part and Inventory Search

Back
Top