InfoPath Dev

Thanks Greg. The method you suggested is a permanent one. However, it is not necessary to be that. I also tried a wildcard query by Microsoft http://support.microsoft.com/kb/826992 This is the sql command in the above article, but it doesn't do the wildcard function. The query will only work when I give the exact words. strMySQLCommand = ...

How do I pull the records that have values? In Access, I can do: SELECT * FROM ABC WHERE ((Not (ABC.Comments)="blank")); This SQL Command will give me all records that have values in Comments field. How do I make it work via Infopath? Thanks.

Thanks, Matt. I solved this issue on the date picker by using substring-before() function, but not the dorp-down. No matter what I did, the drop-down always has the "T" stuff. Sicne the dorp-down carries a secondary data source, if I want to get rid of the "T00:00:00," I have to write code??

Thanks, Adam. I do not check off the checkbox "Update this value when the result of the formula is recalculated." It will cause me a lot of problems. The issue is when the data come back from the DB, the format becomes "2007-05-02T00:00:00," which doesn't allow me to do any comparison. I tried to format the date in DB ...

Hi Matt, Thanks, it works. However, it doesn't solve my problem. I set the rule under a dorp down. First it shows "2007-05-02T00:00:00" And after I click on the value, the value changes to "2007-05-02" By definition, "Use rules to apply actions when users change the value in this control." Indeed, there are two ...

Thanks, Matt. I got the data from a expression box, and it shows "2007-05-02T00:00:00" The way it will work out is to wirte code to get the date like "2007-05-02"  Is this what you recommend? The data set is from DB. How I can format it before it shows on the screen? Could you give me some references? Thanks.

Condition: if Case Date > today(), then disable submit button. It works fine. However, when I call the data back from the database, the submit button is disabled. If I pick the date again, it will become enabled. The disabled situation only occurs when Case date = today I have no idea why this is happening. Also, anything compares to today(), ...

Thanks for reply. Two forms are required. The screenshots you see are not for real. It's just my sample database. 

Thanks, nukkumatti. I did the same thing you did before. I copied the namespace from Salary form, but it generated error by saying duplicate definition. I must have done something wrong. Could you please tell me when I deal with namespace, what should I focus on to avoid such mistakes? Again, thank you very much. Troy 

I sent an email to you. I think you probably didn't notice it. If you can give me your email address, I can send you the sample I am working on. I think it's better. This is the data structure. It's kind of simple because this is just a sample database.