Recent content by schredder

combo, that's great. thanks alot.

Thanks combo. Worked. Still takes kinda long for 400 rows, maybe there is a simple code for selecting all rows with X in one shot and hide this selection ??

Hi all I have a sheet in which in coloumn Q i have either an "X" in it or the cell is empty. I would like to code that when i execute it all the rows which have an "X" in the according cell are hidden. I coded it like this, it's working but it is very clumsy, bascially I would end up having a...

Fantastic....exactly what i needed! Thanks!

Have a table like this: UL-Ticker 3WHigh 3WLow Boll1 Boll2 ------------------------------------------------- AMGN 33.50 29.10 32.00 32.50 ADEN 61.05 58.10 62.05 60.10 at the end it should look like this: AMGN ADEN 3WHigh 33.50...

Hammer! I send a star down to Australia! Thanks Chris

I have a table with: Date balance 12/05/2003 3 12/18/2003 7 12/29/2003 6 01/06/2004 9 01/12/2004 5 01/26/2004 4 02/03/2004 7 02/21/2004 2 The query should extract the last data entry of each month with the respective balance like...

Thanks both of u guys, fantastic it works. Went for Jon's solution since the dsum function is indeed very slow with a lot of data. Chris

Roy, Paul Thanks a lot...indeed i have to use ";". Still, i have no luck with the query. So i tried: Query name: MTA_signal Fields: date, ticker, signal, close, signalorder (whereas this field "signalorder" i calculate and generate it in the same query (it's a product of...

Hi Paul yes sure: for example thread701-166033 or thread701-493981, post from scriverb The function is not accepted when i'm using commas, maybe this is because i have Access2k or i'm using a german version, think semi colons are ok since the expression is accepted. I first thought my...

Hi Mike as I said, have this from another thread where the pros suggested to use it like this. I tried every possible way of typing ...still no luck.

Hello all in another thread i learned that there is a possibility to have a running sum in a query and that it is possible to get it worked even without an ID-field. I want to have a running sum with dates as unique identifiers. It lookas like this: Query name: MTA_signal Fields: date, ticker...

Thanks Jeremy. Since i dont have any experience at all with batch files and so i think i will some time to get familiar/read into this. So if u find/know any got urls on that topic please let us know. Chris

Thanks for the hint, seaport. Since my db is about 15 megs in size i think i have to go for the solution u suggested. But, and now the but,....how do I set up such a batch program? sry, but my knowledge is limited to access and some vb. Chris

Hi all Designed a DB on my laptop. The DB compacts itself on exiting. Worked fine on my laptop, but now since the DB lies on a server (it's a frontend/backend solution) i get the message on exiting "Table 'TempMSysAccessObjects' already exists" and the DB doesn't compact. The result...