Online Connections

  Home | News
   MyAnswers | FAQ | Conditions


OpenOffice.org Data source

TIP: Use Control+F to search page.
Click on the item number to request solution.


Number

Question

Date
(dd/mm/yy)

Length



1369

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

15/08/05

2241

1151

Features missing in OpenOffice.org when using dBase files

01/01/05

2641

996

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

07/05/04

661

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

5362

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

4021

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

915

917

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

26/02/04

314

906

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

21/02/04

2108

898

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

19/02/04

1455

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

1054

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

1954

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

1243

890

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

18/02/04

1050

889

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

18/02/04

2067

883

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

13/02/04

938

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

822

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

578

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

617

781

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

16/12/03

828

777

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

12/12/03

210

726

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

11/03/03

291

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

2553

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

800

469

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

02/05/03

614

331

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

14/03/03

428




Please read the conditions of use
Copyright © 2002-2020 - Online Connections
A JustLocal™ advertiser