"We have been very pleased with the competent, prompt and courteous service they have provided to us."

Stu Perlman
Monarch/USESI (New Jersey)

Microsoft Access Sample Code

Function for using DAO (Data Access Objects)

Iowa Headquarters
(MIDWEST)
103 E. 6th St., Suite 101
P.O. Box 726
Ames, Iowa 50010
Tel: (515) 239-9900
Fax: (515) 239-9800
Skype™

Driving Directions to the Ames Iowa Headquarters
Florida Headquarters
(Southeast)
4200 Evans Ave., Suite 10
Fort Myers, Florida 33901
Tel: (239) 267-2749
Fax: (239) 267-9936
Caribbean & Latin America
(Puerto Rico)
Tel: (787) 303-0042
South Dakota - Sioux Falls
Tel: (605) 496-9580
Texas - Austin
Tel: (512) 593-1056
New Mexico - Albuquerque
Tel: (505) 289-1364
Iowa/Illinois - Quad Cities/Muscatine
Tel: (563) 316-2378
North Carolina - Asheville
Tel: (828) 278-2323
Want quick Answers?
During normal business hours you can reach us via our live chat program.  Try it, it's really cool!!
 
Click Here To Chat With Us Now Live!!
Disclaimer
Winning Solutions Inc. is an independent service provider for THIRD PARTY PRODUCTS where WSI provides support on remote, chat and over the phone basis for issues related to computer software. All other trademarks, registered trademarks, company names, product names and brand names for the third party trademarks are the property of their respective owners, and WSI disclaims any ownership , right , affiliation or endorsement of or by any such third party. The use of any third party trademarks, logos or brand names is for informational purposes only.

Microsoft Access Sample Code

Function for 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.

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.

Sample Screens



Download a demo

Having problems getting the code to work for you - then try out the demo to see if the demo works for you.

Download a demo version for free to try out. The demo version is in Access 2007 which will work on either Access 2007, 2010, 2013 or 2016. If you need a previous version of Access to tryout, please Contact Us. Please note that the demo version of the software is fully functional but doesn't allow you to see the code implementation - the full version allows you to design the code implementation and tweak it for your needs.

Access 2007 Download
Access 2010/2013/2016 Download
Access 2010 64 Bit Download
Access 2013/2016 64 Bit Download

The full version of the database is a standard Access Database file. You 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 that you wish. If you lack the time to integrate this database into your system, please Contact Us and we'll be glad to help. If you like the basics of what you see, but need enhancements to make the system functional for you, please Contact Us and we'll develop a quote for you to implement the additional features and enhancements that you need.

Purchase Price

$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.

Once your purchase is complete - you will receive an email with a link to download the full version of the database.

If you need any help implementing this function or modifications made for your needs, please Click Here to get a free quote for your Microsoft Access Development needs. 

Click Here to learn more about the WSI quoting process.