Error VBA function

Question

Function CC1(BP As short, CC As short) As String
    If BP = 1 Then
    cc = "B*"
      Else
    cc = "C*"
   End If
End Function

I tried to call the above function in access query, but if says compile error

Access query has this function in below format

n: CC1([BP],[CC])

Declare as Long.

QHarr
– QHarr

2018-08-01 05:45:42 +00:00
Commented Aug 1, 2018 at 5:45 — QHarr
– QHarr, Commented Aug 1, 2018 at 5:45

Andre · Accepted Answer · 2018-08-01 05:43:16Z

2

VBA doesn't have a data type short.

https://msdn.microsoft.com/en-us/vba/language-reference-vba/articles/data-type-summary

answered Aug 1, 2018 at 5:43

Andre

27.7k7 gold badges43 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

QHarr · Accepted Answer · 2018-08-01 05:46:30Z

1

As mentioned Short doesn't exist.

Declare as Long which can easily cater for signed 16-bit (2-byte) integers that range in value from -32,768 through 32,767.

Why Long? See the lengthy discussion here: Why Use Integer Instead of Long?

answered Aug 1, 2018 at 5:46

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

3 Comments

Archana Over a year ago

thank you :-) But I see null value when I call the same function in query

QHarr Over a year ago

? There is no function above. It is a datatype called Long.

Archana Over a year ago

If you can see my function in the question section

Santosh · Accepted Answer · 2018-08-01 15:30:18Z

0

Byte is suitable for your function defined

SELECT CC1([BP],[CC]) as n

Function CC1(BP As Byte, CC As Byte) As String
    If BP = 1 Then
    CC1 = "B*"
      Else
    CC1 = "C*"
   End If
End Function

Note:

The value to be returned must be assigned to a variable having the same name as the Function
CC As Byte is not used.

edited Aug 1, 2018 at 15:30

answered Aug 1, 2018 at 6:21

Santosh

12.4k4 gold badges43 silver badges74 bronze badges

Collectives™ on Stack Overflow

Error VBA function

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related