accessºê²Ù×÷
´ò¿ª OpenDataAccessPage:ÔÚÒ³ÊÓͼ»òÉè¼ÆÊÓͼÖдò¿ªÊý¾Ý·ÃÎÊÒ³
OpenForm:ÔÚ´°ÌåÊÓͼ¡¢´°ÌåÉè¼ÆÊÓͼ¡¢´òÓ¡Ô¤ÀÀ»òÊý¾Ý±íÊÓͼÖдò¿ª´°Ìå
OpenModule:ÔÚÖ¸¶¨¹ý³ÌµÄÉè¼ÆÊÓͼÖдò¿ªÖ¸¶¨µÄÄ£¿é
OpenQuery:´ò¿ªÑ¡Ôñ²éѯ»ò½»²æ±í²éѯ
OpenReport:ÔÚÉè¼ÆÊÓͼ»ò´òÓ¡Ô¤ÀÀÊÓͼÖдò¿ª±¨±í»òÁ¢¼´´òÓ¡¸Ã±¨±í
OpenTable:ÔÚÊý¾Ý±íÊÓͼ¡¢Éè¼ÆÊÓͼ»ò´òÓ¡Ô¤ÀÀÖдò¿ª±í
²éÕÒ¡¢É¸Ñ¡¼Ç¼ ApplyFilter£º¶Ô±í¡¢´°Ìå»ò±¨±íÓ¦ÓÃɸѡ¡¢²éѯ»òSQLµÄWHERE×Ӿ䣬ÒÔ±ãÏÞÖÆ»òÅÅÐò±íµÄ¼Ç¼£¬ÒÔ¼°´°Ìå»ò±¨±íµÄ»ù´¡±í£¬»ò»ù´¡²éѯÖеļǼ
FindNext£º²éÕÒ·ûºÏ×î½üFindRecord²Ù×÷»ò“²éÕÒ”¶Ô»°¿òÖÐÖ¸¶¨Ìõ¼þµÄÏÂÒ»Ìõ¼Ç¼
FindRecord£ºÔڻµÄÊý¾Ý±í¡¢²éѯÊý¾Ý±í¡¢´°ÌåÊý¾Ý±í»ò´°ÌåÖУ¬²éÕÒ·ûºÏÌõ¼þµÄ¼Ç¼
GoToRecord£ºÔÚ´ò¿ªµÄ±í¡¢´°Ìå»ò²éѯ½á¹û¼¯ÖÐÖ¸¶¨µ±Ç°¼Ç¼
ShowAllRecords£ºÉ¾³ý»î¶¯±í¡¢²éѯ½á¹û¼¯»ò´°ÌåÖÐÒÑÓ¦ÓùýµÄɸѡ
½¹µã GoToControl£º½«½¹µãÒÆ¶¯µ½´ò¿ªµÄ´°Ìå¡¢´°ÌåÊý¾Ý±í¡¢±íÊý¾Ý±í»ò²éѯÊý¾Ý±íÖеÄ×ֶλò¿Ø¼þÉÏ
GoToPage£ºÔڻ´°ÌåÖУ¬½«½¹µãÒÆµ½Ö¸¶¨Ò³µÄµÚÒ»¸ö¿Ø¼þÉÏ
SelectObject£ºÑ¡¶¨Êý¾Ý¿â¶ÔÏó
ÉèÖÃÖµ SendKeys£º½«¼ü·¢Ë͵½¼üÅÌ»º³åÇø
SetValue£ºÎª´°Ìå¡¢´°ÌåÊý¾Ý±í»ò±¨±íÉϵĿؼþ¡¢×Ö¶ÎÉèÖÃÊôÐÔÖµ
¸üРRepaintObjet£ºÍê³ÉÖ¸¶¨µÄÊý¾Ý¿â¶ÔÏóËù¹ÒÆðµÄÆÁÄ»¸üУ¬»ò¶Ô»î¶¯Êý¾Ý¿â¶ÔÏó½øÐÐÆÁÄ»¸üС£ÕâÖÖ¸üаüÀ¨¿Ø¼þµÄÖØÐÂÉè¼ÆºÍÖØÐ»æÖÆ
Requery£ºÍ¨¹ýÖØÐ²éѯ¿Ø¼þµÄÊý¾ÝÔ´£¬À´¸üл¶ÔÏó¿Ø¼þÖеÄÊý¾Ý¡£Èç¹û²»Ö¸¶¨¿Ø¼þ£¬½«¶Ô¶ÔÏó±¾ÉíµÄÊý¾ÝÔ´ÖØÐ²éѯ¡£¸Ã²Ù×÷È·±£»î¶¯¶ÔÏó¼°Æä°üº¬µÄ¿Ø¼þÏÔʾ×îÐÂÊý¾Ý
´òÓ¡ PrintOut£º´òÓ¡»î¶¯µÄÊý¾Ý±í¡¢´°Ìå¡¢±¨±í¡¢Ä£¿éÊý¾Ý·ÃÎÊÒ³ºÍÄ£¿é£¬Ð§¹ûÓëÎļþ²Ëµ¥ÖеĴòÓ¡ÃüÁîÏàËÆ£¬µ«ÊDz»ÏÔʾ´òÓ¡¶Ô»°¿ò
¿ØÖÆ CancelEvent£ºÈ¡ÏûÒýÆð¸ÃºêÖ´ÐеÄʼþ
RunApp£ºÆô¶¯ÁíÒ»¸öWindows»òMS-DOSÓ¦ÓóÌÐò
RunCode£ºµ÷ÓÃVisual Basic Function¹ý³Ì
RunCommand£ºÖ´ÐÐAccess²Ëµ¥À¸¡¢¹¤¾ßÀ¸»ò¿ì½Ý²Ëµ¥ÖеÄÄÚÖÃÃüÁî
RunMacro£ºÖ´ÐÐÒ»¸öºê
RunSQL£ºÖ´ÐÐÖ¸¶¨µÄSQLÓï¾äÒÔÍê³É²Ù×÷²éѯ£¬Ò²¿ÉÒÔÍê³ÉÊý¾Ý¶¨Òå²éѯ
StopAllMacros£ºÖÕÖ¹µ±Ç°ËùÓкêµÄÔËÐÐ
StopMacro£ºÖÕÖ¹µ±Ç°ÕýÔÚÔËÐеĺê
´°¿Ú Maximize£º·Å´ó»î¶¯´°¿Ú£¬Ê¹Æä³äÂúAccessÖ÷´°¿Ú¡£¸Ã²Ù×÷²»ÄÜÓ¦ÓÃÓÚVisual Basic±à¼Æ÷ÖеĴúÂë´°¿Ú
Minimize£º½«»î¶¯´°¿ÚËõСΪAccessÖ÷´°¿Úµ×²¿µÄС±êÌâÀ¸¡£¸Ã²Ù×÷²»ÄÜÓ¦ÓÃÓÚVis
Ïà¹ØÎĵµ£º
Ëùν“´æÈ¡¼ü”¾ÍÏñ windows Ó¦ÓóÌÐòÖÐµÄ Alt ¿ì½Ý¼ü£¬Í¬Ê±°´ Alt ¼üºÍij¸ö×Öĸ¼ü£¬¿ÉÒÔ¿ìËÙÇл»µ½Îı¾¿ò¡¢°´Å¥µÈÒ³Ãæ¶ÔÏóÉÏ¡£
(1)¡¢Îı¾¿òµÄ Access Key£º
<FORM>
<LABEL FOR="Namebox" ACCESSKEY="N"><U>N</U>ame:</LABEL>
<INPUT TYPE="TEXT" ID="Namebox" SIZE=30> ......
½ñÌìÓÃOleDbÁ¬½ÓAccessʱ×ܱ¨ÕÒ²»µ½dbo.mdbµÄÎÊÌâ¡£¿ÉÊÇÎÒµÄÁ¬½Ó×Ö·û´®ÖÐÃ÷Ã÷д×Ålocal.mdb¡£µ¥²½¸ú×Ùµ÷ÊÔ·¢ÏÖConnectionÖеÄÁ¬½Ó×Ö·û´®Ò²ÊÇ”Provider=Microsoft.Jet.OLEDB.4.0; Data Source=local.mdb;”£¬¸ù±¾Ã»ÓÐdbo.mdbµÄÊ¡£ºóÀ´²é¹ýÅŲ鷢ÏÖÊÇschemaµÄÎÊÌâ¡£SQL ServerÖÐÓÐschemaµÄ¸ÅÄîËùÒÔÎÒÃÇÒ»°ã¶¼Ï°¹ß ......
¼ÙÉèNews±íÖÐÓÐÒ»¸öÊôÐÔPassed£¬Êý¾ÝÀàÐÍÊÇ“ÊÇ/·ñ“
1,¶Á²Ù×÷£ºstring str="select * from News where Passed=True";(access)¶Á“ÊÇ“²Ù×÷¡£
string str="select * from News where Passed=False";(access)¶Á“·ñ“²Ù×÷¡£
2,д²Ù×÷£º
string str="Delete from News wher ......
ÔÎÄ£ºhttp://www.cnblogs.com/whitetiger/archive/2007/03/27/689620.html
ÔÚBETA2ÖУ¬¡£NETÌṩÁËÒÔϵÄNAMESPACE£º
System.Data Namespace
System.Data.OleDb £¨ºÍBETA1ÖÐÒѾ²»Í¬ÁË£¬ËùÒÔÈç¹ûÄÃBETA1ÖеijÌÐòµ½BETA2ÖÐÀ´ÔËÐп϶¨²»¿ÉÒԵģ©
Èç¹ûÏë½²Çå³þÕâЩ¶«Î÷£¬ÎÒ²»ÈÏΪÊÇÎÒ¿ÉÒÔ×÷µ½µÄ£¬ËùÒÔÎÒÏëͨ¹ýһЩ¾ ......