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

accessÖÐʹÓÃtableÈ·¶¨Î»ÖÃ

¡¡¡¡²»ÖªµÀaccessÖÐÊÇ·ñÄܹ»Ê¹ÓÃtableÀ´½«¸÷¸ö¿Ø¼þ·ÅÈëÏàÓ¦µÄtableµÄ¸÷¸ö¸ñ×ÓÖУ¬¾Í¸úvsµÄaspÒ»Ñù¡£ÔÚdesignÖÐûÓÐÕÒµ½¿ÉÒÔÔÚÒ³ÃæÖгÊÏÖÒ»¸ötableµÄ¹¤¾ß£¬Ïò´ó¼ÒÇó½Ì£ºaccessµ½µ×ÊÇ·ñÓÐÕâÑùµÄ¹¤¾ß£¿

¿´À´£¬accessµÄ½çÃæ¹¦ÄÜ»¹ÊÇûÓÐvsÇ¿´ó£¬ºÇºÇ£¡
ÓÃÁËÒ»¸ösub form£¬Ò²²»ÊǺܺÃÓá£


Ïà¹ØÎÊ´ð£º

access ²éѯ¼Ç¼µÄÎÊÌâ?

ÎÊÌâÈçÏ£º

ÓòéѯÓï¾ä
select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´
¸ÄΪ
select * from tab where fil = 'CK090902'
¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......

MSHFelxGrid Óë ACCESS MEMOÀàÐÍ×ֶεÄÒÉÎÊ

×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ

µ±Êý¾Ý¿â×Ö¶ÎÎ ......

¹ØÓÚsqlÀïµÄÓï¾äÓëaccessÀïÓï¾äÎÊÌâ

ÎÒÔÚSQL2000ÖÐÏÂÃæµÄÕâ¾äÊÇûÎÊÌâµÄ,¿Éµ½ÁËaccessÀï¾Í»áÁË´í
select max(classname) as classname,max(parentpath) as parentpath,max(rootid) as rootid,max(classid) as classid from prodclass where parentpa ......

Access ¶ÔÏóÒѹرÕ,²Ù×÷²»ÔÊÐí!

Public Rs As New ADODB.Recordset
Public Conn As New ADODB.Connection

Private Sub Command1_Click()
    Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & A ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ