InfoPath Dev

Try the qRules free trial - it's easy to do and you don't need CAML.

Does your form already query the database? Can you export the database file to an XML resource form and include in your form's template? If so, you should be able to do this without code. You can use rules and a count function to iteratively walk through from one date to another and add the value for each one. Check out Jo-Anne's recent ...

You should be able to run the form disconnected if the XSN has been cached (opened once on your local computer). Verify it has been opened at least once while it was connected. If that is the case, then check the data connections in the data connection wizard to ensure that the box to cache the data connections is set. I believe the default is ...

Hi Colecg and welcome to our forum, I'm going to ignore the fact that your solution seems overly fragmented and hard to maintain and just respond to your question .... Note: I'm assuming you are not using content types. Content Types could help you simplify the maintenance of your form templates (XSN) since publish once could update all ...

Hi Firouz, If you want to prevent them from deleting data in items within a repeating table there are several techniques: Disable inserts and deletes the table TODO> doube click repeating table blue button in the designer and under default settings uncheck allow inserts and deletes Pros: easy to do Cons: heavy-handed Make ...

Hi again, Thanks for the quick reply. It should be very easy to set this up based on the meta-data. Once you have a form with the metadata on it you can generate a bar code and a print view and print those bar codes to stick on the paper forms (as a reference check and for inventory location management). DBXL comes with search features. Once ...

Hi Melissa, Before I swing the bat, I have few questions: Does this database have existing data in it? Are there other processes that update the database? Do you have paper process today for gathering information? Hoe many distinct forms do you have? What do they look like? What kind of reporting do you need generate? What are ...

Hi Jeff, That's a limitation of InfoPath's schema inference logic. If you create your schema from a DB (not a best practice) it queries SQL for data type info. But, if you create your schema from XML, it has no clue what the data types are. You could load it as a secondary data source and copy the values over. Or, you could use a Web ...

Thanks for your patience. We hope to post the new build this week. Just need to finish verifying the fix ...

Hi Stuart, Thanks for your post. First of all, there is a bug in DBXL 2.4 Administration Tool that prevents "signed" forms from being correctly attached and saved. We are preparing a fix and hope to have it on the web site shortly. We will update this thread in the next week and also provide documentation. Sorry for the ...