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
Ïà¹ØÎĵµ£º
public void ExportExcel(DataTable dtData, string filename)
{
System.Web.UI.WebControls.DataGrid dgExport = null;
// µ±Ç°¶Ô»°
Sy ......
untag¾ÍÊÇÆÕͨµÄethernet±¨ÎÄ£¬ÆÕͨPC»úµÄÍø¿¨ÊÇ¿ÉÒÔʶ±ðÕâÑùµÄ±¨ÎĽøÐÐͨѶ£»
tag±¨ÎĽṹµÄ±ä»¯ÊÇÔÚÔ´macµØÖ·ºÍÄ¿µÄmacµØÖ·Ö®ºó£¬¼ÓÉÏÁË4bytesµÄvlanÐÅÏ¢£¬Ò²¾ÍÊÇvlan tagÍ·£»Ò»°ãÀ´ËµÕâÑùµÄ±¨ÎÄÆÕͨPC»úµÄÍø¿¨ÊDz»ÄÜʶ±ðµÄ
ÏÂͼ˵Ã÷ÁË802.1Q·â×°tag±¨ÎÄÖ¡½á¹¹
´ø802.1QµÄÖ¡ÊÇÔÚ±ê×¼ÒÔÌ«ÍøÖ¡ÉϲåÈëÁË4¸ö×ֽڵıêʶ¡£Æä ......
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Practices.EnterpriseLibrary.Common;
us ......
Private Sub cmdListProperties_Click()
ListControlProps Me
End Sub
Public Sub ListControlProps(ByRef frm As Form)
Dim ctl As Control
Dim prp As Property
On Error GoTo props_err
For Each ctl In ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾ ......