Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #10317
| From | "Phil" <phil@stantonfamily.co.uk> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: Marking Range of a Number in Select Statement |
| Date | 2015-01-30 18:18 +0000 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <maghtf$3rk$1@speranza.aioe.org> (permalink) |
| References | (3 earlier) <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> <mafu7d$u9l$1@dont-email.me> |
On 30/01/2015 12:42:54, "Ron Paii" wrote: > > > "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) > > > Don't think that will work, Ron as PL is a Type variable with 5 values, not a single integer. At this stage, I am only messing about with VBA, in the Debug window, so no queries are involved Phil --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com
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