Open Tech Support
Open Tech Support Archives
Back to HomeCommunityReviewsGuidesDownloadsTech LinksMarketplaceContact Us
 »  SITE NAVIGATION
»  OTS Home
»  OTS Forums
»  OTS Archives

»  About our site
»  Search our site
»  Support our site

»  What is this site?
»  Who are we?
 
 
 »  ADVERTISMENT
 
  Pages: 1

ADO-Access-Database

(Click here to view the original thread with full colors/images)


Posted by: ADO-Nick

Hi All,

I am trying to use VBA to set a property defined by MS Access, which applies to an ADO object but isn't recognised by the Jet Database engine.

Help that I've found so far suggests that I must:

1) create the property
2) append it to the properties collection
3) then it can be set in the normal way

The property I'm trying to set is the "Required" property on a field (a number field) to "false"

Any suggestions, especially examples, of how it is done gratefully received!!!!

Nick Porter



 
Copyright 2000-2008 Open Tech Support.  All Rights Reserved.  Site Design and Development by Tolitz Rosel.