Create an XML form (copy the one I attached and edit the classes to meet
your needs (use Notepad).
Design a new blank InfoPath form
Insert a Drop Down List box
Open the properties for the List Box and select "Look up values in a data
connection..."
[Add]
XML Document
Browse and select the XML form created above.
When you get to "The selected file is not part of the form...", select
Yes
For Entries, select "Class"
Insert a Repeating Table with the number of fields you will need per person
(Name & class + 52 weeks? Or do you skip summer?)
Right click on the Text Box in the 2nd column of the table and select
"Change To Drop Down List Box".
Open the properties on this List Box and select "Look up values in a data
connection..."
For Entries, select "Class"
Select the tab at the bottom of the Repeating table, right click and open
properties.
Select the Display tab and click [Conditional Formatting] and [Add].
Set the condition: (where Field3 is the 2nd field in the table, Field1 is
the 1st List Box)
Field3 "is not equal to" Field1 And
Field1 "is not equal to" "All", And
Field1 "is not blank"
then select "Hide this control".
There is a lot of formatting and tweaking you can do to the table to amke it
look better but this gets you started for the structure of your colution.
(If you use the InfoPath form I sent, you will need to delete and re attach
the XML form after editing.)
If you have more specific questions, you can contact me at the address
below. Just remove the "online." part of the address.
--
Jerry Thomas[MSFT]
<
[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.
The Stovalls said:
That would indeed work & I would appreciate any help you could give me in
getting started!
Thanks
Brian
Why do you need to export to Excel?
You can do all of this in InfoPath.
Using a Repeating Table and some Conditional Formatting, you can view or
print all of the records, or just a single class.
The data can be exported to Excel if you have other systems already using
that data, but we can't really run InfoPath forms against Excel.
Would this work?
I'd be glad to help you get started.
--
Jerry Thomas[MSFT]
<
[email protected]>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.
The Stovalls said:
Hi everyone,
I am new to the group & am wanting to do some simple automation for our
church office with InfoPath! I have done some of the online tutorials, etc,
but still cannot quiet grasp the program. All I want to do is have a simple
form to fill out for the Sunday school classes to log their attendance, &
output that info into an Excel spreadsheet. I would then like to be able to
query that sheet with another form & print out a list of the classes, & who
was present for a given Sunday. It seems to me that it should be a fairly
simple project, but I am a hands-on type learner, & can't figure out where
exactly to start. If someone has a form already made up that could be
adapted to my application, I would greatly appreciate it if you would
consider sharing it so I can at least get started learning! Any help would
be greatly appreciated!!!!
Thanks
Brian
