Search results for query: *

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

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

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

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

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

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.

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?

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.

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

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

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

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

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

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

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

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

That worked, thanks!

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

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.

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