InfoPath Dev

Hi all Have written access queries to pull of all results falling between two dates using the dateadd function. When i connect these queries to my infopath form i want it to reutrn all results like it does in the select query, but it only returns the first result. I feel so close but so far and cannot get this to work. Anyone got any ...

Nope All i can think was that the somehow outlook got confused as it had two attachments named the same thing coming in and going out. In my latest version the name of the attachment is different and perhaps that helps? I'm from WALES adam.harding@ltsbasset.co.uk

Anyone hepl on this at all, please? I'm from WALES adam.harding@ltsbasset.co.uk

Hi Write a specific select query in your database and links its results to the form to pull up the results and hey presto, Job Done. I'm from WALES adam.harding@ltsbasset.co.uk

Good Job Pete I thought that might have been it just had the same problem with queryfields of my own to setup a username and login system to feed back into a projects database and produce reporting, luckily i had to only clear three fields first. Cheers Adam I'm from WALES adam.harding@ltsbasset.co.uk

Hi pete I am over the channel in Wales good to see someone from the UK on here. the button that goes from summary to detail need only define one field if you have a unique reference number for that record. It can query using that and display it in datafields on the detail view. Your button on the detail view should clear the reference number ...

Hi all Have written access queries to pull of all results falling between two dates using the dateadd function. When i connect these queries to my infopath form i want it to reutrn all results like it does in the select query, but it only returns the first result. I feel so close but so far and cannot get this to work. Anyone got any ...

Deleted the form and started again and now no problems so i guess that is the software equivalent of reboot. Works fine now

Hi Agni Deleted the form and started again and worked fine. Sorted Thanks for your help

Infopath uses a username and password to access the SQL database so it needs to have been told both of these to access it. Don't know if i understand the question properly but hope this helps