VBA Brush Up
关注
分享
扫一扫
文章平均质量分 59
slowgrace
♫ 西西雍雍
展开
-
VBA Brush Up 01：Procedures and Modules
Technorati 标签: procedures modules来自：Julitta Korol，“Access.2003.Programming.by.Example.with.VBA.XML.and.ASP”，by Wordware Publishing, Inc. 2005, p3-p11有关过程： procedure是instructions的集合。翻译 2008-10-03 12:10:00 · 670 阅读 · 0 评论 -
VBA Brush Up 12：Setting Up Indexes and Table Relationships with ADO
Technorati 标签: relationship,Access,vba,index,ADO来自：Julitta Korol, "Access.2003.Programming.by.Example.with.VBA.XML.and.ASP", by Wordware Publishing, Inc. 2005, p212-p220（1）A primary key is an inde转载 2008-12-07 16:08:00 · 913 阅读 · 0 评论 -
VBA Brush Up 11：Creating and Accessing Tables and Fields with ADO
Technorati 标签: VBA,ADO,table, error handler来自：Julitta Korol，“Access.2003.Programming.by.Example.with.VBA.XML.and.ASP”，by Wordware Publishing, Inc. 2005, p194-p211In this chapter you will use the A转载 2008-12-04 20:46:00 · 1779 阅读 · 0 评论 -
VBA Brush Up 10：Accessing Data Using ADO
Technorati 标签: VBA,ADO来自：Julitta Korol，“Access.2003.Programming.by.Example.with.VBA.XML.and.ASP”，by Wordware Publishing, Inc. 2005, p169-p193（1）ActiveX Data Objects (ADO) is a set of programming o转载 2008-12-03 11:01:00 · 1430 阅读 · 0 评论 -
VBA Brush Up 08：Custom Collections and Class
Technorati 标签: VBA,Collection,class,customclass来自：Julitta Korol，“Access.2003.Programming.by.Example.with.VBA.XML.and.ASP”，by Wordware Publishing, Inc. 2005, p102-p141（1）Event — An action recognize转载 2008-12-01 12:17:00 · 1094 阅读 · 0 评论 -
VBA Brush Up 09：Debugging VBA Procedures and Handling Errors
Technorati 标签: VBA,debug,error-trapping,watch,local,step into it来自：Julitta Korol，“Access.2003.Programming.by.Example.with.VBA.XML.and.ASP”，by Wordware Publishing, Inc. 2005, p142-p168（1）VBA offers转载 2008-12-02 20:32:00 · 1095 阅读 · 0 评论 -
VBA Brush Up 07：Working with Arrays
Technorati 标签: VBA,array（1）If you want to store values of different data types in the same array, you must declare the array as Variant. Dim exchange(5, 3) As Variant（2）If you’d rather st转载 2008-11-23 10:06:00 · 1056 阅读 · 0 评论 -
VBA Brush Up 06：Repeating Actions in VBA
Technorati 标签: VBA,loop,for,while,do来自：Julitta Korol，“Access.2003.Programming.by.Example.with.VBA.XML.and.ASP”，by Wordware Publishing, Inc. 2005, p91-p101（1）Using the Do…While LoopDo While c转载 2008-11-22 17:40:00 · 740 阅读 · 0 评论 -
VBA Brush Up 05：Decision Making with VBA
Technorati 标签: VBA,if then,select case来自：Julitta Korol，“Access.2003.Programming.by.Example.with.VBA.XML.and.ASP”，by Wordware Publishing, Inc. 2005, p76-p90（1）if then结构：单行的不需要end if，多行的需要；单行的如果需要执行转载 2008-11-21 07:41:00 · 630 阅读 · 0 评论 -
有关InputBox
Technorati 标签: InputBox,VBA来自：Julitta Korol，“Access.2003.Programming.by.Example.with.VBA.XML.and.ASP”，by Wordware Publishing, Inc. 2005, p67-p69The InputBox function displays a dialog box with转载 2008-10-06 02:08:00 · 559 阅读 · 0 评论 -
生成文件和写文件
来自：Julitta Korol，“Access.2003.Programming.by.Example.with.VBA.XML.and.ASP”，by Wordware Publishing, Inc. 2005, p186Technorati 标签: createtextfile,writeline,vba,adoADO does not have a special me转载 2008-10-05 12:06:00 · 571 阅读 · 0 评论 -
VBA Brush Up 03：Variables Data Types And Constant
来自：Julitta Korol，“Access.2003.Programming.by.Example.with.VBA.XML.and.ASP”，by Wordware Publishing, Inc. 2005, p28-p51, p69-p71Technorati 标签: constants,variables,data types,vba,type conversio转载 2008-10-04 22:32:00 · 1726 阅读 · 0 评论 -
VBA Brush Up 04：Passing Arguments to Procedures and Functions
来自：Julitta Korol，“Access.2003.Programming.by.Example.with.VBA.XML.and.ASP”，by Wordware Publishing, Inc. 2005, p52-p75Technorati 标签: byval,byref,argument,parameter,call,ismissing,optional,VBA转载 2008-10-05 11:28:00 · 794 阅读 · 0 评论 -
VBA Brush Up 02：The Visual Basic Editor (VBE)
Technorati 标签: VBE,VBA 来自：Julitta Korol，“Access.2003.Programming.by.Example.with.VBA.XML.and.ASP”，by Wordware Publishing, Inc. 2005, p12-p27Alt+F11可直接进入VBE 在VBE下修改窗体控件属性的方法： 先在projec翻译 2008-10-03 13:34:00 · 640 阅读 · 0 评论 -
在数据表形式的ACCESS窗体中将光标移到指定记录
在数据表形式的ACCESS窗体中将光标移到指定记录，用FindFirst方法如下：Me.Recordset.FindFirst "id=30"原创 2012-03-21 19:50:14 · 4635 阅读 · 1 评论