[users] Base/linking to an Access back end

2011-12-16 Thread Jeremy Browne
I've had two big, time-consuming problems - one I think I've solved, and the other I haven't. At first my Base tables wouldn't add a new record to most of my Access tables. After lots of trial and error I realised that the presence of a hyperlink field and/or a memo field in the Access table wa

[users] [Base] Text entry fields in forms

2011-11-05 Thread Robin Szemeti
Using OOo 3.2.1 on linux, 3.3.x on Windows, LibreOffice 3.4.3 on Windows XP, With MySQL native connector, Fields in forms with 0 for "Max. text length" property shoudl in theory not limit the input .. (or maybe limit it to lenght of the db field?) I have found they consistently limit it to much

[users] Base as desktop Database

2011-07-20 Thread Eduard Filipas
hi i been looking around and i can find several odbc ways to connect diffrent databases to OO.Base..but cant find article how to establish odbc connection from my executable to OO.Base. Is it possible for OO.Base to act as desktop database server ? i have small aplication in mind .. -- -

[users] Base crash near every day

2011-04-21 Thread Eduardo Quinteros
Dear Fellows Near every day since the last 2 versions of Oppen Office I lost my data in Base. I have a database with one table of about 2000 rows, each one of 35 columns . I read in it every day 1-6 new records ,nore more. But time to time before,

[users] Base Field.

2011-03-31 Thread Jay Taunton
Can anyone tell me how to make a Base field return an automatic number. My numeric fields are Beginning Balance, Deposit, Withdrawal, and End Balance. I want End Balance to automatically return the value of Beginning Balance + Deposit - Withdrawal. I have sent this before. Can anyone help me. T

Re: [users] Base - How to print envelopes or labels?

2010-10-08 Thread Drew
On Fri, 2010-10-08 at 14:28 -0500, DnL wrote: > I created a simple database for addresses using BASE that seems to do > the job. However, I have been unable to come up with a way to print an > address on an envelope (or labels). I tried a Form, and it printed in > the correct place on an envel

[users] Base - How to print envelopes or labels?

2010-10-08 Thread DnL
I created a simple database for addresses using BASE that seems to do the job. However, I have been unable to come up with a way to print an address on an envelope (or labels). I tried a Form, and it printed in the correct place on an envelope, but printed the color background as well as the

Re: [users] Base question

2010-09-01 Thread Drew
On Wed, 2010-09-01 at 14:20 +0800, James Elliott wrote: > I am building a bookkeeping system in BASE to replace the one I have > been using which is a series of Calc spreadsheets. > > I have my Bank details in tblBanks (Name of bank; branch number; > address; etc) > and individual account deta

[users] Base question

2010-08-31 Thread James Elliott
I am building a bookkeeping system in BASE to replace the one I have been using which is a series of Calc spreadsheets. I have my Bank details in tblBanks (Name of bank; branch number; address; etc) and individual account details in tblBankAccts (Bank_ID; Account name; Account number; etc

Re: [users] Base question.?

2010-08-29 Thread James Elliott
Hi Drew On 29/08/2010 11:31 AM, Drew wrote: After generating the invoice as a report: File>Save Don't - do what you are doing, in the database save the URL to the saved file. Many thanks for answering both questions. When I have finished the database I might come back to you for that macro.

Re: [users] Base question.?

2010-08-28 Thread Drew
On Sun, 2010-08-29 at 10:25 +0800, James Elliott wrote: > Currently my whole bookkeeping system for my business is in the form > of Calc spreadsheets and I am in the process of building an OOo Base > bookkeeping system to better handle the growing diversity of my > accounting needs. > > When I

[users] Base question.?

2010-08-28 Thread James Elliott
Currently my whole bookkeeping system for my business is in the form of Calc spreadsheets and I am in the process of building an OOo Base bookkeeping system to better handle the growing diversity of my accounting needs. When I produce an invoice I currently fill in a Calc spreadsheet invoice

[users] Base password

2010-07-23 Thread Gregory Forster
Hi, this is probably a very "dunh" question, but I searched the documentation, checked the online help files and could not find. How do you password protect a database file?! Greg

Re: [users] Base wizard: Business or Personal?!?

2010-05-03 Thread Dotan Cohen
>     I would consider "category" and "sample fields types" to have very > similar meanings. The term "category" does not make it clear that the effect will be which fields are shown, and that this is the only effect. Any wording that makes both those points clear is fine. -- Dotan Cohen http:

Re: [users] Base wizard: Business or Personal?!?

2010-05-03 Thread Daniel Lewis
Dotan Cohen wrote: On 3 May 2010 00:08, Daniel Lewis wrote: Dotan Cohen wrote: When using the Base Table Wizard, the very first question is Category: Business or Personal. This is very confusing to users, who don't want to answer "wrong". If the only difference is in the Sample Tabl

Re: [users] Base wizard: Business or Personal?!?

2010-05-02 Thread Dotan Cohen
On 3 May 2010 00:08, Daniel Lewis wrote: > Dotan Cohen wrote: >> >> When using the  Base Table Wizard, the very first question is >> Category: Business or Personal. This is very confusing to users, who >> don't want to answer "wrong". If the only difference is in the Sample >> Tables, then maybe a

Re: [users] Base wizard: Business or Personal?!?

2010-05-02 Thread Daniel Lewis
Dotan Cohen wrote: When using the Base Table Wizard, the very first question is Category: Business or Personal. This is very confusing to users, who don't want to answer "wrong". If the only difference is in the Sample Tables, then maybe all the sample tables should be together anyway. If the di

[users] Base wizard: Business or Personal?!?

2010-05-02 Thread Dotan Cohen
When using the Base Table Wizard, the very first question is Category: Business or Personal. This is very confusing to users, who don't want to answer "wrong". If the only difference is in the Sample Tables, then maybe all the sample tables should be together anyway. If the difference is more than

[users] Base: Dropdown suggestions for existing data on condition?

2009-12-27 Thread Dotan Cohen
In Base, how can text fields have a dropdown box showing existing data if a certain condition is met? At a lab I work at, we process requests from different local companies. The first field is for the area, and the second field is for the company name. I want only the companies shown that are loca

[users] Base Form Question

2009-11-28 Thread Eustace
How can I specify the vertical distance between a label and a field? (Of course I can drag it, but I want to be accurate.) -emf -- It ain't THAT, babe! - A radical reinterpretation https://files.nyu.edu/emf202/public/bd/itaintmebabe.html ---

[users] Base question

2009-11-24 Thread Eustace
I followed the directions of the OOo3 Getting Started to make a Fuel form as on Figure 227, page 271 of the manual. It was interesting and I learned things that I may find some use of in the future. My problem is that because my default font size is bigger than the one they used in the figures,

Re: [users] Base question

2009-11-21 Thread Michael Adams
On Sat, 21 Nov 2009 08:23:53 -0500 Came this utterance formulated by Eustace to my mailbox: > I am reading the OOo3 Getting Started manual. I am at the beginning of > page 246, at b. When I try to enter Kevin in the second row I get the > following alert: > > Error inserting the new record. > At

[users] Base question

2009-11-21 Thread Eustace
I am reading the OOo3 Getting Started manual. I am at the beginning of page 246, at b. When I try to enter Kevin in the second row I get the following alert: Error inserting the new record. Attempt to insert null into a non-nullable column: column PaymentID table: Payment Type in statement [IN

Re: [users] Base - import from Calc.

2009-09-03 Thread Brian Barker
At 13:11 03/09/2009 -0700, John Gregson wrote: I am using Open Office 3.1.1 Java version is: 1.6.0.15 I am using a PC with Vista 32 I am in the process of importing data from MS Works Database, version 8. On August 29; Brian Barker kindly provided a written procedure to do this. After a lit

Re: [users] Base - Relationships

2009-09-03 Thread Drew Jensen
FamiliaFrazelle wrote: "Hello Fred, Actually I saw your first email and meant to reply - just got off on other things and never back to it. Let's start with this - look at the attached database. Is this about how you have it setup? Drew" Drew: Thanks for the above. However i didn't see

[users] Base - import from Calc.

2009-09-03 Thread John Gregson
I am using Open Office 3.1.1 Java version is: 1.6.0.15 I am using a PC with Vista 32 I am in the process of importing data from MS Works Database, version 8. On August 29; Brian Barker kindly provided a written procedure to do this. After a little time, I got it working, and it worked well. No

[users] Base - Relationships

2009-09-03 Thread FamiliaFrazelle
"Hello Fred, Actually I saw your first email and meant to reply - just got off on other things and never back to it. Let's start with this - look at the attached database. Is this about how you have it setup? Drew" Drew: Thanks for the above. However i didn't see any attached db. i get

Re: [users] Base> One to many relationship

2009-09-02 Thread Drew Jensen
Harold Fuchs wrote: 2009/9/3 Drew Jensen Harold Fuchs wrote: You might be better off asking in the "Base" section within the OOo forum. It's at . You need to subscribe (free) before you can post questions or answers. Like this mail list it's run by volunteers but ten

Re: [users] Base> One to many relationship

2009-09-02 Thread Harold Fuchs
2009/9/3 Drew Jensen > Harold Fuchs wrote: > >> >> You might be better off asking in the "Base" section within the OOo forum. >> It's at . You need to subscribe (free) before >> you can post questions or answers. Like this mail list it's run by >> volunteers but tends to

Re: [users] Base> One to many relationship

2009-09-02 Thread Drew Jensen
Harold Fuchs wrote: You might be better off asking in the "Base" section within the OOo forum. It's at . You need to subscribe (free) before you can post questions or answers. Like this mail list it's run by volunteers but tends to be more specialised. Just a FYI -

Re: [users] Base> One to many relationship

2009-09-02 Thread Drew Jensen
Fred Frazelle wrote: This is the second time i've sent this, but i don't see it appearing in the Digest. i'm going to format it as Plan Text and see what happens. i hope this is the correct forum for this... i'm still trying to get this to work... i've created two tables: Dates a

Re: [users] Base> One to many relationship

2009-09-02 Thread Harold Fuchs
Fred Frazelle wrote: This is the second time i've sent this, but i don't see it appearing in the Digest. i'm going to format it as Plan Text and see what happens. i hope this is the correct forum for this... i'm still trying to get this to work... i've created two tables: Dates

[users] Base> One to many relationship

2009-09-02 Thread Fred Frazelle
This is the second time i've sent this, but i don't see it appearing in the Digest. i'm going to format it as Plan Text and see what happens. i hope this is the correct forum for this... i'm still trying to get this to work... i've created two tables: Dates and Visits. This is a

[users] Base> One to many relationship

2009-08-31 Thread FamiliaFrazelle
    i hope this is the correct forum for this...     i'm still trying to get this to work...     i've created two tables: Dates and Visits.  This is a bare-bones setup to see if it works.  The idea is to input info from visits to homes into the Visits table.  Since many visits to homes are m

Re: [users] Base import from Works

2009-08-30 Thread John Gregson
Brian. - Original Message - From: Brian Barker To: users@openoffice.org Sent: 30 Aug, 2009 2:54 PM Subject: Re: [users] Base import from Works >Yes, I think you are correct. I assume you mean to copy the entire >spreadsheet to memory (ctrl-c)? Er, if yo

Re: [users] Base import from Works

2009-08-30 Thread Brian Barker
At 18:18 30/08/2009 -0400, Drew Jensen wrote: @Brian - granted it is overkill to copy the entire sheet, but the paste will not create "squillions" of empty records. It will create empty records for gaps in the sheets cells: Assume the sheet has 3 rows of data with a blank row between each, sta

Re: [users] Base import from Works

2009-08-30 Thread Drew Jensen
Hi John, Brian Barker wrote: At 11:26 30/08/2009 -0700, John Gregson wrote: Actually I did; I used bold on my comments. I am now using the font 'Arial Black'; we will see if this works. Have you ever seen formatting in messages distributed by the list? I haven't. Then immediately copy t

Re: [users] Base import from Works

2009-08-30 Thread Brian Barker
At 11:26 30/08/2009 -0700, John Gregson wrote: Actually I did; I used bold on my comments. I am now using the font 'Arial Black'; we will see if this works. Have you ever seen formatting in messages distributed by the list? I haven't. Then immediately copy the material from the Calc spreads

Re: [users] Base import from Works

2009-08-30 Thread Brian Barker
At 11:26 30/08/2009 -0700, John Gregson wrote: Actually I did; I used bold on my comments. I am now using the font 'Arial Black'; we will see if this works. Have you ever seen formatting in messages distributed by the list? I haven't. Then immediately copy the material from the Calc spreads

Re: [users] Base import from Works

2009-08-30 Thread Brian Barker
At 11:26 30/08/2009 -0700, John Gregson wrote: Actually I did; I used bold on my comments. I am now using the font 'Arial Black'; we will see if this works. Have you ever seen formatting in messages distributed by the list? I haven't. Then immediately copy the material from the Calc spreads

[users] Base column Width

2009-08-30 Thread John Gregson
I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista 32 I am very new to Open Office and Base. I have just copied a lot of date from Works to Base; via Calc. Viewing the Base table; When I want to optimize the column widths; I right-click on the column he

Re: [users] Base import from Works

2009-08-30 Thread John Gregson
Brian - Original Message - From: Brian Barker To: users@openoffice.org Sent: 30 Aug, 2009 10:34 AM Subject: Re: [users] Base import from Works At 09:58 30/08/2009 -0700, John Gregson wrote: >I'm a bit confused here. So am I, since you have (sensibly) intersper

Re: [users] Base import from Works

2009-08-30 Thread Brian Barker
At 09:58 30/08/2009 -0700, John Gregson wrote: I'm a bit confused here. So am I, since you have (sensibly) interspersed your words with mine - but without differentiation. ;^) I've tried to unravel them. At 19:33 29/08/2009 +0100, Brian Barker wrote: At 09:52 29/08/2009 -0700, John Gregs

Re: [users] Base garbage in List

2009-08-30 Thread Drew Jensen
John Gregson wrote: I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista 32 I am very new to Open Office and Base. I have noticed that when I use the "Open an Existing Database File" option, click on the down arrow, I get a lot of 'garbage' in the Lis

Re: [users] Base import from Works

2009-08-30 Thread John Gregson
Brian. I'm a bit confused here. John. - - Original Message - From: Brian Barker To: users@openoffice.org Sent: 29 Aug, 2009 11:33 AM Subject: Re: [users] Base import from Works At 09:52 29/08/2009 -0700, John Gregson wrote: >Has anybody ma

Re: [users] Base garbage in List

2009-08-29 Thread Brian Barker
At 15:34 29/08/2009 -0700, John Gregson wrote: I am using a PC with Vista 32 I have noticed that when I use the "Open an Existing Database File" option, click on the down arrow, I get a lot of 'garbage' in the List. You should have the names of database files that you have previously referen

Re: [users] Base garbage in List

2009-08-29 Thread Drew Jensen
John Gregson wrote: I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista 32 I am very new to Open Office and Base. I have noticed that when I use the "Open an Existing Database File" option, click on the down arrow, I get a lot of 'garbage' in the Lis

[users] Base garbage in List

2009-08-29 Thread John Gregson
I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista 32 I am very new to Open Office and Base. I have noticed that when I use the "Open an Existing Database File" option, click on the down arrow, I get a lot of 'garbage' in the List. There are about 6-8

Re: [users] Base import from Works

2009-08-29 Thread Drew Jensen
John Gregson wrote: I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista 32 I am very new to Open Office and Base. Has anybody managed to import a Works 8 database into Base? I have over 30,000 records, in several Works databases that I would like to ge

Re: [users] Base import from Works

2009-08-29 Thread Brian Barker
At 09:52 29/08/2009 -0700, John Gregson wrote: Has anybody managed to import a Works 8 database into Base? I have over 30,000 records, in several Works databases that I would like to get into Base. Works 8 can save a database file as a CSV file or as a dBase 4 file, or in its own default for

[users] Base import from Works

2009-08-29 Thread John Gregson
I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista 32 I am very new to Open Office and Base. Has anybody managed to import a Works 8 database into Base? I have over 30,000 records, in several Works databases that I would like to get into Base. Works 8

Re: [users] Base Date formats

2009-08-27 Thread Drew Jensen
John Gregson wrote: I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista 32 Cannot change date format and have it 'stick'; also cannot find a suitable date format. When I start the process to change the Date format, I open the Table in Edit mode.

[users] Base Date formats

2009-08-27 Thread John Gregson
I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista 32 I am very new to Open Office and Base. This is going to be rather long; sorry, but I am confused! Cannot change date format and have it 'stick'; also cannot find a suitable date format. The Table h

Re: [users] Base Form font change

2009-08-26 Thread Drew Jensen
John Gregson wrote: I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista 32 I am very new to Open Office and Base. I have a Form setup in Base; but now I want to change the font size of the controls (not Labels). I can change them one at a time but not

[users] Base Form font change

2009-08-26 Thread John Gregson
I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista 32 I am very new to Open Office and Base. I have a Form setup in Base; but now I want to change the font size of the controls (not Labels). I can change them one at a time but not as a group. I've tried

Re: [users] Base Table insert field

2009-08-25 Thread Erik Remmelzwaal
Originele bericht Onderwerp: [users] Base Table insert field Van: John Gregson Aan: Open Office Mail List Datum: Mon, 24 Aug 2009 13:26:12 -0700 > I am using Open Office 3.1.0 (build 9399) > Java version is: 1.6.0_15 > I am using a PC with Vista 32 > I am very

Re: [users] Base Table insert field

2009-08-24 Thread Drew Jensen
John Gregson wrote: However after setting up a Table and a Form; I just found that I had left out an important field in the Table. Is there any way to insert another field into the existing Table; Hello John, Base has, in most instances, two ways to edit a tables structure. The GUI table

[users] Base Table insert field

2009-08-24 Thread John Gregson
I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista 32 I am very new to Open Office and Base. I'm just 'playing' with Base; and learning much. However after setting up a Table and a Form; I just found that I had left out an important field in the Table.

[users] Base Form Grid

2009-08-23 Thread John Gregson
I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista 32 I am very new to Open Office and Base. I have generated a Table, using the Wizard; then setup a Form, in design mode. Things went well until I wanted to use a Grid. I switched to design mode in the

Re: [users] Base print Table

2009-08-22 Thread Drew Jensen
John Gregson wrote: I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista I am very, very new to Open Office and Base. Question: After I have created a Table, is there any way to Print out the table view, this would be most useful. >From the Documents

[users] Base print Table

2009-08-22 Thread John Gregson
I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista I am very, very new to Open Office and Base. Question: After I have created a Table, is there any way to Print out the table view, this would be most useful. >From the Documents / Tasks window. If I se

[users] Base form column alignment

2009-08-19 Thread John Gregson
I am using Open Office 3.1.0 (build 9399) Java version is: 1.6.0_15 I am using a PC with Vista I am very, very new to Open Office and Base. I have completed a great Base tutorial by T.K. Boyd. I am having a perplexing problem with the column alignment of one of fields in the Form. The Field is c

Re: [users] Base field names

2009-08-17 Thread Andy
John Gregson wrote: I am just starting to learn Open Office 3.1 I am using a PC; running Vista. I am starting with Base. Question; can spaces be used within a field name? John It is considered bad practice to use and thing other than letters, numbers and the underscore, _ , in field names.

[users] I Cant give u an answerRE: [users] Base field names

2009-08-17 Thread Weldon Hayward
-Original Message- Date: Monday, August 17, 2009 5:09:45 pm To: "Open Office Mail List" From: "John Gregson" Subject: [users] Base field names I am just starting to learn Open Office 3.1 I am using a PC; running Vista. I am starting with Base. Question; can spa

[users] Base field names

2009-08-17 Thread John Gregson
I am just starting to learn Open Office 3.1 I am using a PC; running Vista. I am starting with Base. Question; can spaces be used within a field name? John

Re: [users] Base & MS Access compatability

2009-08-04 Thread Drew Jensen
and now to answer your actual question: If you created a Base file with an embedded database then for all intent and purpose you could share the data with no-one or everyone: you can just give them a copy of the file, but there are NO connectors available. So use something like a SQLite or My

Re: [users] Base & MS Access compatability

2009-08-04 Thread Drew Jensen
Drew Jensen wrote: AG wrote: Hello List I am about to launch into developing my first database using Base, but first wanted to take some advice from this List please. The dB will be for field studies of fungi and I am conscious that should I wish to share these data with anyone from the myc

Re: [users] Base & MS Access compatability

2009-08-02 Thread Drew Jensen
AG wrote: Hello List I am about to launch into developing my first database using Base, but first wanted to take some advice from this List please. The dB will be for field studies of fungi and I am conscious that should I wish to share these data with anyone from the mycology field, it is

Re: [users] Base & MS Access compatability

2009-08-02 Thread AG
jonathon wrote: On Sat, Aug 1, 2009 at 10:25, AG wrote: The dB will be for field studies of fungi and I am conscious that should I wish to share these data with anyone from the mycology field, it is probable that they will be using MS Access. * Microsoft has been trying to end of l

Re: [users] Base & MS Access compatability

2009-08-01 Thread jonathon
On Sat, Aug 1, 2009 at 10:25, AG wrote: > The dB will be for field studies of fungi and I am conscious that should I > wish to share these data with anyone from the mycology field, it is probable > that they will be using MS Access. * Microsoft has been trying to end of life Access for at leas

[users] Base & MS Access compatability

2009-08-01 Thread AG
Hello List I am about to launch into developing my first database using Base, but first wanted to take some advice from this List please. The dB will be for field studies of fungi and I am conscious that should I wish to share these data with anyone from the mycology field, it is probable th

Re: [users] Base 3 - Lost Relationships and "out of memory"

2009-07-07 Thread lllact...@gmx.net
Hi Drew, Its been a while since this post, that I tried Base again today. I have a new OO 3.1.0 on OpenSUSE 11.1 in the mean time. Various JRE's are on the system, but OO is configured to use the newest Sun Version from OpenSUSE that I installed today: java-1_6_0-sun - Java(TM) 6 Runtime Environme

Re: [users] Base query

2009-05-29 Thread John Meyer
Thanks. I found that also by looking up the HSQL syntax online. Ocke Janssen wrote: Moin John Meyer, On 28.05.09 23:02, John Meyer wrote: I'm trying to make a query that will only select the odd entries in an integer field. How do you do that in Design View? What about SELECT "ID" from "Table

Re: [users] Base query

2009-05-28 Thread Ocke Janssen
Moin John Meyer, On 28.05.09 23:02, John Meyer wrote: I'm trying to make a query that will only select the odd entries in an integer field. How do you do that in Design View? What about SELECT "ID" from "Table" WHERE MOD("ID",2) = 1 and switch back to design view. - oj PS: A good list for t

[users] Base query

2009-05-28 Thread John Meyer
I'm trying to make a query that will only select the odd entries in an integer field. How do you do that in Design View? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@ope

Re: [users] Base Users Guide ?

2009-05-08 Thread Web Kracked
ccornell - OpenOffice.org wrote: I guess I'd like to volunteer. I'm not a programmer, but I'm comfortable with a computer. I currently have VISTA on a Dell machine. Something like proof reading is my speed these days. Frank The easiest place to start is here: http://wiki.services.openof

Re: [users] Base Users Guide ?

2009-05-08 Thread ccornell - OpenOffice.org
Anyone can contribute - you don't need to be an expert to help out. Even if the doc is something you may know nothing about, proof reading is an essential part of the document development process. When someone spends a lot of time looking at one document, they tend to become "word blind" and will

Re: [users] Base Users Guide ?

2009-05-07 Thread Frank Van De Warker
Clayton wrote: John Kaufmann wrote: Drew, In a message dated 2009.05.05 17:47 -0500, Drew Jensen wrote: Just noted a new sign up at the OOoAuthors project - and she is interested in working on a Base manual. Seems long past time for the members of the project to pull together and get

Re: [users] Base Users Guide ?

2009-05-06 Thread Clayton
John Kaufmann wrote: > Drew, > > In a message dated 2009.05.05 17:47 -0500, Drew Jensen wrote: > >> Just noted a new sign up at the OOoAuthors project - and she is >> interested in working on a Base manual. >> >> Seems long past time for the members of the project to pull together >> and get *som

Re: [users] Base Users Guide ?

2009-05-05 Thread John Kaufmann
In a message dated 2009.05.05 17:57 -0500, Drew Jensen wrote: Sorry guys - sent that email to the wrong users list by accident. ¿How so? How else would we know about the project? - To unsubscribe, e-mail: users-unsubscr...@o

Re: [users] Base Users Guide ?

2009-05-05 Thread John Kaufmann
Drew, In a message dated 2009.05.05 17:47 -0500, Drew Jensen wrote: Just noted a new sign up at the OOoAuthors project - and she is interested in working on a Base manual. Seems long past time for the members of the project to pull together and get *something* together - doesn't it? Thanks

Re: [users] Base Users Guide ?

2009-05-05 Thread Drew Jensen
Sorry guys - sent that email to the wrong users list by accident. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org

[users] Base Users Guide ?

2009-05-05 Thread Drew Jensen
HI, Just noted a new sign up at the OOoAuthors project - and she is interested in working on a Base manual. Seems long past time for the members of the project to pull together and get *something* together - doesn't it? So - if there is anyone on the lists here interested in helping with t

Re: [users] Base field types: how to handle ENUMerated values?

2009-04-02 Thread John Kaufmann
Hi Drew, Thanks for that point of clarification re what is in HSQLdb, and how much of that is supported by the Base GUI. In a message dated 2009.04.01 17:12 -0500, Drew Jensen wrote: Before I give up, has anyone found a way to mimic this limited used of enum fields, and to dispose of that Ba

Re: [users] Base field types: how to handle ENUMerated values?

2009-04-01 Thread Drew Jensen
John Kaufmann wrote: Before I give up, has anyone found a way to mimic this limited used of enum fields, and to dispose of that Base error without giving up the requirement for a Priority estimate? John Hi John, OK - first I take it that what you are talking about here is Base with an e

[users] Base field types: how to handle ENUMerated values?

2009-04-01 Thread John Kaufmann
Trying to set up a problem resolution database, which includes a "Problems" table, I am stymied on a small but critical point: how to handle ENUMerated values in a "Priority" field (as in: 1=highest priority, 5=lowest priority)? I tried googling this problem and was not encouraged by the result

Re: [users] base

2009-01-24 Thread John & Mary Linge
Try adding a primary key field. John L. On Tue, Jan 20, 2009 at 5:18 PM, Douglas Rasey wrote: > > I've created a database (.odb)from a .csv file. However I cannot edit > individual record fields. The file ownership is OK. I can add & delete > fields just nit edit the data. > > thanks > Doug Ras

[users] base

2009-01-23 Thread Douglas Rasey
I've created a database (.odb)from a .csv file. However I cannot edit individual record fields. The file ownership is OK. I can add & delete fields just nit edit the data. thanks Doug Rasey _ Windows Live™: Keep your life in sync.

Re: [users] Base: "Input Parameter" window pops up also when "fill parameter"-macro is in place

2008-12-27 Thread Erik Remmelzwaal
Originele bericht Onderwerp: Re: [users] Base: "Input Parameter" window pops up also when "fill parameter"-macro is in place Van: Drew Jensen Aan: users@openoffice.org Datum: thu, 25 dec 2008 14:07:57 -0500 > Erik Remmelzwaal wrote: >> All, >

Re: [users] Base: "Input Parameter" window pops up also when "fill parameter"-macro is in place

2008-12-25 Thread Drew Jensen
Erik Remmelzwaal wrote: All, I've a Base document with a form and a sub-form. The content of the sub-form is based on a query. This query contains two parameters. One parameter is solved via Linked fields setup of the Data properties of the sub-form. The other parameter is resolved via pop up wi

[users] Base: "Input Parameter" window pops up also when "fill parameter"-macro is in place

2008-12-23 Thread Erik Remmelzwaal
All, I've a Base document with a form and a sub-form. The content of the sub-form is based on a query. This query contains two parameters. One parameter is solved via Linked fields setup of the Data properties of the sub-form. The other parameter is resolved via pop up window "Input parameter". I

Re: [users] Base 3 - Lost Relationships and "out of memory" - Java problem or Bug?

2008-12-09 Thread lllact...@gmx.net
Drew Jensen wrote: > OK, another question. > > If you open the java options dialog. > Tools>Options>OpenOffice.org>Jave > > Which of the java runtimes...(then again I guess you said that you now only > have one) > > Well, Ubuntu hasn't released the 3.0 yet in the repositories - but I can > instal

[users] BASE: New field with data from other field

2008-12-08 Thread DMudgal
Return Receipt Your [users] BASE: New field with data from other field document

Re: [users] BASE: New field with data from other field

2008-12-08 Thread Drew Jensen
Eugénio Varejão wrote: Hello! I have a problem in a database: the database have two fields CP (postal code) and Localidade (town) and I want to create a new field appending the information of these two fields as shows: CP LOCALIDADE CPC 5030 Cumieira - SMP 5030 CUMIEIRA - SMP How

[users] BASE: New field with data from other field

2008-12-08 Thread Eugénio Varejão
Hello! I have a problem in a database: the database have two fields CP (postal code) and Localidade (town) and I want to create a new field appending the information of these two fields as shows: CP LOCALIDADE CPC 5030 Cumieira - SMP 5030 CUMIEIRA - SMP How can I do this in Base? A

Re: [users] Base 3 - Lost Relationships and "out of memory" - Java problem or Bug?

2008-12-05 Thread [EMAIL PROTECTED]
Drew Jensen wrote: > [EMAIL PROTECTED] wrote: >> Hi all, >> >> I'm trying the new OOo 3.0 Base in stead of Access 2007. >> >> The system is: >> OS: OpenSUSE 10.3 - Linux ~ 2.6.22.19-0.1-default #1 SMP 2008-10-14 >> 22:17:43 +0200 x86_64 x86_64 x86_64 GNU/Linux >> Openoffice: OpenOffice.org 3.0.0,

Re: [users] Base 3 - Lost Relationships and "out of memory"

2008-12-04 Thread Web Kracked
[EMAIL PROTECTED] wrote: Arnold Huzen wrote: You say your trying Base instead of Access. So I assume you opened an MDB-file. For as far as I know, Base only opens the tables of the mdb-file and cannot save any changes you made to the original mdb-file. If you want keep any changes, then you m

Re: [users] Base 3 - Lost Relationships and "out of memory"

2008-12-04 Thread [EMAIL PROTECTED]
Arnold Huzen wrote: > You say your trying Base instead of Access. So I assume you opened an > MDB-file. For as far as I know, Base only opens the tables of the > mdb-file and cannot save any changes you made to the original > mdb-file. If you want keep any changes, then you must save it to the > Op

Re: [users] Base 3 - Lost Relationships and "out of memory"

2008-12-04 Thread Drew Jensen
Arnold Huzen wrote: You say your trying Base instead of Access. So I assume you opened an MDB-file. For as far as I know, Base only opens the tables of the mdb-file and cannot save any changes you made to the original mdb-file. If you want keep any changes, then you must save it to the OpenOffi

Re: [users] Base 3 - Lost Relationships and "out of memory"

2008-12-04 Thread Drew Jensen
[EMAIL PROTECTED] wrote: Hi all, I'm trying the new OOo 3.0 Base in stead of Access 2007. The system is: OS: OpenSUSE 10.3 - Linux ~ 2.6.22.19-0.1-default #1 SMP 2008-10-14 22:17:43 +0200 x86_64 x86_64 x86_64 GNU/Linux Openoffice: OpenOffice.org 3.0.0, OOO300m9 (Build:9358), Copyright 2000-200

  1   2   3   4   5   6   >