The largest integer A97 can deal with is 2,147,483,647,
as I understand it from HELP. I would be content to represent
larger integers as strings. For example, "2147483648 " would
suit me fine. I would be interested in converting larger HEX
numbers to decimal integer equivalents. For example, a 16-digit
HEX number is quite a large decimal value and I would be
happy to represent it as a string, as it would suit my purposes
fine. Since the math, however, is not going to be calculated
by Access, it seems an intimidating task to code it. Was wondering,
perhaps, if someone might have already done so. 28 4819
I believe Access97 had a variant decimal type.
And I believe such a type could handle up to 12 hex characters, even
doing math with same as follows:
Sub test()
Dim VariantDecimal As Variant
VariantDecimal = CDec("&hfffffff fffff")
Debug.Print VariantDecimal
Debug.Print VariantDecimal / 5
Debug.Print Sqr(VariantDeci mal)
End Sub
I also believe that somewhere, somehow, sometime, variant decimals were
changed, allowing larger numbers. And I believe that the VBA variant
decimal type is not identical with JET's decimal data type which
permits maximium values of only 10^28 - 1.
Well that is great news!
281474976710655 Variant Decimal
56294995342131 Above Amount Div by 5
16777216 Square Root of the First Number
Now, if I can come up with an ingenious way to break
down Variant Decimal values larger than &hFFFFFFFF,
I'll be home free. I'll bet someone clever has already
figured out and posted a way to convert numbers up
to 281474976710655 to HEX strings.
On 1 Dec 2005 16:30:06 -0800, "Lyle Fairfield" <ly***********@ aim.com>
wrote: I believe Access97 had a variant decimal type. And I believe such a type could handle up to 12 hex characters, even doing math with same as follows: Sub test() Dim VariantDecimal As Variant VariantDecimal = CDec("&hfffffff fffff") Debug.Print VariantDecimal Debug.Print VariantDecimal / 5 Debug.Print Sqr(VariantDeci mal) End Sub
I also believe that somewhere, somehow, sometime, variant decimals were changed, allowing larger numbers. And I believe that the VBA variant decimal type is not identical with JET's decimal data type which permits maximium values of only 10^28 - 1.
MLH wrote: Now, if I can come up with an ingenious way to break down Variant Decimal values larger than &hFFFFFFFF, I'll be home free. I'll bet someone clever has already figured out and posted a way to convert numbers up to 281474976710655 to HEX strings.
Great, I'm sure you'll find it. I hope you won't forget to post it here
so I can compare it with mine and perhaps pick up a pointer. http://groups.google.co.uk/group/mic...c508264bc18a96
or http://tinyurl.com/9d62n
--
Terry Kreft
"MLH" <CR**@NorthStat e.net> wrote in message
news:ur******** *************** *********@4ax.c om... The largest integer A97 can deal with is 2,147,483,647, as I understand it from HELP. I would be content to represent larger integers as strings. For example, "2147483648 " would suit me fine. I would be interested in converting larger HEX numbers to decimal integer equivalents. For example, a 16-digit HEX number is quite a large decimal value and I would be happy to represent it as a string, as it would suit my purposes fine. Since the math, however, is not going to be calculated by Access, it seems an intimidating task to code it. Was wondering, perhaps, if someone might have already done so.
Whoops, sorry just realised that's the other way round to what you want to
achieve.
--
Terry Kreft
"Terry Kreft" <te*********@mp s.co.uk> wrote in message
news:xG******** ************@ka roo.co.uk... http://groups.google.co.uk/group/mic...c508264bc18a96
or
http://tinyurl.com/9d62n -- Terry Kreft "MLH" <CR**@NorthStat e.net> wrote in message news:ur******** *************** *********@4ax.c om... The largest integer A97 can deal with is 2,147,483,647, as I understand it from HELP. I would be content to represent larger integers as strings. For example, "2147483648 " would suit me fine. I would be interested in converting larger HEX numbers to decimal integer equivalents. For example, a 16-digit HEX number is quite a large decimal value and I would be happy to represent it as a string, as it would suit my purposes fine. Since the math, however, is not going to be calculated by Access, it seems an intimidating task to code it. Was wondering, perhaps, if someone might have already done so.
I'm leaning toward dividing the subject value by the largest HEX
order of magnitude possible, MOD'ing off the remainder and working
with that as a starting point ==> concat'ing the remains of the
massacre once everything's been ripped apart 'n chewed up.
xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxx
On 1 Dec 2005 22:22:39 -0800, "Lyle Fairfield" <ly***********@ aim.com>
wrote: MLH wrote: Now, if I can come up with an ingenious way to break down Variant Decimal values larger than &hFFFFFFFF, I'll be home free. I'll bet someone clever has already figured out and posted a way to convert numbers up to 281474976710655 to HEX strings.
Great, I'm sure you'll find it. I hope you won't forget to post it here so I can compare it with mine and perhaps pick up a pointer.
Great! show us an example, please.
MLH <CR**@NorthStat e.net> wrote in
news:qv******** *************** *********@4ax.c om: On 1 Dec 2005 16:30:06 -0800, "Lyle Fairfield" <ly***********@ aim.com> wrote:
I believe Access97 had a variant decimal type. And I believe such a type could handle up to 12 hex characters, even doing math with same as follows: Sub test() Dim VariantDecimal As Variant VariantDecimal = CDec("&hfffffff fffff") Debug.Print VariantDecimal Debug.Print VariantDecimal / 5 Debug.Print Sqr(VariantDeci mal) End Sub
I also believe that somewhere, somehow, sometime, variant
decimalswere changed, allowing larger numbers. And I believe that the VBA variant decimal type is not identical with JET's decimal data
typewhich permits maximium values of only 10^28 - 1.
Well that is great news! 281474976710655 Variant Decimal 56294995342131 Above Amount Div by 5 16777216 Square Root of the First Number Now, if I can come up with an ingenious way to break down Variant Decimal values larger than &hFFFFFFFF, I'll be home free. I'll bet someone clever has already figured out and posted a way to convert numbers up to 281474976710655 to HEX strings.
???
Lyle's code operates on #hFFFFFFFFFFFF, which is the number you're
looking for.
I don't know what Lyle is talking about with his decimal veriant.
Surely a Double or a Single could store all the values you needed,
unless I've completely forgotten how to interpret exponential
notation. My Windows calculator tells me that your upper limit,
#hFFFFFFFFFFFF, is 2.8147497671065 5e+14, and the upper limit for
double data type is 1.7976931348623 2e+308, according to the A97
help
file. Now, the base number for your upper limit is bigger, but the
exponent is many orders of magnitude smaller, so it seems quite
clear to me that you should be able to store your numbers
accurately
in a double, a numeric data type.
Unless, of course, I'm terribly confused about how all this works.
If I am, I'm sure someone will correct me.
I'd certainly think it would be *much* easier to store numbers as
numbers than to have to convert them from strings in order to
perform operations on them.
Why would you *not* choose double or Single? What, exactly, would
you be gaining by storing your numbers as strings?
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
David W. Fenton <dX********@bwa y.net.invalid> wrote: MLH <CR**@NorthStat e.net> wrote in news:qv******** *************** *********@4ax.c om:
On 1 Dec 2005 16:30:06 -0800, "Lyle Fairfield" <ly***********@ aim.com> wrote: I also believe that somewhere, somehow, sometime, variant decimals were changed, allowing larger numbers. And I believe that the VBA variant decimal type is not identical with JET's decimal data type which permits maximium values of only 10^28 - 1.
Well that is great news! 281474976710655 Variant Decimal 56294995342131 Above Amount Div by 5 16777216 Square Root of the First Number Now, if I can come up with an ingenious way to break down Variant Decimal values larger than &hFFFFFFFF, I'll be home free. I'll bet someone clever has already figured out and posted a way to convert numbers up to 281474976710655 to HEX strings.
???
Lyle's code operates on #hFFFFFFFFFFFF, which is the number you're looking for.
I don't know what Lyle is talking about with his decimal veriant.
Why not upto #hFFFFFFFFFFFFF FFFFFFFFFFF
=79228162514264 337593543950335 , the largest variant decimal?
--
Paul This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ian Richardson |
last post by:
I'm writing a large Javascript application (uncompressed source around
400K) which is doing almost all the initialisation it needs to in a
just-in-time manner. However, I have included an option for almost all
of this to be done when the application first starts.
Under this circumstance, and since the last few nightly builds of
Mozilla, I've been getting:
Script warning:
|
by: Milan Cermak |
last post by:
Hi all,
I'm developing my own basic classes library (http://stlib.sf.net for
those how are interested) and I'd like to compare its power to STL.
Unfortunately I'm not familiar with STL - it blows up my mind everytime
I try to understand it.
Could you, please, show me the code implementing following functionality?
Consider two strings that contains only digits. These strings are 7 to
15 digits long. (They are telephone numbers read...
|
by: Philipp H. Mohr |
last post by:
Hello,
I am trying to xor the byte representation of every char in a string with
its predecessor. But I don't know how to convert a char into its byte
representation. This is to calculate the nmea checksum for gps data.
e.g. everything between $ and * needs to be xor:
$GPGSV,3,1,10,06,79,187,39,30,59,098,40,25,51,287,00,05,25,103,44*
to get the checksum.
|
by: Danny Lesandrini |
last post by:
I'm using an Access database to drive a web site and the
colors of various table backgrounds are stored in Access.
I want users of the Access database to be able to select
colors for the site, but my mappings between named colors,
HEX values and the Long Integer values used in Access are
not jibbing. Anyone have a nice list laying around?
Danny J Lesandrini
dlesandrini@hotmail.com
|
by: Sean Kenwrick |
last post by:
I am writing a byte-code interpreter/emulator for a language that
exclusively uses strings for variables (i.e all variables are pushed onto
the stack as strings). Therefore for arithmetic operations I need to
convert the string to a 32 bit integer, carry out the arithmetic operation,
then convert it back to a string before pushing it back onto the stack.
This can happen millions of times per second so it is essential that I have...
| |
by: tpgames |
last post by:
I've struck zero in finding a Link to a sudoku game that actually uses images for numbers, even images OF numbers. Yes, I'd prefer the game in JavaScript. Every site I've been too, (hundreds) uses CSS and HTML and NOT images. I've only found 1 site that uses images, and their source code is NOT available for viewing, at all. I can't even find that site anymore. I do mean that the game itself uses images in solving the problem. I do not mean,...
|
by: Harlin Seritt |
last post by:
Hi...
I would like to take a string like 'supercalifragilisticexpialidocius'
and write it to a file in binary forms -- this way a user cannot read
the string in case they were try to open in something like ascii text
editor. I'd also like to be able to read the binary formed data back
into string format so that it shows the original value. Is there any
way to do this in Python?
Thanks!
|
by: Steve |
last post by:
I am having problems getting values out of an array. The array is set
as a global array and values are pushed into it as they are read from
a JSON file using a "for loop". When the "for loop" is finished I want
to convert the array into a string which can be used by another
function. My attempt to do this is not working. The script looks like
this:
heights=;
function getElevationInter(latv,lngv) {
var script =...
|
by: Fett |
last post by:
I need a crypto package that works on windows with python 2.5. Can
anyone suggest one for me?
I have been searching for a couple days for a good cryptography
package to use for public/private key encryption, at this point I
would settle for symmetric even.
Every encryption package I have found for python was either operating
system specific (read *nix only):
http://www.freenet.org.nz/ezPyCrypto/
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |