Can you upload a sample file that has had private information removed? When you press "post reply", under the white box there is a tab "Upload attachment" that will let you attach a file for us to look at.

If you make a change to the copied chart before saving, does the altered chart save correctly?

If not, could you upload a sample file (all private information removed) to demonstrate the issue?

SUMIF (wiki page) will do what you want.

Is there a possibility one of your suppliers would have multiple phone numbers or multiple addresses? If so, you may want to split those columns off into child tables. Ditto for the customers' phones, emails, and physical addresses. I'm not sure if the child tables for city, state, and zip will be h...

If you go to a different record, all the changes you made to the previous record will automatically be saved. If you 'save record', the changes will be saved without you having to change which record row you are on. Next record just goes to the next row in the table your form is based on. If you hav...

Have you tried adjusting the wait time before the .start()? If you change it to 7 seconds (7000), does it still crash?

Which line in the macro is highlighted when the crash occurs?

Tabs are a property of the "paragraph style" (different than "page styles"). Check out Andrew Pitonyak's book OpenOffice Macros Explained (available for free download on his website ), there is a section "Paragraph properties" with a table "Properties supported by ...

Licensing-wise you'd be fine, commercial use is allowed. I don't think the community would care. I'm not sure Impress has all the functionality you were using with PowerPoint, you would have to work on it and see.

If you are comfortable writing code, I think it could be done. You would write a macro, save it in the template, and set it up under Tools→Customize→Events→Save Document & Save Document As→Assign macro. The action of the macro would be to open the totaling spreadsheet (probably 'hidden'), check ...

I don't think it is the localhost that caused this error. It just happened to me (checkpoint defrag setting all dates to two days 1970), and running the shutdown .bat file WITH the localhost instead of the IP (and then restarting) fixed the problem. Maybe it's something about running the defrag comm...

I think the OpenOffice "master password" option is for connecting to websites (e.g. if you have a stock spreadsheet that connects to a broker site to download the latest stock information). I don't think that is applicable to securing documents local to your machine. If you go into Tools→O...

And everything looks correct in the Writer file? Have you tried a different printer, or a pdf printer?

Are you mail merging into a Writer file? How many pages of labels are there?

Thank you very much for explaining that! You are absolutely correct about the 1.8 query taking a long time if Closed orders are included. The LEFT JOIN didn't help, but putting the filter for 'Open' status into a subquery sped things up to the expected runtime: SELECT "OrderNum" FROM (SELE...

Here is the execution plan for the 1.8 query that runs in a few seconds: org.hsqldb.Select@17eb767[ isDistintSelect=[false] isGrouped=[false] isAggregated=[false] columns=[ COLUMN ViewOfOrderStatusHist.OrderNum ] tableFilters=[ [ org.hsqldb.TableFilter@3b014c table=[SYSTEM_SUBQUERY] alias=[ViewOfOrd...

With just 50 rows you can manually edit the table: double-click on it to open the table, and type the new ID numbers in like a spreadsheet. Be aware that at no time can your table ever have two rows with the same ID. So if you start with row 0 and try to change it to 50, it will give you an error me...

Execution plan for the 2.4 query that takes 3 minutes: isDistintSelect=[false] isGrouped=[false] isAggregated=[false] columns=[ COLUMN: PUBLIC."ViewOfOrderStatusHist"."OrderNum" nullable ] [range variable 1 join type=INNER table=FilterOrderHistory cardinality=13 access=INDEX PRED...

What you want to do either requires learning a programming language to manipulate the spreadsheet, or learning Base. (Yes, Base cuts it for what you are asking for, the learning curve is just very steep.) Maintaining information on a lined sheet after the master is deleted, and manipulating the link...

I am looking at migrating a split, multi-user database from HSQLDB 1.8 to HSQLDB 2.4. I have quickly run into an issue, however: a commonly run query that takes a couple of seconds in 1.8 is taking about 3 minutes in 2.4. The query for 1.8: SELECT "OrderNum" FROM "ViewOfOrderStatusHis...

It sounds like your file was corrupted. If you have a backup system, that would be the best-case to recover your work.

Otherwise, you might look into file recovery programs such as Recuva.

Can you upload your file, or an example file with any private information removed? If you press the "PostReply" button, under the text box there is an "Upload attachment" form.

The default database engine that comes with Base is an old version of Hyper-SQL DataBase (HSQLDB) that is not internet-accessible. Base itself is not particularly user-friendly, but it is doable for persistant users, and generally worthwhile for small projects where paying for a professional program...

there are no entries in "IN" There is your explanation. SUM of a NULL value is NULL. 100 - NULL = NULL If your table has at least one entry and A or B values (or both) have the possibility of being NULL you need to use COALESCE as Villeroy posted for you earlier. If the table might be emp...

You can have both "SoldDate" and "SoldTo" columns in the inventory table. To look up all machines sold to a particular customer by CustomerID: SELECT * FROM "Inventory" WHERE "SoldTo" = 5 or by CustomerName: SELECT * FROM "Inventory" INNER JOIN "...

The query you posted gives me a syntax error and will not run. This: gives the expected result.

Are you using a different backend than the default HSQLDB? What query are you actually running (since the posted one won't compile)?

Sure, if you learn how to program macros that execute SQL code. It's a bit of a steep learning curve for the benefit, though. Why not instead have a column in your inventory table named "Sold" that stores the sell date? Then to check your current inventory you run the query SELECT * FROM &...

Is this a snippet from a larger query? There might be some type conversion going on that's not obvious from the snippet.

Also, just to check, what are the field types of A and B?

Maybe this is what you are looking for?

There are more detailed directions in this thread: [Tutorial] Standalone Forms / Switchboard