1- Export to Excel works fine here. Writes to the same folder as the database, name=gridname.xls. We can examine why it doesn't work for you.2- To print with the HTML pane info, best is to do a template based HTML export. See this link:http://sqlnotes.wikispaces.com/Invoices

I have to be honest, I'm not really able to follow that wiki article about the invoices. For one thing, what is the fieldname for the HTML pane? In the Word template, how do I make it automatically construct the item I have selected and automatically include the children?

Basically, here is what I want to do: I want to create a generic export template where whatever I have selected in the grid of SQLNotes, the exported document will show that selected item and all of it's child items (properly indented) and also include any html pane text next to it. SO, I just select an item, export it, and the whole outline is reconstructed in word.

By the way, I am getting the grey box bug that Armando was talking about earlier again. it happens because my properties pane is on auto-hide, then when I mouse over to show it, and then it rolls back in, but the grey box still shows.

For a quick and easy printout with the HTML pane info, best is to:1- Add the HTML field to the grid (right-click on column heading, check ItemHTML field2- Select items to print3- HTML export, use the settings tab4- There are numerous options. Play around with them.

As for the grey panel, it is a bug in the menu toolkit I'm using. Update have been published. I'll update my version for the next release (0.9.22).

@Armando: Using MSWord as the HTML Editor is an excellent idea. Making a full featured editor is a big job which I'd like to postpone if I can. Preliminary test seem good. I can create a word document in a window and load text into it. Menus are OK too. Main thing left to fix: docked toolbars do not show.

I got this idea thinking of how Outlook 2003 offers the choice of using word as the email editor.

Will your "version" integrate MS Word's "engine" inside SQLNotes' interface (like SQLNotes original html' UI is part of SQLNotes, or like MS Word can be Outlook's email word processor) ? Or will Word and SQLNotes' UI and engine remain 2 very distinct BUT communicating entities?

Pierre, it seems like it's going to be *really* powerful... + no redundancy (well, in my case, since I'm using Word as my main Word Processor).

(Aren't there any restrictions with MS licenses, etc.?)

Also, for the above mentioned bug (Access violation at address 7C901010 in module 'ntdll.dll'. Read of address 0000004C). Could it be related to the Trident/IE engine? And so, would the gecko engine make a difference and... could it be used (unless that would involve licensing complexities + huge rewrites...)? I'm by no means an expert, of course...

I updated my SQL with the latest build, then I opened up my transcript grid and the information is not showing and I'm getting the following message: (see attachment in previous post)As far as I can tell, I have the correct filters and everything shown. In fact, I didn't change anything from the last time I had it working, so I don't know what I did.

Then, when I rename a grid, how do I know which checkbox is associated with that grid in cases where I want to include that grid's data into another grid?

Also, a weird thing has been happening with my HTML Pane content the last few days. The text inside appears in random places. Like, just now, I got the pane content I wrote in another grid show up in one of the items of my transcript grid. Something is buggy about it.

If you show the grid source bar, you'll see the source criteria. If it is a single field, then it's easy, you see items in that field, otherwise, it is all items which meet those criteria. From http://sqlnotes.wikispaces.com/Filtering :---------Source takes more than just an Property name, in fact its a filter also. Its the query that indicates what items are selected for the current Grid. For example, instead of just AddressBook you could put AddressBook and Archived is null to only show unarchived contacts.The reason why Source and Filter are kept separate is so you can keep the Source constant as you tweak the Filter as described above---------

Also, a weird thing has been happening with my HTML Pane content the last few days. The text inside appears in random places. Like, just now, I got the pane content I wrote in another grid show up in one of the items of my transcript grid. Something is buggy about it.

Also, a weird thing has been happening with my HTML Pane content the last few days. The text inside appears in random places. Like, just now, I got the pane content I wrote in another grid show up in one of the items of my transcript grid. Something is buggy about it.