Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎͨ¹ýACCESS VBAÔÚ³ÌÐòÀï±£´æACCESSµÄ²éѯ¶ÔÏó

ACCESSÓиöAllQueries¼¯ºÏ£¬ÀïÃæÊÇËùÓб£´æÔÚACCESSÀïµÄ²éѯ¡£

ÇëÎÊÈçºÎÔÚACCESS VBAÀﶯ̬Éú³ÉÒ»¸öеIJéѯ£¬¼´±£´æÎªÐµIJéѯ¶ÔÏó£¬Ò²¼´ÔÚAllQueries¼¯ºÏÖÐÌí¼ÓÒ»¸öеijÉÔ±£¿
VB code:
Call CurrentDb.CreateQueryDef("qqqqqqq", strSql)


ÔÚ±ðµÄ°æ¿éÕÒµ½´ð°¸ÁË¡£

ÄÇÎҵøϽô½Ó·Ö£¬µ¹20¸øÎҾͿÉÒÔÁË¡£

ÎÒµÄÔ­Ôò£º

¶¥ÌùµÄ×î¶à¸ø1·Ö¡£

¼¼ÊõÉÏÓмÛÖµµÄ»Ø¸´²Å¸ø¼¼Êõ·Ö¡£



Òª²»Äã½²¸öЦ»°£¬ÎÒ°Ñ·Ö¶¼¸øÄ㣬ÁíÍâ°ÑÕâ¸öÌû×ÓÒÆµ½·Ç¼¼ÊõÇø£¬ºÙºÙ¡£Äã¿´ÔõôÑù£¿

¶¥£¡

лл¥Ö÷ÁË£¬£¬ÎÒÕýºÃÒ²ÓÐÕâ¸öÎÊÌâÁË

ÕõVBAµÄµÚÒ»·Ö

½Ó·Ö

ÒýÓÃ
Òª²»Äã½²¸öЦ»°£¬ÎÒ°Ñ·Ö¶¼¸øÄ㣬ÁíÍâ°ÑÕâ¸öÌû×ÓÒÆµ½·Ç¼¼ÊõÇø£¬ºÙºÙ¡£Äã¿´ÔõôÑù£¿

ÎÒÊDZ¾Ï뿴ϵ¹20·ÖÀ´ÎÒµÄID»á²»»á±»¸Éµô¡£

תµ½·Ç¼¼ÊõÇø°É£¬¼ÇµÃת֮ºó±ð¸øÎÒ·Ö¡£Ð»Ð»¡£

ÎÊÌâÊÇ£¬Èç¹û±»ÅÐΪµ¹·ÖµÄ»°£¬Á½¸öID¶¼Òª±»·âµÄ8

Òª²»ÄãÕÒ¸öÓ¸ҵãµÄÐֵܺÍÄã¶ÔÁ·Ò»ÏÂ8

°³ÅÂÅÂ

ÎÒµÄIDÎÞËùν£¬¶¼µ¹¸øÎÒºÃÁË

ahaoºÍACÄãÃÇÁ©ºÃÏñµ¹Ò»ÏÂ8

ÎÒ¿´ÄãÃÇÔÚÕâÒ»µãÉÏ־ȤºÜÏàͶ

ahaoºÍACÄãÃÇÁ©»¥Ï൹һÏÂ8

ÎÒ¿´ÄãÃÇÔÚÕâÒ»µãÉÏ־ȤºÜÏàͶ

Õ¦²»Ëµ»°ÁË£¬²»»áÒѾ­·âÁ˰ɣ¿

×¢²áÁËÐÂÂí¼×Ö®ºó¼ÇµÃ·¢¶ÌÏûÏ¢¸øÎÒ°¡£¬°³ÏÖÔÚ¶¼²»´¦ÀíºÃÓÑÏûÏ¢ÁË£¨Ö÷Òª¶¼ÊDz»ÈÏʶµÄÈË£©£¬³ý·ÇÓÐÈËÌØµØ·¢Õ¾¶Ì¸æËßÎÒ¼Ó¡£
{{----}


Ïà¹ØÎÊ´ð£º

ʹÓÃRepeater¶ÁÈ¡access±í£¬Ò³Ãæ´ò¿ª·Ç³£Âý

accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í  ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......

ÈçºÎ½«XMLÊý¾Ý´æÈëACCESSÊý¾Ý¿â

ÇëÎʸ÷λ´óʦ£¬ÎÒÏÖÔÚÐèÒª½«XMLµÄÊý¾ÝʵʱµÄ´æÈëµ½Êý¾Ý¿âÖУ¬ÎÒÊÇÓÃasp±àµÄ³ÌÐò£¬´óÁ¿Ãǰïæ·ÖÎö һϣ¡£¡£¡
ÏÂÃæÊÇÎÒµÄXMLÎļþ´úÂë
XML code:

<?xml version="1.0" encoding="utf-8"? ......

¹ØÓÚDelphiÁ¬½ÓACCESSÊý¾Ý¿â²éѯÎÊÌâ

¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......

vb.net ´´½¨accessÊý¾Ý±íʵÏÖÒ»Êý¾Ý¿â¶à¸öÊý¾Ý±í£¿

Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ