InfoPath Dev

I get Excel files from web submission data exchange with date&time stamp as file names. The length of the file names is always 24 characters long with first part being date, second part time with AM and PM and then filler, connected with “_”. In regards to date extraction, it gives me four different types. I need to input the file name in ...

Hello Skarn, Thanks for taking time to make a sample for me. Much appreciated. In fact, I have done it by adding rules in nodes. Thanks again.

Hi - I have solved the issue with minor tweak. I needed the button to pop up Save As dialogue box all the time. I thought someone might be benefitted from my codes which are done on IP 2007 connected to Access db. Thanks, Ash  SaveFileDialog saveas = new SaveFileDialog();saveas.AddExtension = true; saveas.DefaultExt = ...

Hi Renato, Thanks for posting your solution code. I'm in a similar situation where I need to add a button that will pop up a window for Save As. Mine is in InfoPath 2007 full trust connected to Access db. For some reasons, DocActionEvent is not supporting. It's driving me nuts. Any help would be highly appreciated? Thanks for your help in ...

Thanks a million - Hilary. It seems it's working now. I might have to tweak a bit. In fact, I tried with "Data Source=db.accdb" alone. Now I have added the source file and apparently, it's working. Let me see more in it.  Thanks again for the valuable suggestions. Much appreciated. Ash

Hi Hilary, Thanks for your quick reply. Let me give you more details of the situation. I have an Access 2007 db in a network location accessible by the users. Say for example, both the InfoPath 2007 form and Access db are located in a folder called "temp" and the path is like "G:\CORR\form\temp". I found the complete path in ...

Hi Everyone, My form is connected to an Access db. I found in the mainfest.xsf file (in source files) that the connection is hard coded. It means, it has used a full path including drive letter of the database file e.g. H:\CORR\form\temp1\db.accdb. (I think, I can get rid of drive letter issue by using server path - nto sure though). My form and ...

Hi Gaurav, Recently, I have finished a large project with InfoPath connected to Access db with many tables (21 complex tables with more than 1,000 nodes in total). In one of the forms had similar connection where I ran a query using the data connection and updated the data fields by clicking the submit button. There shouldn't be any problem. ...

Hi There, Hope you've already done it by this time. Here is my solution to export to Excel by clicking a button for one of my query forms. If you have query, please let me know. Thanka, AshXPathNavigator DOM = DataSources["qYear"].CreateNavigator(); string qyear = ...

Hi, I am creating a query form connected to Access db. There are 3 query fields in my form e.g. Year, Program, Period - all are numeric values and last two have different display names. I can only select one or all values of each field. Say for example, Period has got 2 values - 1 for Semi Annual and 2 for Annual. In my query, if I ...