Re: How to copy access data

Patrick Halstead — Wed, 11 Nov 2009 11:39:22 GMT

Qdabra.com provides a free tool called qRules 1.8 that supports programmatically adding rows to a repeating section/table and copying rows from one table to another. So long as your form doesn't have code (and is using InfoPAth 2007) you should be able to use it.

good luck!

How to copy access data

wc19380 — Thu, 05 Nov 2009 18:57:51 GMT

Hello, We have developed a nifty little InfoPath front end to an Access Database to handle our Project Management tasks. It contains one header row, for the activity, with 4 repeating tables under it to provide more details. We have used the canned features of Infopath integrated with ACCESS and all is working very well. There is a feature we would like to add. To write a program to add a new row and copy the header(activity) and all the supporting repeating rows of each table to a new row. In today's world, I click "New Record" and manually copy and paste all the information from a saved report. Can anyone tell me how I could use a program to provide that new functionality. I would like to use xml to dynamically save all the data into memory. Add New Record, then read my saved xml into the new record(s). Any help would be greatly appreciated. We are using InfoPath 2007, Access 2007, & Visual Studio 2005. Thank You, Tom

Microsoft Access

Re: How to copy access data

How to copy access data