Search results for query: *

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

...signal, close, signalorder (whereas this field &quot;signalorder&quot; i calculate and generate it in the same query (it's a product of signal*close). Rusum:DSum(&quot;[SignalOrder]&quot;;&quot;MTA_signal&quot;;&quot;[date] <= #&quot; & [date] & &quot;#&quot;) When i run the query, the...

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.

...signal, close, signalorder (whereas this field &quot;signalorder&quot; i calculate and generate it in the same query (it's a product of signal*close). Now my runningsum-field looks like this: Rusum: DSum(&quot;[SignalOrder]&quot;;&quot;MTA_signal&quot;;&quot; [Datum] <= #&quot; & [Datum] &...

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 &quot;Table 'TempMSysAccessObjects' already exists&quot; and the DB doesn't compact. The result...

Hello I designed a database which is split into a frontend (which every user has stored locally on his c drive) and a backend (which is stored on a shared drive/server). I originally programmed it under Windows 2000 professional and everything worked fine. A few days ago every user upgraded to...

hey mp9 thnx lot for ur feedback. think i'll give it a try. chris

Hi all Have set up a simple login procedure for my database. Created a table where username and password is stored. When a user logs in the database my code checks if the entered password matches the one in the table. That's it. For updating reasons i only want to have one user logged in at...

Anyone ?

...If Len(strFileName) = 0 Then strFileName = String(255, 0) End If If Len(strFilter) = 0 Then strFilter = &quot;Image Files (*.*)&quot; & Chr(0) & _ &quot;*.*&quot; & Chr(0) End If OpenFile.lStructSize = Len(OpenFile)...