Search results for query: *

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

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

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

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

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

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

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

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

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

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

@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...

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

@ 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...

@ 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...

@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...

@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 ?

@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...

@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...

@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...

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