Access������--
ËùÊô·ÖÀࣺ ×Ö·û´¦Àí ×÷Õߣº ¹²ïí ¸üÐÂÈÕÆÚ£º2003-10-18 10:00:59 ÔĶÁ´ÎÊý£º227

½«15µÄÉí·ÝÖ¤ºÅÉýΪ18λµÄº¯Êý


Function IDCode15to18(sCode15 As String) As String
* ¹¦ÄÜ:½«15µÄÉí·ÝÖ¤ºÅÉýΪ18λ(¸ù¾ÝGB 11643-1999)
* ²ÎÊý:Ô­À´µÄºÅÂë
* ·µ»Ø:ÉýλºóµÄ18λºÅÂë
Dim i As Integer
Dim num As Integer
Dim code As String
num = 0
IDCode15to18 = Left(sCode15, 6) + "19" + Right(sCode15, 9)
¼ÆËãУÑéλ
For i = 18 To 2 Step -1
num = num + (2 ^ (i - 1) Mod 11) * (Mid(IDCode15to18, 19 - i, 1))
Next i
num = num Mod 11
Select Case num
Case 0
code = "1"
Case 1
code = "0"
Case 2
code = "X"
Case Else
code = Trim(Str(12 - num))
End Select
IDCode15to18 = IDCode15to18 + code
End Function


--------------------------------------------------------------------------------
Ïà¹ØÎÄÕÂ

ÆÊÎö Declare Óï¾ä 2004-1-28 15:08:06
Á˽â¾ä±ú 2004-1-28 15:03:43
ʲôÊÇ API£¿ 2004-1-28 15:01:53
Access Êý¾Ý¿âºÍ Access ÏîÄ¿Ö®¼äµÄÊý¾ÝÀàÐ͵ıȽϻòÓ³Éä 2003-12-26 14:20:19
´óÐÍÊý¾Ý¿âÉè¼ÆÔ­Ôò 2003-12-15 12:49:18
dz̸Êý¾Ý¿âÉè¼ÆÖеķ´¹æ·¶ 2003-12-15 12:47:05
ÈçºÎʵÏÖÎı¾²éÕÒ¹¦ÄÜ-Instrº¯ÊýʹÓü¼ÇÉ 2003-11-18 9:28:25
¶Ô×¢²á±í²Ù×÷¼¼ÇÉ-½«³ÌÐòÔÚ¿ª»úʱÔËÐÐ 2003-11-18 9:24:59
officeXPÏÂʹÓÃÎļþ¶Ô»°¿òµÄÁíÍâÒ»ÖÖ·½·¨ 2003-11-17 8:47:04
Á˽â Microsoft Access °²È«ÐÔ 2003-11-13 11:21:08
ÈçºÎÈô°Ìå×ÜÔÚ×îÇ°Ã棿 2003-11-7 8:25:19
ÈçºÎ¹Ø±Õ¼ÆËã»ú£¿ 2003-11-7 8:24:43
ÈçºÎ½¨Á¢¼òµ¥µÄ³¬¼¶Á¬½Ó£¿(ShellExecute) 2003-11-6 20:39:18
ÈçºÎÈô°ÌåµÄ±êÌâÌõÉÁ˸ÒÔÒýÆðÓû§×¢Ò⣿ 2003-11-6 20:38:43
ÔõÑùÕÒµ½Êó±êÖ¸ÕëµÄXY×ø±ê£¿ 2003-11-6 20:37:33
ÔÚ³ÌÐòÖÐÈçºÎ´ò¿ªºÍ¹Ø±Õ¹âÇýÃÅ£¿ 2003-11-6 20:20:00
ÔõÑùʹCtrl-Alt-DeleteÎÞЧ£¿ 2003-11-6 20:19:25
ÈçºÎÒƶ¯Ã»ÓбêÌâÀ¸µÄ´°¿Ú£¿ 2003-11-6 20:17:30
ÑÓʱº¯Êý 2003-11-6 20:16:53
È¡µÃµµ°¸ÈÕÆÚÏà¹ØÊôÐÔ 2003-10-29 19:09:17
Èÿؼþ×ÔÊÊÓ¦ÆÁÄ»·Ö±æÂÊ 2003-10-18 9:58:33
±ÜÃâAccessºÍSQL ServerµÄ¿ÕÖµ³åÍ» 2003-10-17 20:03:19
Microsoft AccessÃØÃÜ¡¢¼¼ÇɺÍÏÝÚå 2003-10-17 19:58:04
±í´ïʽÉú³ÉÆ÷Öеļ¸ÖÖ³£Ó÷ûºÅ 2003-10-17 19:55:56
¶Ô Microsoft Office ÃüÁîÀ¸½øÐиü¶à±à³Ì 2003-10-17 19:51:34
VBÖÐÀûÓÃWinrar½øÐÐÎļþѹËõ 2003-10-17 19:33:08
³õʶVBA£ºµÚÁù¿Î СÊýµã´úÂë·ÖÎö¼°ForÑ­»·Óï¾ä 2003-10-17 19:29:45
³õʶVBA£ºµÚÎå¿Î СÊýµã°´Å¥¼°·ÖÖ§Óï¾ä 2003-10-17 19:27:51
³õʶVBA£ºµÚËÄ¿Î ¼ÆËãÆ÷´úÂëµÄ±àд 2003-10-17 19:25:03
³õʶVBA£ºµÚÈý¿Î Éè¼ÆÒ»¸ö¼òµ¥µÄ¼ÆËãÆ÷ 2003-10-17 19:17:40
³õʶVBA£ºµÚÒ»¿Î ³£Óõļ¸¸ö»ù±¾¸ÅÄî 2003-10-17 19:15:46
SQL SERVER ÓëACCESS¡¢EXCELµÄÊý¾Ýת»» 2003-10-17 19:12:00
µ¥»úÀàÄ£¿é±à³Ì¼ò½é 2003-10-17 18:57:58
MS Jet SQL for Access 2000Öм¶Æª (III) 2003-10-17 18:51:47
MS Jet SQL for Access 2000Öм¶Æª (II) 2003-10-17 18:51:01
ADOÈý´ó¶ÔÏóµÄÊôÐÔ¡¢·½·¨¡¢Ê¼þ¼°³£Êý£¨Èý£© 2003-10-14 8:44:20
È·¶¨ÓïÑÔ°æ±¾µÄÑùÀýº¯Êý 2003-10-14 8:41:33
ÈçºÎÈ·¶¨µ±Ç°ÆÁÄ»·Ö±æÂÊ 2003-10-14 8:41:00
»ñÈ¡windows°²×°Â·¾¶ 2003-10-14 8:39:08
ÈçºÎ´Ó Microsoft Access ÄÚµ÷Óà Excel º¯Êý 2003-10-14 8:38:11
½« Microsoft Access ÓÃ×÷ Automation ·þÎñÆ÷ 2003-10-14 8:37:19
Êý¾Ý¿âÉè¼Æ·¶Ê½ 2003-10-10 10:40:52
AccessÆô¶¯ÃüÁîÐÐÑ¡Ïî´óÈ« 2003-10-10 10:02:00
ÈçºÎÓÃvba¼ì²éÈíÇýÊÇ·ñÓÐÈíÅÌ 2003-10-6 16:36:56
Êý¾Ý¿âÓ¦ÓóÌÐòÐè×¢ÒâµÄÎÊÌâ 2003-10-6 11:11:06
ÓÅ»¯Microsoft AccessÌá¸ßËÙ¶È 2003-10-6 10:31:55

ϵͳÓÅ»¯
¿Ø¼þʹÓÃ
Êý¾Ý¿âÉè¼Æ
Êý¾Ý¿âÁ¬½Ó
ϵͳ°²È«
OLE×Ô¶¯»¯
³£¼ûÎÊÌâ
ʵÓôúÂë
ÊôÐÔÏê½â
ÍøÂçÏà¹Ø
ʵÓÃAPI
¾­Ñé·ÖÏí
¾«Ñ¡½Ì³Ì
×Ö·û´¦Àí
ADPÏà¹Ø



ÎÄÕÂËÑË÷



ÖÆ×÷ά»¤£ºÀîÑ°»¶     Mail:[email protected]

¹ØÓÚ±¾Õ¾ -- ÍøÕ¾·þÎñ -- °æȨÌõ¿î -- ÁªÏµ·½·¨ -- ÍøÕ¾°ïÖú
Access°®ºÃÕß°æȨËùÓÐ Copyright 2003-2005 All Rights Reserved δ¾­Ðí¿É²»µÃµÁÁ´