InfoPath Dev

Hi there,  I was wondering if anyone new of anyway to remove characters from field names, perhaps using Xpath? When I use submit to sharepoint to save my form to a library I'm using fields that can contain ampersands and brackets.  Of course, these forms wont save with illegal characters.  The field that infopath is using to ...

It's just dawed on me that I'm using file names with illegal characters, hence the reason it's not saving and I'm receiving that error message.  

Hi,  When I use this technique I get the following error message maybe every 7 to 10 submits: InfoPath cannot submit the form. An error occurred while the form was being submitted. The form cannot be submitted to the following location: http://portal:1844/C5/C4/PRGMIS/PRG_Milestones/Access to H & F Education.xml The site may be offline, ...

Thanks Hilary, you're a gem.  That worked fine.   Paul

Hi Hilary, I know it's been while and I told you I'd let you know how I got on... I've just tried it and I get the error InfoPath cannot submit the form. An error occurred while the form was being submitted. The form cannot be submitted to the following location: ...

Hi There, There's something I'm unsure about I hope someone can help  As the heading says I have an InfoPath form, the data connections are to a SQL Server database.  I've set permissons on SQL Server mapped to Active Directory logins so people can access the data.  There are also InfoPath forms, developed by another ...

I can confirm that all data connections use the correct db and have the exact names and SQL statements and are identical to the 2008 forms.  I'm unsure why one form would suggest that the security priveledge is lesser than another form when it's retrieving info from the exact same place.  Can you think of anything else? it ...

Thanks for getting back to me Anuma  I'm pretty sure it's not a timeout as far as the db's concerned. both forms use the same db, each form library is located in the same sharepoint site and I can open the form. Obviously I have more permissions (dbownver), however, the fact that everyone can open the 2008 forms that use the same ...

Hi there,  I've got a problem I hope someone can help me with... I've published a InfoPath template to a SharePoint Library. The form uses data from a SQL Server database. These forms are for 2009. There are forms for 2008 which are identical, the only difference is that it's a new form library. The form library is still in the ...

Ah, I understand now, Thanks, that worked a treat  Paul