Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. schredder

    How to hide rows based on cell value in VBA (excel)

    combo, that's great. thanks alot.
  2. schredder

    How to hide rows based on cell value in VBA (excel)

    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 ??
  3. schredder

    How to hide rows based on cell value in VBA (excel)

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

    Please help on Xtab query...may be simple!

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

    Please help on Xtab query...may be simple!

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

    Last data entry of each month!

    Hammer! I send a star down to Australia! Thanks Chris
  7. schredder

    Last data entry of each month!

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

    Running sum problem in query!

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

    Running sum problem in query!

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

    Running sum problem in query!

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

    Running sum problem in query!

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

    Running sum problem in query!

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

    Compacting DB problem: DB gets huge!

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

    Compacting DB problem: DB gets huge!

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

    Compacting DB problem: DB gets huge!

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

    Linked table error in Windows XP

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

    Login question: need to check if another user is logged in DB!

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

    Login question: need to check if another user is logged in DB!

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

    Get file path displayed in textbox and save it - HELP!

    Anyone ?
  20. schredder

    Get file path displayed in textbox and save it - HELP!

    Anyone ! On a form i have a button that opens the open file dialog box and after selecting a file path I want it to store that filepath in a textbox on that form. I so far have the the button functioning and the open file dialog box opening, but getting the filepath to display in a textbox and...

Part and Inventory Search

Back
Top