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/43403.aspxWed, 24 Jun 2009 13:30:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:43403warrtalon0https://www.infopathdev.com:443/forums/thread/43403.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=43403<p>Ian, I still feel the same way, and I believe others here do, too, but I don&#39;t speak for them.&nbsp; You have created an abomination that needs some serious attention.&nbsp; This cannot be fixed by asking for free help on a forum with all these different posts.&nbsp; We can&#39;t see the form, don&#39;t have the form template, and don&#39;t have first-hand knowledge of all the logic in the form.&nbsp; That makes it nearly impossible to &quot;fix&quot; it for you, because your problems aren&#39;t as simple as flipping a switch.</p> <p>It&#39;s not considerate to ask us to do your work for you.&nbsp; This is what most of us do for a living.&nbsp; Just my opinion, but I help people for free all day long almost 7-days-a-week, so for me to say this, I hope it has at least some weight or meaning.</p>https://www.infopathdev.com:443/forums/thread/43397.aspxWed, 24 Jun 2009 11:00:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:43397Ian Dawson0https://www.infopathdev.com:443/forums/thread/43397.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=43397<p>Hi, all concerned.</p> <p>I am again trying to wrap up this program (problem). I have one main screen, a severly modified printview (which I will delete) and another printview which I use to map data from the main screen into MS Access database. </p> <p>My problems are:=&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 &nbsp;I am mapping data from the main screen variables and hard coded text,&nbsp;into printline variables, that will then be exported into Word. I hope.</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2 The variables seem not to show any values until data is stored and saved into the database.<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I am seriously puzzled. I am loading up database variables by hand.</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 I am setting Main screen variables, pressing Save button, and most of the main screen variables are being reset.<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I think my&nbsp;initialising the variables as the first rule may have an impact.&nbsp; I am not sure if you can offer any help, But try if you can.</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4 The system is so loaded up with (InfoPath system) programming from all the rules and conditions loaded up for over 200 variables.<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Now that it can take up to 2 minutess to start, I have a one gig RAM.&nbsp; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QUESTION here - If i DELETE SOME VARIABLES in use, and the Print View,&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; will I regain some work space, and lower the complexity and load on the system?</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5 There have been so many writes and rewrites to the original system design. I last counted over 460 revisions over&nbsp;a month ago.&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I am having user mods to contend with, and the inability to direct export to Word with a Word print view function. <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Does the system keep building itself up?&nbsp; Or, should I create a new proejct and copy the final design, to minimise system load?</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6 I am getting runtime Infopath errors, with suggestions of variables for&nbsp;cause, that are not easily found. <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Is there a way of making all variable appear at the one time? Even those enclosed in Expression boxes!</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7 I have had some joy in copying variables into EXCEL and can then edit the variables data.<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This may be the course to follow.. Can you offer any other thoughts?</p> <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8 As another option, I am thinking of creating a separate Infopath form, to handle the Print View handling. <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; How do I conenect the database record open. Or, correctly reopen the databse record in&nbsp;use.<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; And that would also involve saving the record before calling the second program.&nbsp; Any thoughts there??</p> <p>Any questions, suggestion, or any help, is most welcome for the above.</p> <p>Ian&nbsp;</p>