How to call a Public Function in Update Query or from code ?

[william poh ben]

I have this Public Function statement from Gary Miller some time ago,
that can use to loop through the PartNumbers and strip the lef
characters out until it runs into one that isn't a zero.

How can I do this by calling this Public Function in an Update Query o
from code ?

Example of the Part Numbers :
12220-89210
12220-89211E
12221-00110
00866751158666
00004255781123
00000125667233
00000027791001

The PartNumbers don't have a value such as this:
000123456-1234
0000000123E




Public Function StripZeros(strNum as String)

Do Until Left(strNum,1) < "0"
strNum = Right(strNum,Len(strNum)-1)
Loop

StripZeros = strNum

End Functio

 

[Arvin Meyer]

Use the function in a query like this:

Update MyTable Set MyTable.[PartNumbers] = StripZeros([PartNumbers]);

I'd add On Error Resume Next to your function to take care of little things
like missing partnumbers.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access