https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/33775.aspxMon, 03 Nov 2008 00:09:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:33775Clay Fox0https://www.infopathdev.com:443/forums/thread/33775.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=33775<p>InfoPath can do an offline form with dropdown and other validation aspects.</p> <p>&nbsp;Do you want to email a query directly to SQL?</p> <p>That could be trickier.</p> <p>Emailing the form to a local user or saving it and then submitting once online works great to send data directly to SQL via ODBC or web service.</p>https://www.infopathdev.com:443/forums/thread/33602.aspxTue, 28 Oct 2008 18:56:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:33602knottyrope0https://www.infopathdev.com:443/forums/thread/33602.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=33602<ol> <li> <div>Have read this and we tried this with access 2007 and outlook 2007&nbsp; <a href="http://office.microsoft.com/en-us/access/HA100154271033.aspx">http://office.microsoft.com/en-us/access/HA100154271033.aspx</a></div></li> <li> <div>Have issue with form is not too user&nbsp;friendly, no drop downs, have to spell out yes or no,</div></li> <li> <div>Front end designer is saying this will have issues when windows has another update we will have to make workarounds a lot.</div></li> <li> <div><span style="FONT-SIZE:10pt;FONT-FAMILY:Arial;">We want this: Salesman fill out a user-friendly&nbsp;form offline</span><span style="FONT-SIZE:10pt;FONT-FAMILY:Arial;">Send form via email when he can connect</span> <p class="MsoNormal" style="MARGIN:0in 0in 0pt;"><span style="FONT-SIZE:10pt;FONT-FAMILY:Arial;">Automatic entry of html fields&nbsp;into SQL 2005</span></p></div></li> <li> <div> <p class="MsoNormal" style="MARGIN:0in 0in 0pt;"><span style="FONT-SIZE:10pt;FONT-FAMILY:Arial;">Will info path make drop downs so we wont have null values? (this part is wreaking havoc on access runtime 2000)</span></p></div></li> <li> <div> <p class="MsoNormal" style="MARGIN:0in 0in 0pt;"><span style="FONT-SIZE:10pt;FONT-FAMILY:Arial;">Are the other solutions that you could recomend?</span></p></div></li></ol>