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

2013-07-12 Thread Marion Noel Lodge
@global.libreoffice.org users@global.libreoffice.org *Sent:* Thursday, 11 July 2013, 5:39 *Subject:* Re: [libreoffice-users] Re: Base DB Connections 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

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

2013-07-12 Thread Tom Davies
Tom :)  From: Marion Noel Lodge lodg...@gmail.com To: Tom Davies tomdavie...@yahoo.co.uk Cc: users@global.libreoffice.org users@global.libreoffice.org Sent: Friday, 12 July 2013, 10:39 Subject: Re: [libreoffice-users] Re: Base DB Connections Thanks

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

2013-07-11 Thread Tom Davies
@global.libreoffice.org Sent: Thursday, 11 July 2013, 5:39 Subject: Re: [libreoffice-users] Re: Base DB Connections 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

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

2013-07-10 Thread Marion Noel Lodge
Hi Mark, Here is the code - Sub BtnPrepareBankEntries() Dim sEntryDateAS String Dim sBkStatAS String Dim sBkStatBakAS String Dim aFields(150,7)AS String Dim sKeyAS String Dim aWhoRef(150,7)AS String Dim iCount

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

2013-07-10 Thread Andrew Douglas Pitonyak
Very Nice! On 07/10/2013 09:08 AM, Marion Noel Lodge wrote: Hi Mark, Here is the code - -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

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

[libreoffice-users] Re: Base DB Connections

2013-07-09 Thread Alexander Thurgood
Le 09/07/13 06:46, Mark LaPierre a écrit : Hi Mark, I get a new spreadsheet every week with some duplication of data on each sheet from what was on the previous sheet. I don't want to copy and paste the duplicate data into the main table. I'll have to think about this one for a while.

[libreoffice-users] Re: Base DB Connections

2013-07-09 Thread Alexander Thurgood
Le 07/07/13 21:37, Mark LaPierre a écrit : Any suggestions on how to proceed from here? Do I just copy and paste the data from the spreadsheet directly into the mySQL table? On further reflection, it might be possible to do this by using a macro, in which you connect to the Calc sheet, load

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

2013-07-09 Thread Mark LaPierre
On 9 July 2013 17:46, Alexander Thurgood alex.thurg...@gmail.com wrote: Le 07/07/13 21:37, Mark LaPierre a écrit : Any suggestions on how to proceed from here? Do I just copy and paste the data from the spreadsheet directly into the mySQL table? On further reflection, it might be

[libreoffice-users] Re: Base DB Connections

2013-07-08 Thread Alexander Thurgood
Le 07/07/13 21:37, Mark LaPierre a écrit : Hi Mark, Any suggestions on how to proceed from here? Do I just copy and paste the data from the spreadsheet directly into the mySQL table? You could try this : 1) Open your ODB file, click on the Tables icon so that you can see the list of

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

2013-07-08 Thread Mark LaPierre
On 07/08/2013 02:45 AM, Alexander Thurgood wrote: Le 07/07/13 21:37, Mark LaPierre a écrit : Hi Mark, Any suggestions on how to proceed from here? Do I just copy and paste the data from the spreadsheet directly into the mySQL table? You could try this : 1) Open your ODB file, click on