Search results for query: *

I use the "createProcess" function (defined in the "kernel32" lib) to start a java programm from my VBA code. The java programm sometime crashes and I am looking for a function that I can use to check whether the process is still running. I have the processID and the threadID to identify the...

Sorry Mike, you are right. The way I wrote it the things are not so easy to understand. We have a table (lets call it "cashflows") with the following four fields: TID: TradeID date: date of cashflow ccy: currency amount The primary key is the combination of TID+date+ccy. This is necessary...

I did some general testing with different ways of deleting data in a table and compared the size of the database before and after the delete process. The test goes as follows: step 1: insert 500 times a set of 10 records into a table. Each record each set has the same identifier step 2: delete...

Hi Mike and Steve, thanks for your reply. Steve: No, i am not creating a new querydef each time, but i reuse a "dummy" querydef, where I change the SQL statement each time. So this is probably not the reason for the increase in size. The table that we do the deletes on holds cash flow data...

We are using Access 97 and have the following problem. We need to do a lot of single deletes on a table and do this by using a DAO.Querydef object and change the SQL code several times. We use plain SQL code, i.e. we set qryDef.SQL = "DELETE * FROM table WHERE condition" qryDef.Execute We do...

Does anyone know if there exists a way to put a string into an MQSeries queue via VBA??? Any help is greatly appreciated. Cheers Lars

Does anyone know how to add a control (like a text field) to an ACCESS form via VBA Code. I tried Forms("aForm").Controls.Append but the "append" method is not implemented for a container (like controls). Any help is appreciated. Cheers Lars