Home  Fees/Services  Access Templates  Tutorials  Access Download  Articles  Search  Contact  Privacy  Links

DoCmd Examples - Access 2007 VBA
Find Record DoCmd

Docmd Macro VBA Example Macro DoCmd Functions



DoCmd AddMenu
DoCmd ApplyFilter
DoCmd CancelEvent
DoCmd Close
DoCmd CopyObject
DoCmd DeleteObject
DoCmd FindRecord
DoCmd FindNext
DoCmd GotoControl
DoCmd HourGlass
DoCmd Min/Max/Restore
DoCmd OpenForm
DoCmd OpenQuery
DoCmd OpenReport
DoCmd OutputTo
DoCmd RunSQL
DoCmd SendObject
DoCmd TransferDatabase
DoCmd TransferText

Create Export Specs



Docmd FindRecord Method in Access


The Access DoCmd.FindRecord method performs the Find Record action in Visual Basic. This command is often used in conjunction with the Docmd.FindNext. Below is show the FindRecord syntax and command line arguments:


DoCmd FindRecord Method

FindWhat: Required - an expression that evaluates to text, a number, or a date. This is where you put the information for which you want to search.

Match: Optional - AcFindMatch can be anyone of the following:

acAnywhere
acEntire     (default)
acStart

MatchCase: Enter True for a case-sensitive search and False for a search that is not case-sensitive. The default for this argument is False.

Search: Optional - AcSearchDirection can have any of the following values:

acDown
acSearchAll     (default)
acUp

SearchAsFormatted: Optional - use True to search for data as it is formatted and False to search for data as it is stored in the database. The default for this argument is False.

OnlyCurrentField: Optional - AcFindField. can have any of the following:

acAll
acCurrent     (default)

FindFirst: Optional - use True to start the search at the first record. Use False to start the search at the record following the current record. The default value for this argument is True.

Also see the Access Visual Basic FindFirst function for a recordsetclone.




Site Search:

Custom Search





Templates, Examples & Case Studies

Order Management Software

Inventory Management System

Interior Design Project Management Solution

Contact Management Database Application

Construction Project Management

Lease Contract Management

Livestock Feed Inventory

CRM/Customer Relationships Management

Order Processing System

PM/Preventive Maintenance

Work Order Software

Real Estate Marketing

Reservations Management

Asbestos Survey Management System

Document Revision Management

HOA Database Template

Loan Processing Management

Student Grant Management Software

Personnel Agency Database

Prescription Assistance Plan Management

Subscription Order Management Software

Corporate Document Management Application



Contact Information

Custom Software Developers
MS Access 2007 2003 2000 All Windows Versions