Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #10315
| From | "Ron Paii" <None@none.com> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: Marking Range of a Number in Select Statement |
| Date | 2015-01-30 06:42 -0600 |
| Organization | A noiseless patient Spider |
| Message-ID | <mafu7d$u9l$1@dont-email.me> (permalink) |
| References | (2 earlier) <m9qshf$kqs$1@dont-email.me> <96b5d0cb-3f1e-46f3-9b49-ec3dacbce28b@googlegroups.com> <m9u2ji$dg2$1@speranza.aioe.org> <fe0da02e-0562-49d8-92a0-30f0394770f7@googlegroups.com> <maecnb$m50$1@speranza.aioe.org> |
"Phil" <phil@stantonfamily.co.uk> wrote in message news:maecnb$m50$1@speranza.aioe.org... > On 29/01/2015 20:56:32, wrote: >> Private Type PartitionLimits >>> Rounding As Single >>> LowerLimit As Single >>> LowerValue As Single >>> UpperLimit As Single >>> UpperValue As Single >>> End Type >>> >>> Function GPA3(NoIn As Single, PL As PartitionLimits) >>> 'Debug.Print GPA3(3, 0.2, 2, 0.99, 4.2, 4.2) > > Thanks, James. > > Makes no difference. Still get a Compile Error - ByRef argument mismatch. > > Phil > > --- > This email has been checked for viruses by Avast antivirus software. > http://www.avast.com > A query cannot pass a "PartitionLimits" type using setting Integer or Long. "Single" may also cause you problems, I would us Integer. Function GPA3(NoIn As Integer, PL As Integer)
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Marking Range of a Number in Select Statement mflynn@scu.edu - 2015-01-20 09:31 -0800
Re: Marking Range of a Number in Select Statement Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-01-20 11:16 -0800
Re: Marking Range of a Number in Select Statement mflynn@scu.edu - 2015-01-20 11:44 -0800
Re: Marking Range of a Number in Select Statement "Phil" <phil@stantonfamily.co.uk> - 2015-01-21 09:44 +0000
Re: Marking Range of a Number in Select Statement "Ron Paii" <None@none.com> - 2015-01-21 07:36 -0600
Re: Marking Range of a Number in Select Statement "Ron Paii" <None@none.com> - 2015-01-21 09:27 -0600
Re: Marking Range of a Number in Select Statement CDMAPoster@fortunejames.com - 2015-01-21 14:48 -0800
Re: Marking Range of a Number in Select Statement "Ron Paii" <None@none.com> - 2015-01-22 07:05 -0600
Re: Marking Range of a Number in Select Statement CDMAPoster@fortunejames.com - 2015-01-22 07:55 -0800
Re: Marking Range of a Number in Select Statement "Phil" <phil@stantonfamily.co.uk> - 2015-01-23 18:06 +0000
Re: Marking Range of a Number in Select Statement CDMAPoster@fortunejames.com - 2015-01-29 12:56 -0800
Re: Marking Range of a Number in Select Statement "Phil" <phil@stantonfamily.co.uk> - 2015-01-29 22:37 +0000
Re: Marking Range of a Number in Select Statement "Ron Paii" <None@none.com> - 2015-01-30 06:42 -0600
Re: Marking Range of a Number in Select Statement "Phil" <phil@stantonfamily.co.uk> - 2015-01-30 18:18 +0000
Re: Marking Range of a Number in Select Statement CDMAPoster@fortunejames.com - 2015-01-30 08:20 -0800
Re: Marking Range of a Number in Select Statement CDMAPoster@fortunejames.com - 2015-02-05 09:10 -0800
Re: Marking Range of a Number in Select Statement mflynn@scu.edu - 2015-01-23 08:51 -0800
Re: Marking Range of a Number in Select Statement mflynn@scu.edu - 2015-01-28 11:05 -0800
csiph-web