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
Ïà¹ØÎĵµ£º
×ªÔØµØÖ·£ºhttp://hi.baidu.com/mbaba/blog/item/39dc8b58d41191dc9c8204c8.html
ºÜ¶àÅóÓÑËäÈ»°²×°ºÃÁËmysqlµ«È´²»ÖªÈçºÎʹÓÃËü¡£ÔÚÕâÆªÎÄÕÂÖÐÎÒÃǾʹÓÁ¬½ÓMYSQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ôö¼ÓÓû§µÈ·½ÃæÀ´Ñ§Ï°Ò»Ð©MYSQLµÄ³£ÓÃÃüÁî¡£
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡ ......
<?php
/*
* Created on 2008-10-25
*
* developer by Alex.do QQ:20779512
* PHP 5.0
*/
class mdbClass {
var $dbPath = 'database/#123123#.mdb'; //Êý¾Ý¿â·¾¶
var $tabName; & ......
ÔÎÄ£ºhttp://www.cnblogs.com/whitetiger/archive/2007/03/27/689620.html
ÔÚBETA2ÖУ¬¡£NETÌṩÁËÒÔϵÄNAMESPACE£º
System.Data Namespace
System.Data.OleDb £¨ºÍBETA1ÖÐÒѾ²»Í¬ÁË£¬ËùÒÔÈç¹ûÄÃBETA1ÖеijÌÐòµ½BETA2ÖÐÀ´ÔËÐп϶¨²»¿ÉÒԵģ©
Èç¹ûÏë½²Çå³þÕâЩ¶«Î÷£¬ÎÒ²»ÈÏΪÊÇÎÒ¿ÉÒÔ×÷µ½µÄ£¬ËùÒÔÎÒÏëͨ¹ýһЩ¾ ......
Visual BasicÓÐ×ÅÇ¿´óµÄÊý¾Ý¿â´æÈ¡ÄÜÁ¦£¬²»½öÄܹ»Ö±½ÓÖ§³ÖMs AccessÊý¾Ý¿â£¬¶øÇÒͨ¹ýÆäÄÚ²¿°²×°µÄISAMÇý¶¯³ÌÐòʹËüÄܼä½ÓÖ§³ÖFoxPro¡¢dBASEµÈÍâÀ´Êý¾Ý¿â¡£±¾ÎIJ»½ö´ÓVBÊý¾Ý¿âÌåϵ½á¹¹µÄ½Ç¶È̽Ë÷ÁËVB¶ÔÕâЩÍâÀ´Êý¾Ý¿âµÄÖ§³Ö£¬»¹½áºÏÁËһЩʵÀý¾ßÌå²ûÊöÁËʹÓÃÊý¾Ý¿â´æÈ¡¶ÔÏó±äÁ¿µÄ·½·¨ÊµÏÖÕâЩÍâÀ´Êý¾Ý¿âµÄн¨¡¢¿â½á¹¹Ð޸ġ¢ ......
½ñÌìupdate accessÊý¾Ý¿âʱ£¬Ê¹ÓÃÁ˲ÎÊý»¯µÄ·½Ê½£¬½á¹û²»±¨´í£¬µ«ÊÇÊý¾ÝҲûÓиüС£¾¹ýgoogle·¢ÏÖaccessʹÓòÎÊý»¯Ê±£¬²ÎÊýλÖñØÐëºÍ¸³ÖµË³ÐòÏàͬ²ÅÐУ¬·ñÔò¸üÐÂʱ¾Í»á³öÏÖÊý¾ÝÎÞ·¨¸üе«ÊÇÒ²²»±¨´íµÄ¹ÖÏÖÏó¡£
ÀýÈç:update tablename set [a]=@a,[b]=@b ......