Re: [libreoffice-users] BASIC Runtime Error. Object Variable not set
On 29/01/11 17:10, Keith Bates wrote: Hi, I just installed libre office 3.3 on my computer running Ubuntu 10.10. I have a macro written in openoffice and running perfectly for many years. It now returns the above error. The macro is activated by a button on a form that adds a record to a database. Basically it reads the last record and enters some of the fields into the form for the new record. Can you tell me how to fix this please? Thank you. Well I didn't get any replies, but the strangest thing has happened... After entering yesterday's data directly into the table, today the form works. Very strange. -- God bless you Keith Bates 4 Mooloobar St Narrabri 2390 Ask Jesus into your life He is The Way, The Truth and The Life -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] BASIC Runtime Error. Object Variable not set
Lol, that is soo often the way! I was hoping someone else would have a good answer so i stayed quiet. With Windows it's often the old reboot fixes everything trick. OpenSource gets updated quite a bit or just seems to fix itself by other magic. Congrats and regards from Tom :) From: Keith Bates ke...@new-life.org.au To: users@libreoffice.org Sent: Sun, 30 January, 2011 6:35:14 Subject: Re: [libreoffice-users] BASIC Runtime Error. Object Variable not set On 29/01/11 17:10, Keith Bates wrote: Hi, I just installed libre office 3.3 on my computer running Ubuntu 10.10. I have a macro written in openoffice and running perfectly for many years. It now returns the above error. The macro is activated by a button on a form that adds a record to a database. Basically it reads the last record and enters some of the fields into the form for the new record. Can you tell me how to fix this please? Thank you. Well I didn't get any replies, but the strangest thing has happened... After entering yesterday's data directly into the table, today the form works. Very strange. -- God bless you Keith Bates 4 Mooloobar St Narrabri 2390 Ask Jesus into your life He is The Way, The Truth and The Life -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] BASIC Runtime Error. Object Variable not set
Sadly rebooting didn't magic it this time, and I certainly don't understand why manually entering the data did. But it works. Keith On 30/01/11 17:47, Tom Davies wrote: Lol, that is soo often the way! I was hoping someone else would have a good answer so i stayed quiet. With Windows it's often the old reboot fixes everything trick. OpenSource gets updated quite a bit or just seems to fix itself by other magic. Congrats and regards from Tom :) From: Keith Bateske...@new-life.org.au To: users@libreoffice.org Sent: Sun, 30 January, 2011 6:35:14 Subject: Re: [libreoffice-users] BASIC Runtime Error. Object Variable not set On 29/01/11 17:10, Keith Bates wrote: Hi, I just installed libre office 3.3 on my computer running Ubuntu 10.10. I have a macro written in openoffice and running perfectly for many years. It now returns the above error. The macro is activated by a button on a form that adds a record to a database. Basically it reads the last record and enters some of the fields into the form for the new record. Can you tell me how to fix this please? Thank you. Well I didn't get any replies, but the strangest thing has happened... After entering yesterday's data directly into the table, today the form works. Very strange. -- God bless you Keith Bates 4 Mooloobar St Narrabri 2390 Ask Jesus into your life He is The Way, The Truth and The Life -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** -- God bless you Keith Bates 4 Mooloobar St Narrabri 2390 Ask Jesus into your life He is The Way, The Truth and The Life -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***