Microsoft Access Sample Code | Using DAO | Data Access Objects

DAO (Data Access Objects) are APIs that give you the ability to write applications that are independent of any particular database management system (DBMS). In other words, DAO is a programming interface that allows you to communicate with data objects in your database using VBA code. This type of interaction can be very powerful and provide you some great flexibility in your Access Database. In order to use DAO, you must set a reference to it in your Access Application. The screen show below shows a project that has a properly setup reference to DAO:

After setting the reference, you can than use the DAO objects to interact with Data in your database and other databases depending on your connection setting. Note, the sample code below is just a sample and will not work in your Application unless certain changes are made to work specifically with your data objects.

Public Sub doDAO() On Error GoTo doDAOErr Dim myData As Recordset Dim db As DAO.Database Set db = CurrentDb Set myData = db.OpenRecordset("Select * From tblYourTable") If Not myData.EOF Then With myData Do Until .EOF txtField = !DataBaseField1 .MoveNext Loop End With End If myData.Close Set db = Nothing doDAOExit: Exit Sub doDAOErr: MsgBox Err.Description, vbOKOnly, Err.Source & ":" & Err.Number Resume doDAOExit End Sub

The Microsoft Access DAO Database is a sample database that shows you a number of ways to use the the above function.

Please note that this is a template database. If it doesn't meet your needs 100% and you're unable to customize it yourself, let us know and we'll provide a quote to develop the customizations you need to get you exactly what you want in your DAO System.

Main Menu

Main Form - Form Criteria

Main Menu Form

Main Menu - Form Criteria

Main Menu Form

Main Menu - Form Criteria

Main Menu Form

Main Menu - Form Criteria

Main Menu Form

Main Menu - Modern Look (Access 2010/2013)

Previous Next

Live Demonstration: To experience a more interactive and personalized demonstration of this WSI template, we invite you to contact WSI and schedule a live demonstration with one of our team members. This opportunity allows you to engage directly with us, either as an alternative to or in conjunction with downloading and exploring the demo version of the template at your leisure. Please note that downloading Microsoft Office files, including Microsoft Access database files, might trigger a security warning on your computer. To avoid this and get a comprehensive overview, you have the option of viewing the template through a virtual meeting on Teams or Zoom with a WSI representative.
Once you purchase the database template, you will receive the full version of the database in a standard Access Database file. The purchased database will have full access to the database window, all design objects, the visual basic project code, and you will be able to modify or add to the design in any way you wish (this does not apply to the run-time/compiled versions). If you lack the time to integrate this database into your system, please Contact Us and we will be glad to help with your integration process. If you like the basics of what you see in the database, but need enhancements to make the system functional for your business, please Contact Us and we will develop a quote for you to implement the additional features and enhancements that you require.

$19.99 - this allows you to use this database template however you wish within your organization.

$39.99 - for unlimited developer use - this allows you to use this database template however you wish for any applications you develop and distribute.