InfoPath Dev

samdany10, I did this a ways back so I don't really recall the situation. But I'm pretty sure Hilary's answer was what I added. I think I thought I had applied to the filter when I clearly hadn't. Hope that helps.

When someone publishes a form, can the users move the form to a different location? I am publishing a form to a shared drive. I want the users to then be able to copy the file to their local computer. Currently, there is a domain security level warning when the users attempt to fill out the form after doing so. So if the user wants to access the ...

Solved I changed my equation to: substring-before(@UpdateDate[@Name = "Date Last Modified"], "T")

I think I've pretty much figured it out so I will lay out the steps here. 1. I made the Access Query SELECT MSysObjects.DateCreate, CDate(Int(DateUpdate)) AS UpdateDate, MSysObjects.Name, MSysObjects.Type FROM MSysObjects; 2. Created a data connected in InfoPath with the Date Last Modified (the query I created) 3. Inserted a ...

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.

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 ...

Anyone have any ideas?

I have created a load event within InfoPath using vbs. My issue is that the code executes fine when I open it in preview mode from the design window. However, I attempt to fill out the form, as the users will, the event does not occur. I don't know if it is worth noting, but when I preview the form I get a dialog box that says "An ActiveX ...

Hilary was right. For some reason on with a load event you can't close an application through script. I'm sure there is a reason for it. I found this site that provides events that don't work in the load event if anyone is interested: http://msdn.microsoft.com/en-us/library/microsoft.office.infopath.formevents.loading(v=office.11).aspx

I don't get any errors. I'd prefer the loading event that way it will close the form if it loads with an invalid database. I'm also using IP2003 with vbs if that matters. If I can't do it in the load event, I'll just have to live with it.