[AccessD] Weekend fun: Primes

Gustav,

I still don't know why this intrigues me...but I found away around the 
2,147,483,647 problem I was having...I got rid of the MOD function, just 
used division instead, and used Instr(1,RemainderTest,".") to see if the 
number had a decimal.

Not sure what I will do with this new knowledge...but I now know alot of 
large Prime numbers.
Now that I have a db that will tell me if any number is prime...any 
suggestions, if any, of what to do with it?

Thanks,

Mark


>From: "Mark A Matte" <markamatte at hotmail.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: Re: [AccessD] Weekend fun: Primes
>Date: Fri, 09 Dec 2005 21:58:13 +0000
>
>...and...I found this in the help...not that it matters...just kinda
>weird...the PRIME number I maxed out on...is also the number used to set an
>access window to the color of your desktop:
>
>In the property box, type one of the numbers listed in the following table.
>For example, if you want the background of your form to display the same
>color that you or another user uses for the Windows background color, set
>the BackColor property to -2147483643, the value for Window.
>
>Screen element
>Scroll bar	-2147483648
>*Desktop	-2147483647*****My Max Number
>Active window title bar	-2147483646
>Inactive window title bar	-2147483645
>Menu bar	-2147483644
>Window	-2147483643
>
>
> >From: "Mark A Matte" <markamatte at hotmail.com>
> >Reply-To: Access Developers discussion and problem
> >solving<accessd at databaseadvisors.com>
> >To: accessd at databaseadvisors.com
> >Subject: Re: [AccessD] Weekend fun: Primes
> >Date: Fri, 09 Dec 2005 21:14:03 +0000
> >
> >Gustav,
> >
> >For whatever reason your email inspired me to look at primes...and I 
>wrote
> >a
> >module in A2k that would determine if a number was prime or not...it 
>seems
> >to work fine...until I get to the number 2,147,483,647  .  I'm using the
> >MOD
> >function in the module...and it apparently cannot handle a number larger
> >than this in VBA...I get an "OVERFLOW" error.  Any ideas?
> >
> >Thanks,
> >
> >Mark
> >
> >P.S...and if this is calculating correctly...2,147,483,647 just happens 
>to
> >be PRIME!!!
> >
> >
> >
> > >From: "Gustav Brock" <Gustav at cactus.dk>
> > >Reply-To: Access Developers discussion and problem
> > >solving<accessd at databaseadvisors.com>
> > >To: <accessd at databaseadvisors.com>
> > >Subject: [AccessD] Weekend fun: Primes
> > >Date: Fri, 09 Dec 2005 16:47:17 +0100
> > >
> > >Hi all
> > >
> > >Bored with report design, stubborn queries and/or naughty kids?
> > >
> > >"The problem of distinguishing prime numbers from composite numbers and
> >of
> > >resolving the latter into their prime factors is known to be one of the
> > >most important and useful in arithmetic. [...]
> > >The dignity of the science itself seems to require that every possible
> > >means be explored for the solution of a problem so elegant and so
> > >celebrated."
> > >   Carl Friedrich Gauss (1777-1855)
> > >
> > >A young, clever guy, Per Leslie Jensen, has dealt with this. Here's his
> > >presentation:
> > >
> > >   http://www.pgnfs.org
> > >
> > >Well done and worth a study!
> > >
> > >/gustav
> > >
> > >--
> > >AccessD mailing list
> > >AccessD at databaseadvisors.com
> > >http://databaseadvisors.com/mailman/listinfo/accessd
> > >Website: http://www.databaseadvisors.com
> >
> >
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com