Re: [libreoffice-users] Looking for input form example...

2018-12-29 Thread Marion & Noel Lodge
Have you tried using the Report Wizard? You may get a report that you can use, or alternatively, you could modify it to get what you want. Noel -- Marion & Noel Lodge lodg...@gmail.com On Sun, 30 Dec 2018 at 07:56, Michael Tiernan wrote: > I got asked to help someone solve a simple

Re: [libreoffice-users] Re: LO Base Queries, Forms & Reports not appearing

2017-09-22 Thread Marion & Noel Lodge
gt; Le 21/09/2017 à 15:16, Marion & Noel Lodge a écrit : > > Hi Noel, > > If you are using macros to open windows/dialogs in your database, then > you need to be aware of bug 95191. It is quite a serious hindrance to > cross-platform Base implementation, and has been

Re: [libreoffice-users] Re: LO Base Queries, Forms & Reports not appearing

2017-09-21 Thread Marion & Noel Lodge
I'm now hopeful that I'll get there in the end. Many thanks for your help Noel -- Noel Lodge lodg...@gmail.com On 15 September 2017 at 16:50, Alexander Thurgood <alex.thurg...@gmail.com> wrote: > Le 15/09/2017 à 04:36, Marion & Noel Lodge a écrit : > > Hi Noel, > > I

[libreoffice-users] LO Base Queries, Forms & Reports not appearing

2017-09-14 Thread Marion &amp; Noel Lodge
I am transferring an H2 database from a Windows PC to a late model Apple Mac, (Capitan 10.11.6). On the main Base window, the Tables are all displaying normally, but nothing shows up under Queries, Forms or Reports. I've hunted through all LO's options, but I can't find any setting that might be

Re: [libreoffice-users] Re: Reading from a USB device.

2017-08-29 Thread Marion &amp; Noel Lodge
. Thanks again to you all for your comments and suggestions - much appreciated. Noel -- Noel Lodge lodg...@gmail.com On 29 August 2017 at 05:00, Stefan Gruber <st.gru...@t-online.de> wrote: > Hi, > > Marion & Noel Lodge schrieb am Montag, 28. August 2017 07:43: > >

Re: [libreoffice-users] Reading from a USB device.

2017-08-27 Thread Marion &amp; Noel Lodge
> another sound application?; > .midi programs are outdated, since they supposedly don't have > the actual sound, rather merely text. > >Hoping this helps, and you're able to accomplish whatever you're > planning, > > > > > From: Marion & Noel Lodge &

[libreoffice-users] Reading from a USB device.

2017-08-27 Thread Marion &amp; Noel Lodge
I have a Studio Logic MIDI music keyboard which I have plugged into my PC via a USB cable. Windows has automatically installed the appropriate driver/s. I am attempting to read the MIDI input from the keyboard as I want to see if I can use a Macro to modify the sound before it goes to the

Re: [libreoffice-users] Re: H2 migration from Windows PC to Mac OS X

2017-06-14 Thread Marion &amp; Noel Lodge
06/2017 à 14:59, Marion & Noel Lodge a écrit : > > Hi Noel, > > Installation > Installation of LibreOffice on Mac is relatively easy. > You will need to download the main app DMG, and possibly any language > pack that you want, if you work in a language other than en-US.

[libreoffice-users] H2 migration from Windows PC to Mac OS X

2017-06-12 Thread Marion &amp; Noel Lodge
Hi Everyone, I have an accounting application using the h2 database running under LibreOffice which I need to migrate to a Mac OS X Notebook. I have never used a Mac, so I'm no doubt going to be on a steep learning curve. Can anyone point me to some instructions on how to set up LibreOffice on

Re: [libreoffice-users] Re: Not receiving posts from the List

2017-05-10 Thread Marion &amp; Noel Lodge
fixed the problem. ​Noel​ -- Marion & Noel Lodge lodg...@gmail.com On 9 May 2017 at 05:35, Kolbjørn Stuestøl <kolbjo...@stuestoel.no> wrote: > Den 08.05.2017 16:55, anne-ology skreiv: > >> possibly >> >> your spam folder has been re-s

Re: [libreoffice-users] Re: Calc as a Flat File Database

2016-03-18 Thread Marion &amp; Noel Lodge
Hi Ian, I think what you are wanting to discover is how to open your Form - the .odt file. One possibility would be to right click on the .odt file, then choose Send to | Desktop (create shortcut). After that, simply clicking on the shortcut on the Desktop will open the . odt file. No doubt to

Re: [libreoffice-users] Tab Interface

2016-02-26 Thread Marion &amp; Noel Lodge
Hi Amit, I may be wrong, but I think you were asking how to create tabs similar to those in Calc, that display different sheets. As far as I know there are no objects in Libre Office Base that give this sort of capability. But I have, on occasion, used a button to trigger a macro for making,

Re: [libreoffice-users] Base - hiding a push button conditionally

2016-02-14 Thread Marion &amp; Noel Lodge
reOffice and > open it again, then it works perfectly. > I have searched all the documents that I was able to download for > "visible", but strangely, EnableVisible was not found in any of them. > Again, thanks so much. > Egbert > > > > On Wednesday, 10 February 2016, 11:54,

Re: [libreoffice-users] Base - hiding a push button conditionally

2016-02-09 Thread Marion &amp; Noel Lodge
t line does not work, I have had good success with - oMangFormSupplBtn.EnableVisible = TRUE oMangFormSupplBtn.EnableVisible = FALSE As I say, this might not work for you, but maybe worth a try. Noel -- Marion & Noel Lodge lodg...@gmail.com On 7 February 2016 at 18:48

[libreoffice-users] How to use parameters when opening a Database

2016-02-09 Thread Marion &amp; Noel Lodge
Hi, I have an accounting system, AcctsSyst.odb, which I want to use for three different databases. Currently I have three Windows Shortcuts on my desktop, each calling a different .odb. The .odbs are simply copies of AcctsSyst.odb, with a different database name hard coded into the appropriate

Re: [libreoffice-users] Base - automatically running a macro on form opening

2016-02-06 Thread Marion &amp; Noel Lodge
Hi Egbert, If you are running on a Windows machine, I have found ways to do what you were asking and I could make some suggestions if that would help. Noel -- Noel Lodge lodg...@gmail.com On 4 February 2016 at 14:59, Egbert Eissing wrote: > I need to fire up a macro

Re: [libreoffice-users] Displaying data on an unbound field

2016-01-12 Thread Marion &amp; Noel Lodge
Hi Egbert, I suspect that the property name may be case sensitive. I have similar code that works with "Text". Try using - oDiscountFact.Text = format(sDiscountFact, sFormatString2) and see if that fixes it. Noel -- Marion & Noel Lodge lodg...@gmail.com On 12 January 2016 at

Re: [libreoffice-users] BaseForms: transferring contents of data fields to the database table

2016-01-07 Thread Marion &amp; Noel Lodge
the bound field. I have found that BoundField.updateString works well in situations such as yours. I have also worked out how to cover the problem of using a Macro to write to a Date field. If you ever need to do this, I could send you the code. ​​Noel​ -- Marion & Noel Lodge lodg...@gmail.com On 5 January 201

Re: [libreoffice-users] Re: Where is Base?

2015-03-03 Thread Marion Noel Lodge
Hi Heinrich, I've been reluctant to join this discussion, but you comment about the need to have ... a stable, scalable interface to REAL databases (with sometimes millions of DB-tuples) ..., has prompted me to say that I believe one such database already exists - it is called H2. See -

Re: [libreoffice-users] Using PriorToReset event in Base form

2015-01-05 Thread Marion Noel Lodge
, Bill Gradwohl b...@ycc.com wrote: Thank you for the information. I'll have to deconstruct the code to understand what's going on, as I don't like black boxes. That's probably going to take me a while. Many thanks. On Sun, Jan 4, 2015 at 7:59 PM, Marion Noel Lodge lodg...@gmail.com wrote

Re: [libreoffice-users] Using PriorToReset event in Base form

2015-01-04 Thread Marion Noel Lodge
Hi Bill, I also encountered this problem. It turns out that you need to update the Control's bound field. Below is a modified version of a Macro I use. To update most Controls is fairly straightforward, but a Date Control is a bit more complicated. As you can see, you pass the Control Name, the

Re: [libreoffice-users] Re: Base Relationships: Update cascade not working

2014-11-01 Thread Marion Noel Lodge
that Update cascade worked!! If there were three lines joining the tables, I've no idea how I managed to do that. Otherwise, I'm at a loss to know what I was doing wrong yesterday. Perhaps the overnight reboot of my PC fixed it! Anyway, thanks again. Noel -- Marion Noel Lodge lodg...@gmail.com

[libreoffice-users] Base Relationships: Update cascade not working

2014-10-31 Thread Marion Noel Lodge
Hi, I am trying to change some Primary Keys in my main table, and get the changes to be reflected in several Foreign Keys. I have gone into Tools | ​ ​ Relationships, have set up the 1 to n connections between the tables and ​chosen Update cascade. However when I open the main table and attempt

Re: [libreoffice-users] Setting Base to open with a slected form

2014-10-27 Thread Marion Noel Lodge
Hi Peter, This question was asked recently. If you go to - http://www.libreoffice.org/get-help/nabble/ and search for How to open a particular form at startup you will find the thread. Noel -- Noel Lodge lodg...@gmail.com On 27 October 2014 19:08, Peter Goggin petergog...@bigpond.com

Re: [libreoffice-users] Printing Reports from BASE

2014-10-27 Thread Marion Noel Lodge
Hi Peter, A macro similar to this should do what you want - Sub PrintReport() ThisDatabaseDocument.ReportDocuments.getbyname(name of your report).open() End Sub Then edit your Menu form, double click on the Print button and under Events | 'Mouse button pressed', link the button to the

Re: [libreoffice-users] Re: [Base Database] How to open a particular form at startup ?

2014-10-03 Thread Marion Noel Lodge
Hi, I have a macro similar to neptuneuk's that Alex pointed to, but I go one step further. I run Windows 7 64 bit. I right click on my project's .odb file, click on 'Send to' and then on 'Desktop (create shortcut)'. Then I can simply double click on the shortcut to go directly into my Main

Re: [libreoffice-users] Re: [Base Database] How to open a particular form at startup ?

2014-10-03 Thread Marion Noel Lodge
FMain. After that, when the database opens, it automatically displays FMain. Noel -- Marion Noel Lodge lodg...@gmail.com On 3 October 2014 23:13, Dan Lewis elderdanle...@gmail.com wrote: On 10/03/2014 08:27 AM, Marion Noel Lodge wrote: Hi, I have a macro similar to neptuneuk's that Alex

Re: [libreoffice-users] Re: Running a Macro from a form

2014-09-05 Thread Marion Noel Lodge
' -- End of Macros -- Let me know if anything is not clear. Noel -- Marion Noel Lodge lodg...@gmail.com On 1 September 2014 18:48, Allan Newton al...@opticaldesign.co.uk

Re: [libreoffice-users] Re: Running a Macro from a form

2014-08-31 Thread Marion Noel Lodge
Hi Allan, With the help of Andrew and Alex, you may have solved your problem by now. But if not, I run lots of SQL commands in my Base applications and I could post the Basic code I use, if that was likely to be of any use to you. Noel -- Noel Lodge lodg...@gmail.com On 29 August 2014 19:32,

Re: [libreoffice-users] Adding fields to existing Base table

2014-07-11 Thread Marion Noel Lodge
Hi Dave, You might also like to have a look at the H2 Database Engine, see - http://www.h2database.com/html/main.html I have found that it is a good stable replacement for HSQLDB and have used it in 6 different databases with good success. There is an active users group, and some of them report

Re: [libreoffice-users] Adding fields to existing Base table

2014-07-11 Thread Marion Noel Lodge
to be reminded that there are other choices out there and what some of them are. Many thanks and regards from Tom :) On 11 July 2014 14:07, Marion Noel Lodge lodg...@gmail.com wrote: Hi Dave, You might also like to have a look at the H2 Database Engine, see - http://www.h2database.com/html

Re: [libreoffice-users] Which components do you use most?

2014-05-13 Thread Marion Noel Lodge
I hesitated to reply to this thread because I don't use LO's native Base, HSQL, but rather, for the last 3 years, I have been using H2SQL, which is proving much more robust that HSQL. But I guess that Base is designed to be the front end for all the major databases, so here is my contribution.

Re: [libreoffice-users] Do Macros run serially or in parallel?

2014-04-08 Thread Marion Noel Lodge
AM, Marion Noel Lodge wrote: Hi, Sorry I've been slow to respond to all your posts. It has taken me a while to sort out what I think is happening. Many of us are very busy and totally understand when it takes time to respond! Fernand, thanks for your code suggestion. I pasted

Re: [libreoffice-users] Do Macros run serially or in parallel?

2014-04-05 Thread Marion Noel Lodge
Hi, Sorry I've been slow to respond to all your posts. It has taken me a while to sort out what I think is happening. Fernand, thanks for your code suggestion. I pasted it into the start of my macros and the Wait() statement worked perfectly. Then I incorporated it into my Init macro and

Re: [libreoffice-users] Do Macros run serially or in parallel?

2014-04-03 Thread Marion Noel Lodge
why I was wanting to get fractions of a second in the print statements. Noel -- Marion Noel Lodge lodg...@gmail.com On 4 April 2014 03:06, Andrew Douglas Pitonyak and...@pitonyak.org wrote: So, are you saying that you have: Print #giInit, 1. + Now() Wait(2000) Print #giInit, 2. + Now

[libreoffice-users] Do Macros run serially or in parallel?

2014-04-01 Thread Marion Noel Lodge
Hi, In opening my database accounting system, I trigger via the Form: When loading event, a macro, (Sub Init()), containing the database initialisation routines. As the Form loads it displays the first record in the database, including the account number. To make things easier for the user,

Re: [libreoffice-users] Errors in LO 4.1 but not in LO 3.5

2014-03-29 Thread Marion Noel Lodge
On 29 March 2014 00:44, Cley Faye cleyf...@gmail.com wrote: 2014-03-28 13:34 GMT+01:00 Marion Noel Lodge lodg...@gmail.com: My macro is expecting a single value, but under v4.1 it has three values, so it's obvious why it is throwing the error. In both cases I have used the Java version

[libreoffice-users] Errors in LO 4.1 but not in LO 3.5

2014-03-28 Thread Marion Noel Lodge
Hi, I have an accounting system that runs fine under LO v3.5.6.2, but under LO v4.1.5.3 it throws the error Basic runtime error. Incorrect property value. I've tracked it down to a macro that is attempting to read from a Date object on the Form. The object is a

Re: [libreoffice-users] Re: Help with Base report

2014-01-22 Thread Marion Noel Lodge
Hi Harvey, Originally I used Alex's method and made the height of the text box twice what I needed, to accommodate the overflow. But this has the effect of the report lines being effectively double spaced, except for just a few long lines. It also uses twice as much paper, if the report is

Re: [libreoffice-users] Base - Application mode?

2014-01-14 Thread Marion Noel Lodge
Hi Ryan, I'm not sure if this is the best solution, but I have found that it works - Create the following macros - Sub OpenfMainMenu() OpenForm(fMainMenu) End Sub Sub OpenForm(FormName AS String)'Called from OpenfMainMenu() With ThisDatabaseDocument.currentcontroller If Not

Re: [libreoffice-users] Sorting a MySQL Database

2013-08-29 Thread Marion Noel Lodge
Noel On 29/08/13 06:12, Marion Noel Lodge wrote: Hi Ian, With a Form, I have found the following is the way to lock in the Form's sort order - 1. Open the Form in Edit mode 2. Right click on the form and from the dropdown choose Form... 3. Click on the Data Tab 4. The contents field

Re: [libreoffice-users] Sorting a MySQL Database

2013-08-28 Thread Marion Noel Lodge
Hi Ian, With a Form, I have found the following is the way to lock in the Form's sort order - 1. Open the Form in Edit mode 2. Right click on the form and from the dropdown choose Form... 3. Click on the Data Tab 4. The contents field should be pointing to your Table 5. Click on the box to

Re: [libreoffice-users] Base: In basic, how do you open a form to a particular record number?

2013-08-07 Thread Marion Noel Lodge
Hi Jason, You might be able to adapt this Sub for your needs: - Sub FindRecord(iTargetID AS Integer) Dim oColumn AS Object Dim iColumnValue AS Integer Dim iRowAS Integer Dim rs AS Object Dim sTargetIDAS String rs =

Re: [libreoffice-users] Re: Base DB Connections

2013-07-12 Thread Marion Noel Lodge
://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources#Programmers and he is in the documentation team helping write the official guides which can be downloaded freely. Regards from Tom :) -- *From:* Marion Noel Lodge lodg...@gmail.com *To:* users

Re: [libreoffice-users] Re: Base DB Connections

2013-07-10 Thread Marion Noel Lodge
/users/ All messages sent to this list will be publicly archived and cannot be deleted On 07/09/2013 09:20 PM, Marion Noel Lodge wrote: Hi Mark, I have written a Macro in Basic that imports Bank Statement details from a .csv file into my Accounting system. It uses an SQL INSERT

Re: [libreoffice-users] Re: Base DB Connections

2013-07-10 Thread Marion Noel Lodge
Thanks Andrew, Much of my macro's code was built on your examples and those of others. How did we ever manage before the Web? Noel -- Noel Lodge lodg...@gmail.com On 11 July 2013 10:22, Andrew Douglas Pitonyak and...@pitonyak.org wrote: Very Nice! On 07/10/2013 09:08 AM, Marion Noel

Re: [libreoffice-users] Re: Base DB Connections

2013-07-09 Thread Marion Noel Lodge
Hi Mark, I have written a Macro in Basic that imports Bank Statement details from a .csv file into my Accounting system. It uses an SQL INSERT INTO statement to write to the database Table. I run an H2 database, but because the Insert is done using SQL, it should translate fairly readily to

Re: [libreoffice-users] SQL statement error when linking Main form to SubForm

2013-06-11 Thread Marion Noel Lodge
theoretical notion that it might be a good idea. The main thing is that you did fix it!! Congrats and regards from Tom :) -- *From:* Marion Noel Lodge lodg...@gmail.com *To:* users@global.libreoffice.org users@global.libreoffice.org *Sent:* Monday, 10 June 2013

Re: [libreoffice-users] SQL statement error when linking Main form to SubForm

2013-06-10 Thread Marion Noel Lodge
out of time and will have to let it be for now. So, my apologies for wasting your time. I appreciated all the help I received, and I have picked up some new resources and ideas from your replies. Thanks again, Noel -- Noel Lodge lodg...@gmail.com On 7 June 2013 16:55, Marion Noel Lodge lodg

Re: [libreoffice-users] SQL statement error when linking Main form to SubForm

2013-06-07 Thread Marion Noel Lodge
the boats owned by the member which is what I think you want for your project. Hank On Thu, Jun 6, 2013 at 8:21 AM, Marion Noel Lodge lodg...@gmail.comwrote: Hi Dan, My form displays a Church Membership Roll - - The Families Table contains the family's Surname, Address, Street Map Reference

Re: [libreoffice-users] SQL statement error when linking Main form to SubForm

2013-06-06 Thread Marion Noel Lodge
this form and subform serve? (Specifically, why use the parameter?) 2) How does the design of the form accomplish these purposes? --Dan On 06/05/2013 09:40 PM, Marion Noel Lodge wrote: Hi Dan, Thank you for your prompt and detailed reply. I'm using the H2 database and I suspect

[libreoffice-users] SQL statement error when linking Main form to SubForm

2013-06-05 Thread Marion Noel Lodge
Hi, I have a Form with families info in the Main Form and family members info in a Sub Form. The Tables and relevant fields are - Main Form (Families) FamilyID BIGINT IDENTITY Info fields follow Sub Form (Roll) RollID BIGINT IDENTITY FamilyKey BIGINT Info fields follow I

Re: [libreoffice-users] SQL statement error when linking Main form to SubForm

2013-06-05 Thread Marion Noel Lodge
. Noel -- Noel Lodge lodg...@gmail.com On 5 June 2013 21:51, Dan Lewis elderdanle...@gmail.com wrote: Onn 06/05/2013 02:29 AM, Marion Noel Lodge wrote: Hi, I have a Form with families info in the Main Form and family members info in a Sub Form. The Tables and relevant fields are - Main Form

[libreoffice-users] Table Data View - Column formatting lost when system shuts down

2013-05-29 Thread Marion Noel Lodge
If I right click on a Table column and choose Column Formatting | Alignment | Centre, the result is as I would expect - all data in that column is centred. If I exit LibreOffice, reopen it and go back to the same Table Data View the column's data is still centred. But if I close my PC, restart

Re: [libreoffice-users] LO Base - Question about Query

2013-05-25 Thread Marion Noel Lodge
Hi Ian, Assuming your field is 'Country', try this - SELECT Country, Count(Country) AS 'Count' FROM your Table name GROUP BY Country ORDER BY Country Noel -- Noel Lodge lodg...@gmail.com On 25 May 2013 19:09, Ian Whitfield whitfi...@telkomsa.net wrote: Hi All I have a Database

Re: [libreoffice-users] LO Base - Question about Query [SOLVED]

2013-05-25 Thread Marion Noel Lodge
line. Noel -- Noel Lodge lodg...@gmail.com On 25 May 2013 21:10, Ian Whitfield whitfi...@telkomsa.net wrote: Thanks Noel !!! On 25/05/13 11:58, Marion Noel Lodge wrote: Assuming your field is 'Country', try this - SELECT Country, Count(Country) AS 'Count' FROM your Table name

Re: [libreoffice-users] Oracle Report Builder - Text field overflow and N.aN problem

2013-04-08 Thread Marion Noel Lodge
in this forum may be able to specify exactly when Report Builder was first bundled into LibreOfiice, but I first noticed it around 3.5.3. Hope this helps. Girvin Herr Marion Noel Lodge wrote: Thanks for the replies. I'm away for the next couple of days, so I won't be able to try

[libreoffice-users] Oracle Report Builder - Text field overflow and a N.aN problem

2013-04-04 Thread Marion Noel Lodge
With Oracle Report Builder it does not seem to be possible to have a text field overflow into the next line and push everything below that down a line. (I'm porting an application from an old Paradox system and this was possible in Paradox reports.) If I make the text box double height in Report

[libreoffice-users] Oracle Report Builder - Text field overflow and N.aN problem

2013-04-04 Thread Marion Noel Lodge
Sorry about my previous post. Hit the wrong button and sent it prematurely! With Oracle Report Builder it does not seem to be possible to have a text field overflow into the next line and push everything below that down a line. (I'm porting an application from an old Paradox system and this was

Re: [libreoffice-users] Oracle Report Builder - Text field overflow and N.aN problem

2013-04-04 Thread Marion Noel Lodge
to LO 3.5.6.2). If I try LO 3.6.5, should I remove Oracle Report Builder 1.2.1 before installing 3.6.5? I'm running Windows 7 64 Bit. Thanks, Noel -- Noel Lodge lodg...@gmail.com On 5 April 2013 10:54, Girvin R. Herr girvin.h...@sbcglobal.net wrote: Marion Noel Lodge wrote: Sorry about

Re: [libreoffice-users] Using a Button to activate Subform.

2013-03-31 Thread Marion Noel Lodge
Hi Ian, I was puzzled as to why the code works for me, but not for you. Often the problem line is the one below the highlighted one, so I did some googling on ThisDatabaseDocument and found this URL - http://listarchives.libreoffice.org/global/users/msg13132.html In the last post of the thread,

Re: [libreoffice-users] Using a Button to activate Subform.

2013-03-29 Thread Marion Noel Lodge
Hi Ian, Not sure if this is what you need, but it works for me. I got it from the Web. On the Events tab of my button under 'Mouse button pressed', I connect to the sub, OpenfMembers(). If you substitute your form name in place of fMembers I think it should work for you too. Sub

Re: [libreoffice-users] Using a Button to activate Subform.

2013-03-29 Thread Marion Noel Lodge
whitfi...@telkomsa.net wrote: Thanks Noel On 29/03/13 13:13, Marion Noel Lodge wrote: Hi Ian, Not sure if this is what you need, but it works for me. I got it from the Web. On the Events tab of my button under 'Mouse button pressed', I connect to the sub, OpenfMembers(). If you

Re: [libreoffice-users] Base Recovery failed

2013-03-14 Thread Marion Noel Lodge
a lock-file at the same location as the originating Base file. Delete the lock file. Hope this helps. On 3/13/2013 9:17 AM, Marion Noel Lodge wrote: Hi, I have a situation where the recovery of a damaged database failed to complete. Eventually I had to recover the file from a backup

[libreoffice-users] Base Recovery failed

2013-03-13 Thread Marion Noel Lodge
Hi, I have a situation where the recovery of a damaged database failed to complete. Eventually I had to recover the file from a backup. The recovered backup file is now working normally, however whenever I start LibreOffice, it is still offering to recover the damaged database. Where do I go

[libreoffice-users] Filtering a Base Table by Data

2013-02-21 Thread Marion Noel Lodge
Hi, I want to open a Base Table and filter the records to show only records where the Date field is greater than or equal to the first of July 2012. I click on the Standard filter icon and enter the following under the three headings: - Field Name ConditionValue Date

Re: [libreoffice-users] Re: Base Report Builder

2013-01-27 Thread Marion Noel Lodge
Hi Hank, I haven't been following this thread closely, but it seem like you are experiencing some of the same problems I had using Base HSQLDB. I eventually decided to move my Accounting Project to the H2 Database Engine, (see http://www.h2database.com/html/main.html). Some of the many

Re: [libreoffice-users] Re: Base Report Builder

2013-01-27 Thread Marion Noel Lodge
27, 2013 at 4:36 AM, Marion Noel Lodge lodg...@gmail.comwrote: Hi Hank, I haven't been following this thread closely, but it seem like you are experiencing some of the same problems I had using Base HSQLDB. I eventually decided to move my Accounting Project to the H2 Database Engine, (see

[libreoffice-users] [Solved] Re: Keyboard Shortcuts for Buttons in Base

2013-01-23 Thread Marion Noel Lodge
Hi Tom Drew, Thanks for your replies. I've been on holiday for a week, but prior to that I came up with a work around that sort of worked, but was pretty clunky! Thanks Drew for letting me know about using the tilde - it was exactly what I was looking for. (Although for a start I thought it

[libreoffice-users] Keyboard Shortcuts for Buttons in Base

2012-12-29 Thread Marion Noel Lodge
Hi All, On the menu page for LibreOffice, the Database icon has the word 'D*a*tabase' beside it. The underlined *a* signifies that instead of clicking on the icon, the user has the option of typing Alt A to open a Database. My question is, can the same thing be achieved with a button in a Base

[libreoffice-users] Sorry about my double Post

2012-12-29 Thread Marion Noel Lodge
Hi All, My apologies for double posting my Keyboard Shortcut for Buttons in Base question. I get emails of all the posts to the Mailing List, and I assumed that my post would be included in those emails. When it didn't show up I though the first post had failed, so I posted it again. Still

[libreoffice-users] Keyboard Shortcuts for Buttons in Base

2012-12-28 Thread Marion Noel Lodge
Hi All, On the menu page for LibreOffice, the Database icon has the word 'D*a*tabase' beside it. The underlined *a* means that instead of clicking on the icon, the user has the option of typing Alt A to open a Database. My question is, can the same thing be achieved with a button in a Base

Re: [libreoffice-users] Re: Update SQL does nothing using Run SQL directly button

2012-10-07 Thread Marion Noel Lodge
Hi Jay, On 6 October 2012 14:55, Jay Lozier jsloz...@gmail.com wrote: This actually standard practice for writing queries. Another common practice is to capitalize SQL key words, which you appear to also do. I was aware that formatting a query was good practice - not so sure that it is

Re: [libreoffice-users] Re: Update SQL does nothing using Run SQL directly button

2012-10-05 Thread Marion Noel Lodge
I discovered one useful feature of the SQL Button. I like to format my SQL queries by putting SELECT, FROM, WHERE etc. each on a separate line, plus I use tabs to line up the various table names, again on their own line. I find this makes complex queries much more readable. If the SQL Button

Re: [libreoffice-users] Re: Macro code to highlight a field on a Form

2012-07-19 Thread Marion Noel Lodge
Hi Tom, I'm back on deck again now. Thanks for this URL - I've bookmarked it for future reference. Noel -- Noel Lodge lodg...@gmail.com On 8 July 2012 06:06, Tom tomdavie...@yahoo.co.uk wrote: Hi :) There is an excellent guide on writing Macros

Re: [libreoffice-users] Macro code to highlight a field on a Form

2012-07-07 Thread Marion Noel Lodge
both similar and different things. Thanks again, Noel -- Marion Noel Lodge lodg...@gmail.com On 2 July Andreas Säger ville...@t-online.de viahttp://support.google.com/mail/bin/answer.py?hl=en-GBctx=mailanswer=1311182 global.libreoffice.org wrote: Hello, All you need is the MRI extension

[libreoffice-users] Macro code to highlight a field on a Form

2012-07-01 Thread Marion Noel Lodge
there that does highlighting either. Can anyone point me to a solution? Thanks, Noel -- Marion Noel Lodge lodg...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting

Re: [libreoffice-users] Macro code to highlight a field on a Form

2012-07-01 Thread Marion Noel Lodge
now, and my latest project is to add more data entry automation. Hence my query as to how to highlight a field on a Form using Macro code. So if anyone knows how to do that, I'd be glad to hear from them. Thanks, Noel -- Marion Noel Lodge lodg...@gmail.com On 1 July 2012 20:31, Tom Davies