What is VBA
VBA is a programming language, programming language is system of statements that are used to control computer.
Accept store data manipulate produce output
Object Oreiented programming Properties methods Events
Access Object Model
Its absolutely huge, hundreds and thousandas of objects, also their huge properties and methods. Can read it in a book but better to look at in Access.
Its top level for instance of an Access.
Usefull properties in Current Application object.
1. CurrentDb DoCmd Forms SysCmd
DAvg, DCount DMax DMin DSum DVar DVarp DFirst DLast DLookup Quit
Whatever Ojbect that current has focus will be Me Object.
Active Control Active Control is field on the form in which user is currently type their data. AllowAddition, AllowDeletions, Allow Edits These properties define either to allow addition, deletion or edit. AllowFilters, Filter RecordSource ( Piece of table or query ) ScrollBars ( To hide or display ) Visible (to hide or show the object)
Refresh Repaint Requery Undo
Name (Name of form or Dable) QueryDefs ( look at created query) TableDefs (Look into type of data and other table properties.)
CreateQueryDef (Create Query) CreateTableDef (Create or Change the Dable Defination,) OpenRecordSet (Open query, table or link to outside)
Properties of OpenRecordSet BOF and EOF (to loop through an object to check when the task is done) Field is a record set NoMatch RecordCount
AddNew Close Delete Edit FindFirst, FindLast, FindNext, FindPrevious MoveFirst, MoveLast, MoveNext, MovePrevious