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 derfloh 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: *

  • Users: OracleScorpion
  • Order by date
  1. OracleScorpion

    Problem with size of form

    Okay folks, I've got what I need and it looks good ^-^. Thank you!
  2. OracleScorpion

    A report with graphs

    I already know that I will have to use a query, but am still completely in the blue. I showed the tables which I have and the user gets a screen in which to choose the LoadingPort, DestinationPort and Agent. Agent is not necessary to choose. Out of these choices (and after pushing a button), the...
  3. OracleScorpion

    Problem with size of form

    Thank you both, I'm going to try both ways and see which one the users prefer. Thanks!
  4. OracleScorpion

    Problem with size of form

    I have one form with only text on it to show when the user clicks a button. Now the form is very long (longer than te screen) and I already tried everything but it won't work. I'm trying to show only a small screen with a scrollbar so the user can just scroll down to read on. I put all the right...
  5. OracleScorpion

    A report with graphs

    Hi, I have one main table which pulls information from other tables. In the main table is information and links via autonumbering to the other tables in order to fill in the gaps. Now the problem is on how to pull the necessary information and make a graph of it. The tables will be put down...
  6. OracleScorpion

    Numeric field problem

    *sighs* thank you once more! It's a saturday evening and I'm working on a project for work, my apologies that my brain is slightly in weekend-mode *blushes* Thank you ^-^
  7. OracleScorpion

    Numeric field problem

    Ack... now you say so. Normally at work I use the english version. But here at home I have the dutch version and I am not used to the names in it. Thanks a bunch! Just one more question. I need to get a comma as limiter for decimals, any idea how to?
  8. OracleScorpion

    Numeric field problem

    In my database, I've got a numeric field which has to store up to 7 numbers of which 2 are decimals. Now I tried everything in the notation and number of decimals etc but whatever I do, it keeps going wrong. If I fill in 59,31 (the 31 is the decimals) I get as a result either 5931 of 59. Can...
  9. OracleScorpion

    Excel rounding problem ~ help needed urgently

    Okay... I looked up for the SUMPRODUCT and it gave the right result. I don't fully understand it, as when I tried it before and did exactly the same things, it gave an error as well. So I don't know what or how, but now it seems to work. Lets cross fingers that it will work on every one of the...
  10. OracleScorpion

    Excel rounding problem ~ help needed urgently

    =D3:D9
  11. OracleScorpion

    Excel rounding problem ~ help needed urgently

    Well I am just trying it on different sheets, that's why at the moment it doesn't matter what cells I'm trying. Oh and they are on the same sheet. But what do you mean with key combination?
  12. OracleScorpion

    Excel rounding problem ~ help needed urgently

    =SUM(ROUND(A1:A10,2)) But then of course with the range that I need. I keeps flipping back to the range, as if it can't accept a range there...
  13. OracleScorpion

    Excel rounding problem ~ help needed urgently

    Eh... the error is literally "the formula contains an error". I can't be more specific because that is all Excel is tell me...
  14. OracleScorpion

    Excel rounding problem ~ help needed urgently

    Ken : I tried them, but kept getting errors :(
  15. OracleScorpion

    Excel rounding problem ~ help needed urgently

    No, we have to show the numbers as rounded. Difficult to explain, has to do with the weights and whatever. You know, money ;) I'll try the Precision right away, but won't this affect the other numbers as well then?
  16. OracleScorpion

    Excel rounding problem ~ help needed urgently

    ...seem like an idiotic little thing, but when we send this to the banks, they start making problems about those 2 cents... N1 N2 (N1/1000)*N2 127.350,00 480,00 61.128,00 188.480,00 480,00 90.470,40 64.395,00 417,00 26.852,72 65.090,00 417,00 27.142,53 451.115,00 63,00 28.420,25 SUM...
  17. OracleScorpion

    Excel rounding problem ~ help needed urgently

    Hi, When in Excel, you have a bunch of number with for example 5 digits after the comma. The numbers only show two numbers after the comma though and when a SUM has to be made, also the rounded up value has to be used and not the exact number. Please don't say that we then have to type in just...
  18. OracleScorpion

    Fast button to change azerty in querty?

    Never mind, a friend told me :)
  19. OracleScorpion

    Letting children use only certain sites?

    I can't remember the name, sorry :( I found it via Tucows.
  20. OracleScorpion

    Fast button to change azerty in querty?

    I know there is a combination to push and then you change the keyboard from azerty to querty and back. But which one was it??

Part and Inventory Search

Back
Top