Search results for query: *

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

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.

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

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

I'm using a registry setting to control how the access app should read data. The registry setting is controlled by another application. However, at some random intervals, the data read from registry is bugus. It seems to be a collection of spaces and line breaks, while the string in registry...

This is probably not an Access-specific problem, but it's VB6 implementation of advapi32.dll so here it goes: I'm using a registry setting to control how the access app should read data. The registry setting is controlled by another application. However, at some random intervals, the data read...

Hi! I made a tool in Access (linking tables from Oracle), and some queries use the lcase() (lowercase) function, which works fine when I run it, but it throws an error for other users. They have the same version of office as I do, both with SP2 installed. The error: Run-time error '3075'...

Hi! I have two applications, one is an access vb application, the other is a COM object (originally a Python-application). Case is I want to integrate the COM object into the Access application. Have successfully registered the Python application as a COM object and can successfully start and...

Hi! I have an Access application on top of an Oracle database. There are lots of constraints in this database, both normal relational/unique constraints and also some custom trigger constraints. I mainly insert/update the data in two different ways a) myform.Refresh - for the databound...

Hi I'm experiencing in some access VBA applications that if the code breaks, the break point set when I hit 'debug' is set a lot earlier in the call-stack than the line that actually broke. This makes it a pain to debug as I will have to step manually until the code breaks again. This is very...

SELECT a.[_ds_dataset] FROM table1 a WHERE a.instance=595 AND [_ds_dataset] = ( SELECT MAX(b.[_ds_dataset]) FROM table1 b WHERE b.[instance] = a.[instance] AND b.[_ds_dataset] IN (2,1) ) This SQL returns the following (query-view): _ds_dataset 1 SELECT...

Hi! Suddenly .Addnew is hanging for about 15-20 seconds on my ADO-recordset. It is working fine most places, but this one place is lagging. It does finish in the end, but with this latency it's pretty much useless. Now, .Addnew isn't even supposed to talk to the database, is it? Anyway, it's...

I have a wierd case going on right now. I'm sorting it under X-files.. I have a form which references several modules in a MDA. Now, at one of the functions in this MDA, the code breaks when trying to exit from that function ("Form Exit"), stating "Runtime error '49'. Bad DLL calling...

Hi! Deleting rows in my app is not supposed to actually delete a row in the table, but rather set a field to "1" thus describing the row as deleted. To make this work, and at the same time granting people the possibility to hit "delete" on rows, I have implemented the Form_Delete event and set...