InfoPath Dev

It definitely needs the leading 0 for a date format type field. However, doing a little more experimentation and it seems that the concatination causes a problem as it converts the data to a text type which date won't accept. I haven't managed to convert it back to date successfully yet.

Are your day and month fields keeping (or adding) leading zeros if required? If the leading zero is dropped for the day or month then the field won't evaluate correctly.

 Hi All, I'm using an InfoPath email type form, in order to submit to a list in SharePoint I have created a web service with the Lists.asmx. I use the list GUID and an XML "batch" file to do the submit, but it can only submit plain text. Using this technique how can I submit data to a people picker field on my SharePoint list? ...

 You need to make sure that the date is the correct format, I am assuming it is all numbers and matches the format for date in SharePoint?

Hi Simon, Welcome to InfoPath Dev Forums. Is the Access database going to be loading onto SharePoint as a database? Also, do you want the forms to be browser based, or will everyone have copies of InfoPath Filler to use to fill out the forms? Regards, Steven

Hi All, Me again, becoming some what of a pain I am sure. Anyway, I use a SharePoint front-end with an Access database, the database tables are converted to lists on the SharePoint. When I update list forms which are linked to my database tables I have to remove any event macros on that table otherwise I get errors. Can anyone tell me a way ...

I did some further reading and it seems that it just changes where the filter is applied. Even though it seems a query filter would be applied at server level it doesn't seem to be, unless the field is indexed in SharePoint. This is a brilliant workaround. Just like to point out to anyone who reads this later on, you MUST index the columns on ...

Hi Hilary, Adding the Index to columns that I want to search on has worked, no other special requirements either which is PERFECT! Thank you for taking the time to reply, can't believe we had over looked this in the past. Regards, Steven

Hi Hilary,Thanks for the pointer. I can't create an Index column until 18:00 GMT, I'll have to wait and give it a go then let you know. Regards, Steve

 Hi All, I don't know if this is possible as a codeless solution, but here goes. I have a list which exceeds the SharePoint row limit, currently set at 5000 in my organisation. I need to draw data from this list into an InfoPath list form so that users can see the data. I've tried REST services and they work fine when the limit is ...