Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bind Access Form Record Source at Runtime

Status
Not open for further replies.

canasta

Technical User
May 15, 2010
7
US
I am following the instructions in this link to Bind an Access Form's Record Source from an XML File at Runtime, but after creating the form and destination table, the results don't seem to be binding to the form, I'm getting a #Name? on the form results for every field. It seemed like a great way to overcome the problem where Access can import an XML (depending on file) into multiple tables but no ID to relate the tables together, but I'm not sure what I'm doing wrong. I haven't modified any part of the code they posted. Thanks.
 
Just a follow-up to see if anyone has ever tried this or has a way to import the xml and somehow create the ID field that's needed to tie all the tables together when you import a complex/nested xml file. Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top