ÎÒ×öÒ»¸öȨÏÞ¹ÜÀí£¬ÐèÒªÔÚÿ¸öÒ³Ãæ´ò¿ªÊ±²éѯÊý¾Ý½øÐÐÅжϣ¬
Êý¾Ý¿âÖдæÓÐformÃû£¬ÏȶԴò¿ªµÄ´°Ìå½øÐÐÒþ²Ø£¬Èç¹ûȨÏÞ²»·ûºÏʱ£¬
´°Ì幨±Õ£¬²¢ÌáʾûÓÐȨÏÞ£¬Èç¹û·ûºÏ£¬ÔòÏÔÊ¾Ò³Ãæ
×îºÃ¸øÓè¾ßÌåµÄ´úÂëÀý×Ó
»Ø´ðµÄºÃÁíÍâ¼Ó·Ö
ÒýÓÃ
ºÍÊÇ·ñʹÓÃAPIÎ޹ء£
³ÌÐò´úÂëÀïÃæÅжϼ´¿É¡£
Äãû¶®ÎÒµÄÒâ˼£¬ÎÒÊÇÒª¼à¿Ø´°Ìå´ò¿ªÊ ......
StrSQL="SELECT Max(SaleTicketNo) as salesticketno from tabSaleList WHERE saledate=2010-4-14"
Set SaleRS = SaleMDB.OpenRecordset(StrSQL, dbReadOnly)
Èç¹û²éѯ³öÀ´Ã»ÓÐÖµ ÔÚµ÷ÊÔµÄʱºò¿´¼ûSaleRS("salesticketno")µÄ½á¹ûÊÇNull ÎÒ¼ÓÉÏÅжÏÌõ¼þ
If Not SaleRS.EOF Then
If Sa ......
ÎÒÐèÒª¶ÔϱßÒ»×éÊý½øÐÐУÑéºÍµÄËã·¨£¬Ëã·¨Êǵ¥×Ö½ÚÏà¼Ó£¬È»ºóµÃµ½µÄ½á¹ûÈ¡·´+1£¬ÇëÎÊÔõô¼ÆËãÄØ£¿
ÐèҪУÑéºÍÊý¾Ý£ºA9 01£¨Îª01-16Ö®¼äµÄÊý×Ö£© 01£¨Îª01-16Ö®¼äµÄÊý×Ö£©00 00 00 00 00 00 00 00 00 00 00 00
¹Ø×¢¡£¡£¡£¡£¡£¡£¡£¡£
ºÃµÄ£¬ÎÒÈ¥¿´¿´¡£Ò»»áÎÒ¸øÌû×Ó¼Óµã·Ö
ºï¸ç£¬A9ÔÚʲôµØ·½°¡£¿
ÎÒÕâô¸ÄÁË£¬ºÃÏ ......
ÔÚVBÖÐÈçºÎ·µ»Ø×Ö·ûµÄUnicode±àÂëÖµ£¬°üÀ¨ÖÐÎÄ×Ö·û¡£
ΪʲôÎÒÓÃAscW£¨£©º¯ÊýÈ¡ÖÐÎĵÄUnicodeÖµÓÐЩΪÕýÊý£¬ÓÐЩȴΪ¸ºÊýÄØ£¿
Õý³£,ÒòΪAscW·µ»ØµÄIntegerÐÍ,±¾À´¾ÍÊÇ2×Ö½ÚµÄ,·ÖÕý¸ºµÄ°¡,ÄãÒ²¿É
Hex$(AscW())ÕâÑùÒÔÊ®Áù½øÖƸñʽ²é¿´µÄ
Unicode vs Ansi
Visual Basic 32-bit °æ±¾µÄ×Ö´®´¦Àí²ÉÓà Unicode£¬Ò²¾Í ......
±ÈÈçSQLÖнøÐеÄÌí¼Ó¡¢Ð޸ġ¢É¾³ýµÈ¶ÔÊý¾Ý¿â½øÐвÙ×÷µÄÓï¾ä£¬ÈçºÎÓÃvb½øÐмǼ£¿£¿£¿
ÓÃtimer¶¨Ê±Ö´ÐÐ,sendkeys "^{s}",true
Èç¹û¼ôÇаåÓÐÖµ,¾ÍÌí¼Óµ½ÈÕÖ¾Àï,ÿ¼Ç¼һ´Î,Çå¿ÕһϼôÇаå.
Óеãbug....
¸üÕýΪ sendkeys "^{c}",true
ÄܾÙÒ»¸öÀý×ÓÂð£¿Ì«Áýͳ£¬²»Ã÷°×ÈçºÎʹÓÃ
´¥·¢Æ÷ ÊäÈëÎļþ ......
¼±ÇóÓÃVBºÍsql serverÉè¼Æ±¨±íµÄ·½·¨ºÍÏêϸ²½Öè»ò´úÂë
¶¥ÉÏÀ´£¬Çë´ó¼Ò°ïæ
ÍøÉÏ´úÂëºÜ¶à,ËѰÉ
ÓÃadoÁ¬½ÓÊý¾Ý¿â,½«Êý¾Ýµ¼³öµ½excelÉÏ
ÎÒÏëͨ¹ýVB×Ô´øµÄ±¨±íÉè¼ÆÆ÷À´ÊµÏÖ
¶¥ÉÏÀ´
°æÖ÷ÌùÖ÷ÔçÉϺã¡
°æÖ÷ÌùÖ÷ÿÌì¶¼ÓкÃÐÄÇ飡
4wsvEYuUtljxrp9CR04FVb3T9Xzx»ØÌûÊÇÒ»ÖÖÃÀµÂ£¡RhSkjerHSlPXIR8uOHidnS36zfrF
==== ......