title: Data bind or Manipulate an Access Datasheet Using VBA Code
body: <p>I am using Access 2007 for a prototype application.I have a two database testUi.accdb (which </p>
  
  <p>contain all of my forms) and testDb.mdb (which contain my database).
  Now I want to use a datasheet in one of my subform. 
  Can anybody help me with these questions?</p>
  
  <ol>
  <li>Can I manually build a datasheet without table?</li>
  <li>How can i bind data with this datasheet using DAO or ADO by VBA Code</li>
  <li>Is it possible to loop a datasheet using VBA Code ?  get or set value for  each rows? </li>
  <li>If above are not possible then what are the alternate way
  to use datasheet like grid in Access?</li>
  </ol>