Click link
to request

Question

Date
(dd/mm/yy)

Length

1369

How to connect to a Microsoft Access database using ODBC from OpenOffice.org.

15/08/05

2085

1151

Features missing in OpenOffice.org when using dBase files

01/01/05

2545

996

When I transfer an OpenOffice.org Form to another machine the background image is lost.

07/05/04

615

970

The following are the steps to install Sqlite so that it can be accessed from OpenOffice.org as a data source under Windows XP.

30/03/04

4812

931

Some issues we found when using text data sources with OpenOffice.org such as the ODBC text driver and the built in OpenOffice.org text data source type.

04/03/04

3855

918

When I enter a date criteria in the OpenOffice.org Query Designer such as 03/02/2003 it displays this as 03/02/2003 but it still works

26/02/04

870

917

With a column called Date the expression month(date) in the OpenOffice.org Query Designer does not work.

26/02/04

278

906

When selecting a record in the data source window the Find takes a long time. Is there a faster way?

21/02/04

1990

898

Why we chose the ODBC text driver for the OpenOffice.org data source rather than the built in text option.

19/02/04

1407

893

I use ODBC to connect to a text data source "extract.txt" in OpenOffice.org. The problem is I can't write any queries as the "extract.txt" in the query produces an error. What can I do?

18/02/04

1002

892

Can I change the definition for the width of a column from 3 charcters to 30 characters in a MS Access database using OpenOffice.org?

18/02/04

1801

891

How do I set the value of one column to the same as another column in an MS Access table using the OpenOffice.org Query Designer?

18/02/04

1091

890

Can I delete a column/field to a MS Access table using OpenOffice.org Query Designer?

18/02/04

918

889

Can I add a new column/field to a MS Access table using OpenOffice.org Query Designer?

18/02/04

1901

883

Example of the SQL statement to use in OpenOffice.org Query Designer to update an MS Access database field.

13/02/04

872

869

I have a data source which have numbers I would like to display the data in a mail merge with two decimal places. How do I do this?

29/01/04

774

868

OpenOffice.org can't handle values in a text file which might look like a date but are actually text. For example 1/5 Smith Street. If the 1/5 is in a separate column it is treated like a date.

23/01/04

550

862

I want to get a list of all the users email address from my MS Access data source for the one client to send all the users a notice. How do I do this?

16/01/04

569

781

In OpenOffice.org queries when should I use a back tick (`), a quote (') or a double quote (")?

16/12/03

766

777

How do we concatenate two fields with a comma in between, in a query against an MS Access ODBC datasource?

12/12/03

186

726

A fast way to open a form associated with a data source.

11/03/03

270

531

In MS Word I am used to doing a mail merge dynamically as I change the data. That is I update the data document using the Form entry and then I immediately merge. I can't seem to get access to updated data in OpenOffice.org data sources.

20/01/04

2354

530

I have a comma separated text file which I want to use as an OpenOffice.org data source. I keep getting the message that the comma cannot be used as it is used as the thousands separator. What should I do?

25/06/03

750

469

How can I share my Query in the data source with multiple users.

02/05/03

564

331

Limitation in using dBase files as a datasource in OpenOffice.org.

14/03/03

412