Mac Addressing

  • Thread starter Thread starter Tom M
  • Start date Start date
T

Tom M

Hello. I new to the newsgroup, and hoping you can help.

I'm not sure how I should create a table to store MAC
address. i.e. A6-3D-CE-65-12-3F and how do I limit the
charcters to only 0 1 2 3 4 5 6 7 8 9 A B C D E F

any help would be appreciated

Thank you Tom
 
Tom,

Hexidecimals are limited to 0-9 and A to F so maybe you could work that in
somehow. Also, the ascii value of 0 to 9 is 48 - 57 and the ascii value of A to
F is 65 to 70 so maybe you could use the Asc function and work that in somehow.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
 
Here is a simple way to do this. When the user types an invalid hex value
the text box ignores it. All of the logic is wrapped up in the instr()
function.

Private Sub Text0_KeyPress(KeyAscii As Integer)
If InStr("0123456789ABCDEFabcdef", Chr(KeyAscii)) = 0 Then
KeyAscii = 0
End If
End Sub

Ron W
 
Ron W
This works fine, except, how can I allow the Backspace key
and the delete key?

Thank you

Tom
 
Back
Top