access 宏命令 - 达人(在海水中游泳)

2006/02/05 | access 宏命令
类别(数据库学习笔记) | 评论(0) | 阅读(1546) | 发表于 12:06: 筛选数据: ApplyFilter
移动记录或页: FindNext,FindRecord,GoToControl,GoToPage,GotoRecord
执行: RunCommand
Quit
OpenQuery RunCode RunMacro RunSQL
RunApp
CancelEvent Quit StopAllMacros StopMacro
导入导出: OutPutTo SendObject
与其他数据格式传送数据: TransferDataBase TransferSpreadsheet TransferText
对象处理: CopyObject Rename Save
删除对象: deleteObject
移动或调整窗体大小:Maximize Minimzie MoveSize Restore
打开或关闭对象: Close
OpenForm
OpenModule
OpenQuery
OpenReport
OpenTable
OpenDataAccess Page
OpenDiagram
OpenStoredProcedure
OpenView
打印对象 OpenForm
OpenQuery
OpenReport
OpenTable
OpenStoreProcedure
OpenView
PrintOut
选择对象 SelectObject
设置字段控件属性值 Setvalue
RepaintObject Requery ShowAllRecords
其他 addMenu
设置自定义菜单项: SetMenuItem
显示屏幕信息: Echo Hourglass MsgBox SetWarnings
产生键击 : SendKeys
显示或隐藏内置或自定义的命令栏: ShowToolbar
发出嘟声 Beep; 0