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...
debug.print IsNumeric("KR00")
True
debug.print 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...
Hello
I'm aware of the access issue with filtering e.g. dropdown boxes' display string values with wildcards (while storing another column with e.g. digits), where access will go into read only when you do it.
I have another issue though, where a string-field in the database is in a normal...
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...
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...
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.
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.