Search results

Thank you arnelgp. I keep having an error with the new function. (this time it's a compile error) I've attached my test-database. There is 1 query (Query1) where I want to add this line: field1: SplitFile(1,[fld1],",") But it fires an error. I can't see what's the culprit, can you?

Hi, I have a field in a table from which I want to split the value in multiple strings. Delimiter is ">". Example input: "[string1] > [string2] > [string3] > [string4]" wanted output: variable1 has value [string1], variable2 has value [string2], etc... In this forum, I found this...

Thanks for the hint I tried this function, and indeed, it show the number of hours correctly, for example 37. (format hh) But to return on my initial question, how can I have the format look like hh:mm:ss, for example 37:34:36 ? I tried to reconstruct this using datediff and timeserial as...

Hi, a simple problem, but I didn't find the answer via google. I have two dates and want to make the difference: begin = Now() 'some other code end = Now() diff = end - begin The result is saved in a table in the following format: hh:mm:ss for example: 00:01:03 So far so good...

My problem is solved. I save the results now into a table of another mdb-file. (with linked tables). This file can be compacted when necessary, while the application keeps clean and runs continuously. Thank you datAdrenaline and Dcrake for your input.

Thank you datAdrenaline. You gave me good inspiration. I do not modify the design of any object with my code. I was already using linked tables to refer to the individual data (back-end). But to save the results of the data-manipulation, I use tables in the front-end. Maybe, there's my...

Thank you Rabbie. What I actually need is that my Access program can continue to run after compacting. The mdb-file has to re-open automatically after compacting. (just like it happens when you choose compact and repair from the menu Tools -> Database utilities -> compact and repair ) I...

Hi, I have a VBA-program in Access. Purpose of this program is to calculate statistics from individual data stored in Access tables. Because of the large amount of data and data-manipulations, I need to compact the database very frequently. I would like to automate this. My program works...