How to create report system with InfoPath?

[Panda]

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

 

[Adam Harding]

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?

 

[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?

"Adam Harding" <[email protected]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:

 

[Adam Harding]

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

 

[Panda]

Thank you very mach! It was usefull! Thank you!

"Adam Harding" <[email protected]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: