Access Function Access Function (VBA) Access Object Property (VBA)
This page lists all Access Method for VBA that have been explained in this website.
You may also want to read:
Differences among Function, Sub, Method, Property
DAO Method
[table width=”750″ colwidth=”150|600″ ]
Method, Description
OpenQuery, Run Query
QueryDef, Create Query
[/table]
DoCmd Method
[table width=”750″ colwidth=”150|600″ ]
Method, Description
OpenForm, Open Access Form
OutputTo, Export Access Objects
RunSQL, Run action queries
SendObject, Send email in Access VBA
TransferSpreadsheet, Import files or export Access Objects
TransferText, Import and export Access Objects to text file
[/table]
Dictionary Method
[table width=”750″ colwidth=”150|600″ ]
Method, Description
Add, Add Item to Dictionary
Count, Count number of Item in Dictionary
Exists, Check if Item already exists in Dictionary
Items, Return all Items in Dictionary
Keys, Return all Keys in Dictionary
Remove, Remove an Item in Dictionary
RemoveAll, Remove all Item in Dictionary
[/table]
FileSystemObject Method
[table width=”750″ colwidth=”150|600″ ]
Method, Description
CopyFile, Copy a file to another location
CopyFolder, Copy a folder to another location
CreateFolder, Create a folder in a location
DeleteFile, Delete a file in a location
DeleteFolder, Delete a folder in a location
FileExists, Check if a file exists in a location
FolderExists, Check if a folder exists in a location
GetFile, Return file Object
GetFileName, Return the name of file
GetFolder, Return folder Object
GetParentFolderName, Return the name of the parent folder of the last component in a specified path
GetSpecialFolder, Return the special folder object specified
MoveFile, Move a file to another location
MoveFolder, Move a folder to another location
[/table]