 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / August 2005How to create report system with InfoPath?
Hello world~! I work on report system of the bank. My bank have many branches, so I have to collect many simple reports. Today I collect all reports using Excel tables as input data source and Access database as collecting system (for example: I collect rates of exchange, thay are different in each breanch. Then I calculate the averege rate of exchange). The Excel table of each branch is a same with only difference in rates and branches name (code). So when they send me Excel tables I can collect each row and calculate them all in Excel or Access. I prefer Access, because I need a history on each day. So now I starting learn the InfoPath and trying to do the same reporting system in the XML + Access way. But for now I have some questions: 1. How can I access to the XML from MS Access, and how can I recognize the data using VBA? 2. Are there any standart data access protocols or VBA scripts? 3. May be I'm on a wrong way and you can direct me where can I read any same examples? Thank you! Panda Big questions Instead of answering them can i offer a solution that is slightly different. Get the branches to fill in an Infopath form that validates their entries against their branch etc. then have this form push its data back into an access database automatically! You can then use Access to report on the data VERY simply. Would this be enough? > Hello world~! > [quoted text clipped - 18 lines] > Thank you! > Panda Thank you for your answer Adam, but I can't create even a simple form connecten to Access. Can your describe it step-by-step, if it's easy? Just main steps? How ever? > Big questions > [quoted text clipped - 36 lines] >> Thank you! >> Panda Panda Go to http://office.microsoft.com/training/training.aspx?AssetID=RC011879111033 for a complete step-by-step guide of how to connect an access dbase to infopath what the benefits are etc, etc, Put simply you have to create a new blank form, select from a data connection, browse to your dbase add the tables in a 'relationship' format bearing in mind 3 or 4 caveats. Infopath cannot use long data types. maximum size for any filed directly from access is 255 characters. This can be worked around using a web service but you need .NET etc. To sumbit to the database EVERY table has to have a KEY FIELD or infopath can't find it to submit to. Infopath CAN do all the sums and AVERAGE etc. The article above is VERY GOOD and is very detailed. There are other shorter versions of the answer but this is the best. Enjoy. Adam > Thank you for your answer Adam, but I can't create even a simple form > connecten to Access. Can your describe it step-by-step, if it's easy? Just [quoted text clipped - 40 lines] > >> Thank you! > >> Panda Thank you very mach! It was usefull! Thank you! > Panda > [quoted text clipped - 77 lines] >> >> Thank you! >> >> Panda |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.