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

  1. astrogirl77

    Weird Math Error in VBA for Excel

    Got it! Thank you! Will read the docs, thank you also for the link <3
  2. astrogirl77

    Weird Math Error in VBA for Excel

    Mikrom, thanks so much! <3 what exactly does the second line in your code above do?
  3. astrogirl77

    Weird Math Error in VBA for Excel

    Strongm, what would you recommend to get the best possible accuracy?
  4. astrogirl77

    Weird Math Error in VBA for Excel

    Hi Strongm, your code example works great as you described, what I found though after testing the routine against a high math precision python script was that they did not return the same values, found out the reason for this was that excel truncates at 15 digits whereas Python lets me set the...
  5. astrogirl77

    Parsing Large Numbers Question

    Parsing Large Numbers Question Hi All, I am writing some simple code to raise a base value to a power then perform some operations on the output. I have included the code I am using now, below ( see end of this message ), also see immediately below what this looks like when I run my script...
  6. astrogirl77

    Weird Math Error in VBA for Excel

    Thanks to everyone above who gave me a hand! The code you shared with me - I got to work, but as was pointed out accuracy gets lost due to poor float handling. I tried a number of different approaches with numeric precision addin style tools but nothing worked well. Have a great day and...
  7. astrogirl77

    Weird Math Error in VBA for Excel

    Hi Strongmn! :) I tried the code you suggested and worked on this for quite a while but it wouldnt run for me it kept failing at the line ; SQRD = vbMod(SQRD / decx, ModVal) It kept saying "sub or function not defined" and highlighted "vbMod
  8. astrogirl77

    Weird Math Error in VBA for Excel

    Hi, I have been testing this code string and it was working great, until ... :( I tried to enter either a rational number for either the power to raise to, or for decx(divisor), so when I use (X)^2 and any integer for decx, no problem but if I try (X)^1.9999 and or decx = 1.0101, it returns...
  9. astrogirl77

    Weird Math Error in VBA for Excel

    Thank you so much! this totally solved the problem, I understand now what was wrong! You guys rock!!! Such a day maker! :) <3
  10. astrogirl77

    Weird Math Error in VBA for Excel

    Weird Math Error in VBA for Excel Hi all, would love feedback on unusual error I'm getting. Very strange. I have a simple formula that works great if I only use it in a normal sheet cell and copy it down by columns, but if I try to do a simple iteration in vba code to perform the same...
  11. astrogirl77

    SQL SELECT PROB IN VB 5

    @gmmastros, Could you tell me, if I wanted to use a dbf file that was not all string fields, but instead field 1 was a string type, but the two other fields were numeric, float, etc.... how would I have to modify the code? Ive been tinkering with this also but ran into a few things that for a...
  12. astrogirl77

    SQL SELECT PROB IN VB 5

    @ gmmastros - FINALLY! THAT DID IT!!!! THANK YOU SO MUCH, ITS WORKING NOW!!!!
  13. astrogirl77

    SQL SELECT PROB IN VB 5

    @ ALL I am still not understanding why on the same computer, in the same environment, with essentially the same code, I CAN access and query the ninegrid dbf file (see attached above) just fine, but when I try to access the degreez dbf file I never can, its the SAME code basically, and I have...
  14. astrogirl77

    SQL SELECT PROB IN VB 5

    @ dilettante, I tried to insert the code you sent into the GEneral declarations section, wasnt sure where else if should go... except the form load code, I put in in the form .... I got a bunch of errors back ; ................ Compile Errors ; Ambiguous Name detected; form_resize form_unload...
  15. astrogirl77

    SQL SELECT PROB IN VB 5

    @dilettante, Im a newbie somewhat to VB programming but Im not lazy and am willing to put in effort to tinker and research, however I do not think I have the experience to easily identify which parts of your code I should chop out, would you feel comfortable if I asked you to edit out the parts...
  16. astrogirl77

    SQL SELECT PROB IN VB 5

    @Dilettante I do not have VB6 :( Only VB 5 and am not able to upgrade at this time, the code you provided above, was it in a module or in the form declarations section? Can I use this code in VB5 ?
  17. astrogirl77

    SQL SELECT PROB IN VB 5

    @gmmastros Thanks for your reply! :) Both your and dilettante ideas make sense of course, I seem to be missing some of the code from dilettante so the solution dilettante provided I cant get to work, I also tried your recommendation but I got two forms of errors. When I change the code...
  18. astrogirl77

    SQL SELECT PROB IN VB 5

    @dilettante Thank you very much for your reply! I tried to adapt your code to see if it would work but got the following error message ; Run Time error "424" Object Required The debug locked on this line ; With Cn.Execute(SQL, , adCmdText) Below is the code I adapted from what you...
  19. astrogirl77

    SQL SELECT PROB IN VB 5

    @strongm Found MSQuery where you said to look for it, then tried using it on the dbf files that work and dont work in code, and it would let me access any of them, kept getting error messages like ; "this data source contains no visible tables" "Couldnt read this file" But it did this not...
  20. astrogirl77

    SQL SELECT PROB IN VB 5

    To all - Ive been searching the net for any info on error 3011 with VB 5 and similiar and none of the very small number of articles online cover whats happening to me. My path isnt wrong, my filename isnt spelled incorrectly. Jet must be installed properly because I can open the other dbf file...

Part and Inventory Search

Back
Top