Some Visual Basic Help Please

EirePlane · 26 Nov 2008 at 18:26

Having trouble with my VB Project again but google has failed me.

Is there any way to distinguish between Letters and Numbers entered into a textbox without limiting it to one or the other?

Basically, i have a text box where users can enter a code to find an item and I want it to look up two different sources depending on what is entered

e.g. if a text code is entered, the code checks the database for a line which uses this ItemCode.
If a barcode is scanned in (all numbers) then it should look under the Barcode field instead

Any help greatly appreciated

Cheers,
Mitchel

DireEmblem · 26 Nov 2008 at 18:38

Code:

if(ISNUMBER(...textboxInput) Then
      ...check Barcode
Else
     ... check Itemcode
Endif

Insert your own code ... and done

EirePlane · 26 Nov 2008 at 18:46

DireEmblem said:
Code:

if(ISNUMBER(...textboxInput) Then ...check Barcode Else ... check Itemcode Endif

Insert your own code ... and done

it doesn't work, just tells me "Sub or Function not defined"
I'm using VB6 by the way, not VB.NET

philldutton · 26 Nov 2008 at 19:38

I think it's IsNumeric rather than IsNumber, but it's been a while since i did any VB.

DireEmblem · 26 Nov 2008 at 19:58

my bad, sorry yes IsNumeric is the VB code for excels IsNumber...

That will work

EirePlane · 27 Nov 2008 at 12:15

yup, IsNumeric worked brilliantly. Thank you very much