InfoPath Dev

Filter it on the server with a data connection pointing to a view that is pre-filtered.  You can do this by making your default view filtered or by making other non-default views filtered and using the XML path to that view per this method: http://blogs.msdn.com/infopath/archive/2007/01/15/populating-form-data-from-sharepoint-list-views.aspx

There is another thread here talking about this, and Patrick Halstead answered with two possible solutions - one where you write the code yourself and another where you can just use their WSSP product, which doesn't cost much.

+1 to Hilary.  If your conditions are proper with PERFECT syntax, then this definitely will work.  You have to make sure that the values for your dropdown selections are EXACTLY the same as what you put in your conditions.  The DisplayName is not necessarily the same as the Value, and even if your DisplayNames are exactly the same ...

Well yeah...obviously, if you use "Cannot be blank," then it cannot EVER be blank.  That setting is not conditionally-based.  You need to turn that off and instead add data validation to that field that says "If RadioButton = AttachOption and AttachmentField is Empty (or blank maybe), display error."  This will ...

You're missing the condition to check for large or small.  Also, your small condition should not be and - it should be OR.  If you use AND, then users have to be in BOTH of those groups in order to edit the fields.  For small, it should be like this: If user's current role is not equal to "Local Facilitator" ...

There's nothing specific about WS08 that relates to Forms.  If your SharePoint site is built, then you can publish the form to it.  You should be putting the URL to your SharePoint site where you want the form to be used.  What happens when you do this? Since your people do not have InfoPath, which means they do not have ...

That's not a normal trick, so you probably need to speak to SYM Wong-a-Ton about it - the person whose blog you followed to build this.

Subtract 12 hours?

IP doesn't remember or care what view you were in when you saved it.  It always opens to the default view unless you tell it otherwise.  You tell it otherwise by setting rules in Tools > Form Options > Open and Save > Rules.  This will execute rules upon the form opening, and one of the actions is to switch view, which ...

I would avoid folders and instead use metadata with grouping to separate pending and completed.  This allows you to have them all in one place but still logically separated.