1 Topic by gonpublic2012

(2 replies, posted in Script)

Since the excel report is an automatic option to export to that format, is there anyway to format its output on how the columns are displayed and that sort of thing?  (For example making the columns width according to the data contained in them ) I'm thinking maybe there's a way to add an event to the button like an 'On Click' and write the appropiate script to tell the action how the format of the spreadsheet will look like.   Any ideas?

Please help, appreciate it.

Go to forum: Script

2 Reply by gonpublic2012

(7 replies, posted in Script)

derek wrote:

Hello Gonpublic,
What you've described is certainly possible in MVD.
However, without knowing more about your project, your database design and the process flow, it's difficult to suggest options. 
My initial question is why you need the split across two forms if the additional actions information is to be saved to the same record (or is the additional actions information being stored in a related, one:many table)?
Could you attach a copy of your project?  That would help a lot.
Derek.

Thanks Derek,  I actually solved the problem by eliminating the emerging form (form 2 ) and just putting everything on Form1, creating two extra tables (action, status) and referecing them as dictionaries to the main table.  Works fine.  However, I have another question related to this, can I use 1 save button to save records on 2 different tables?  the first table will be for the records themselves, the second table being a kind of log for actions that had taken on a particular employee.  Sort of to look for a history of actions to display on a grid.  Sounds complicated?

Go to forum: Script