hing I may be doing and if I am busy I can then set a time
when I want it to display again. And it can be set up for important
regular reminders like 'turn on the electric blanket!' etc. And finally it
is freeware.
Noel
--
Marion & Noel Lodge
lodg...@gmail.com
On Sun, 11 Aug 20
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
t I think there must be more. I knew that
> porting
> > to the Mac would be difficult, but I'm now hopeful that I'll get there in
> > the end.
> >
> > Many thanks for your help
> >
> > Noel
> > --
> > Noel Lodge
> > lodg...@gmail.com
to the Mac would be difficult, but 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
wrote:
> Le 15/09/2017 à 04:36, Marion & Noel Lodge a écrit :
>
> Hi Noel,
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
way I'll probably learn things along the way.
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 wrote:
> Hi,
>
> Marion & Noel Lodge schrieb am Montag, 28. August 2017 07
ther 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 Lo
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
speaker
Hi Alex,
Many thanks for such a comprehensive reply to my query. I'm sure your
comments will be invaluable when I come to do the migration.
Much appreciated.
Noel
--
Noel Lodge
lodg...@gmail.com
On 12 June 2017 at 23:26, Alexander Thurgood
wrote:
> Le 12/06/2017 à 14:59, Mario
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 OS
that
ships with LibreOffice 5.1.6.2, the Line option does not appear under
Format.
Does anyone have a solution to this problem?
Noel
--
Marion & Noel Lodge
lodg...@gmail.com
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-
xing the filter fixed the problem.
Noel
--
Marion & Noel Lodge
lodg...@gmail.com
On 9 May 2017 at 05:35, Kolbjørn Stuestøl wrote:
> Den 08.05.2017 16:55, anne-ology skreiv:
>
>> possibly
>>
>> your spam folder has been re-set where i
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 g
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, say
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, Marion &
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, Egbe
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 B
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 automatically when I open a
Hi Tim,
It may depend on which Database you are using with LibreOffice.
I use the H2 Database and in my tables if I make CustomerID's type
BigInt[Identity],
then AutoValue = 'Yes works. That might be worth trying in your situation.
Noel
--
Noel Lodge
lodg...@gmail.com
On 24 January 2016 at 10:
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
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
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 -
http://
y 2015 at 13:18, Bill Gradwohl 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
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
discovered 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.
No
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
Hi Peter,
A macro similar to this should do what you want -
Sub PrintReport()
ThisDatabaseDocument.ReportDocuments.getbyname("").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 PrintReport() sub.
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 wrote:
> I have completed
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 wrote:
> On 10/03/2014 08:27 AM, Marion & Noel Lodge wrote:
>
>> Hi,
>>
>> I have a macro similar to
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 Menu
L = "CREATE TABLE TIMELOG.PUBLIC.TodaysTasks " _
+ "AS SELECT * FROM TIMELOG.PUBLIC.TimeLog " _
+ "WHERE Date = '" + sTodaysDate + "' "
goStmt7.executeUpdate(gsSQL)
Wait(1000)
' Display table TodaysTask on a Form
ThisDatabaseDocument.FormDocuments.getB
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, Al
.
Relatively easy to do with an update query, but I didn’t want to do that,
if there was an simpler solution.
Thanks,
Noel
--
Marion & Noel Lodge
lodg...@gmail.com
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/ho
.
>
> In general i think it is good 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 wrote:
>
>> Hi Dave,
>>
>> You m
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
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.
My
tting what I thought might have been concurrency or timing errors. I now
have some tools that will no doubt help iron out those problems.
Thanks again for your help.
Noel
--
Noel Lodge
lodg...@gmail.com
On 6 April 2014 00:50, Andrew Douglas Pitonyak wrote:
>
> On 04/05/2014 09:13 AM, Ma
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 disco
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 wrote:
>
> So, are you saying that you have:
>
>
> Print #giInit, "1. " + Now()
> Wait(200
more accurate timing?
Thanks,
Noel
--
Noel Lodge
lodg...@gmail.com
On 2 April 2014 00:05, Andrew Douglas Pitonyak wrote:
> Sadly, I do not have a definitive answer to your question, but I do have
> some thoughts... (see inline)
>
>
> On 04/01/2014 06:57 AM, Marion & Noel L
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, the
your help,
Noel
--
Noel Lodge
lodg...@gmail.com
On 29 March 2014 00:44, Cley Faye wrote:
>
> 2014-03-28 13:34 GMT+01:00 Marion & Noel Lodge :
>
> 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.
>>
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
com.sun.star.comp.forms.OdateMo
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 print
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 No
> 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 dropd
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 t
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 = go
;s book seems to be the main one that people say is well worth the
> money
>
> http://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
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 wrote:
> Very Nice!
>
>
> On 07/10/2013 09:08 AM, Marion &
idea whether this would actually work ;
>>> - the performance might suck big time, as LO Basic does not exactly have
>>> the greatest of memory management models.
>>>
>>> It might possibly work better in python. If you can avoid using the UI
>>> where poss
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 your
> that activity does have good results rather than us just some theoretical
> notion that it might be a good idea.
>
> The main thing is that you did fix it!!
> Congrats and regards from
> Tom :)
>
>
>
> --
> *From:* Mario
I have run 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 & Noe
ata for the
> member as a data sheet which includes all 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 wrote:
>
>> Hi Dan,
>>
>> My form displays a Church
ow:
> 1) What purposes do 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,
>>
>> Th
s the database. Is that right?
Thanks again for all your help - much appreciated.
Noel
--
Noel Lodge
lodg...@gmail.com
On 5 June 2013 21:51, Dan Lewis wrote:
> Onn 06/05/2013 02:29 AM, Marion & Noel Lodge wrote:
>
>> Hi,
>> I have a Form with families info in the Main Form
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
Sub Form (Roll)
RollID BIGINT IDENTITY
FamilyKey BIGINT
I have linked the forms using fields Famil
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 an
ry`) AS "Count"
to the end of your SELECT line.
Noel
--
Noel Lodge
lodg...@gmail.com
On 25 May 2013 21:10, Ian Whitfield wrote:
> Thanks Noel !!!
>
> On 25/05/13 11:58, Marion & Noel Lodge wrote:
>
>> Assuming your field is 'Country', try this -
>>
&g
Hi Ian,
Assuming your field is 'Country', try this -
SELECT Country, Count(Country) AS 'Count'
FROM
GROUP BY Country
ORDER BY Country
Noel
--
Noel Lodge
lodg...@gmail.com
On 25 May 2013 19:09, Ian Whitfield wrote:
> Hi All
>
> I have a Database with about 3000 addresses in it an
sure LO is not running when you do
> this.)
>
> Someone else 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
so I went back 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 wrote:
>
>
> Marion & Noel Lodge wrote:
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
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
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, D
Hi Ian,
This is starting to get a bit cluttered so I've used blue for m
y
comments this time. See below.
On 30 March 2013 18:45, Ian Whitfield wrote:
> Thanks again Noel.
>
> Let's give this one more 'go-around'!!
>
>
> On 30/03/13 02:16, Marion & N
where it throws the
error. That may give you a clue as to what is happening.
Good luck!
Noel
--
Noel Lodge
lodg...@gmail.com
On 30 March 2013 02:52, Ian Whitfield wrote:
> Thanks Noel
>
> I appreciate the 'come-back'!!!
>
>
> On 29/03/13 15:13, Marion & Noel L
Whitfield 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 &
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 OpenfMember
ve 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 fa
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 to
he right direction.
Noel
--
Noel Lodge
lodg...@gmail.com
On 21 February 2013 22:16, Alex Thurgood wrote:
> Le 21/02/2013 10:00, Marion & Noel Lodge a écrit :
>
> Hi Noel,
>
> > Can someone tell me what I'm missing?
> >
>
> Not sure, but you could try :
>
&
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
un, Jan 27, 2013 at 4:36 AM, Marion & Noel Lodge wrote:
>
>> 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
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 advantage
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 wa
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 no
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 F
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 Form?
Hi Jay,
On 6 October 2012 14:55, Jay Lozier 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 standard practice. If i
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 is
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 wrote:
> Hi :)
> There is an excellent guide on writing Macros
> http://wiki.documentfoundation.org/Documentation/Publications#Pro
th? They seem to do both similar and
different things.
Thanks again,
Noel
--
Marion & Noel Lodge
lodg...@gmail.com
On 2 July Andreas Säger ville...@t-online.de
via<http://support.google.com/mail/bin/answer.py?hl=en-GB&ctx=mail&answer=1311182>
global.libreoffice.org wrote:
Hel
's and the accountant's life hell for no reason.
> Regards from
> Tom :)
>
>
> --- On Mon, 2/7/12, Marion & Noel Lodge wrote:
>
> From: Marion & Noel Lodge
> Subject: Re: [libreoffice-users] Macro code to highlight a field on a Form
> To: users@global
well 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:
n't seem to be any method
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
87 matches
Mail list logo