InfoPath Dev

Well, I'd try the query in Access first - My thought is that if you are actually copying a new DB file onto a machine, the create date may be the correct one. Not sure though. But then, you should be able to create a data connection in IP to Access, and select any table, and click the Edit SQL button, and replace with this.

Yes Hilary you are referring to the correct one. Where should I put that SQL statement? Is this being done within access or infopath? I've never used MSysObjects so this is a bit unfamiliar territory. Since I am doing date modified I assume I'd change DateCreate to DateLastModified.

is it possible to insert a picture into a browser form?  My customer, while completing the form, would like to insert a picture.  They do not want to attach the picture, but actual insert it into a form so when they convert to pdf, the image is in the form also.  If this can be done, how?    Chris

There is a DateCreate in the MSysObjects table - the entire DB file is being replaced / updated on a certain basis, do I remember your other questions correctly? So, if the whole DB is being replaced, I wonder if something like this: SELECT distinct CDate(Int(DateCreate)) AS CreateDate FROM MSysObjects Would work? I'm converting to Int then ...

I've discovered that it's because my form is not full trust. The only problem with that discovery is that it requires too much work to get the certificate to allow for full trust (you just have to believe me on that). Is there a way I can use the edit SQL in my data connection to have it display date last modified? It doesn't seem like ...

Is this a template for which forms have already been filled out?  If so, I wouldn't recommend changing your rich text field to regular text because that would most likely cause problems with opening the existing data.  If you do have existing forms and objective is to get rid of the rich text and use ordinary text instead, I would ...

Ah, I see - I misunderstood the scenario where they fail first semester but pass the second. I'll see what I can come up with.

In the sample form, if I fill it out with your sample data from your original post, it appears to exactly meet your requirements. Can you tell me how the formula is not working for your other scenarios?

Anyone have any ideas?

Hi- Sorry you've run into issues. The first thing I would recommend is to check the eventvwr on the machine where DBXL was installed. If there are any errors or warnings at the time of the installation, please let us know. Thank you.