Ask Your Question

lucky67's profile - activity

2019-02-15 23:11:41 +0100 answered a question How do I change the order of fields when I edit a table? base 5.0.3.2

I came across this (old) question trying to do the same thing. Not as professional but I found a work around that I foun

2018-12-21 18:11:12 +0100 edited question Update Macros not appearing in dialogue box/disappearing

Macros not appearing in dialogue box/disappearing Running Libre office Version: 5.4.7.2 (x64) Build ID: c838ef25c16710f8

2018-12-21 18:10:14 +0100 received badge  Famous Question (source)
2018-12-21 18:10:14 +0100 received badge  Notable Question (source)
2018-12-21 18:10:14 +0100 received badge  Popular Question (source)
2018-06-27 13:01:44 +0100 asked a question Update Macros not appearing in dialogue box/disappearing

Macros not appearing in dialogue box/disappearing Running Libre office Version: 5.4.7.2 (x64) Build ID: c838ef25c16710f8

2016-09-09 16:16:40 +0100 received badge  Famous Question (source)
2016-07-24 18:03:17 +0100 received badge  Notable Question (source)
2016-07-24 13:12:36 +0100 commented answer Problem with Base split database after upgrading

Thank you - I have my data now. Thinking it might be best and quicker just to start again and re-enter the data. It is new so not a lot in it and I have done all the time consuming planning /design etc. More worried about my other split database - if this is a LO5/windows 10 issue - that has a lot of info in it - would hate to have to start re-entering that....

2016-07-24 13:06:24 +0100 commented answer Problem with Base split database after upgrading

Thank you - I managed to restore the back up copy - the tables are there but so are the queries. I restored to a different file location then delete the 'problem' files/folders - I couldn't delete the driver folder because it said it was in use but I couldn't find where... so I just copied the database folder and the database front end file. Tempted to redo the whole database and keep the access table separately - but l don't want it forgotten and end up in an obsolete format and unusable.

2016-07-23 12:22:29 +0100 received badge  Popular Question (source)
2016-07-23 11:01:27 +0100 commented answer Problem with Base split database after upgrading

Query 1 SELECT * FROM "INFORMATION_SCHEMA"."SYSTEM_TABLES" Query 2 SELECT * FROM "INFORMATION_SCHEMA"."SYSTEM_TABLE_CONSTRAINTS" Query 3 SELECT * FROM "INFORMATION_SCHEMA"."TABLE_CONSTRAINTS"

2016-07-23 10:56:44 +0100 commented answer Problem with Base split database after upgrading

Honestly I can't remember but I know I tried not to link it to my access (XP it worked just in 7 - in 10 I thought it might not...it does though!) I think in the end I did link it then copied to calc and back to the new database file in base? 3 queries came back on their own but I closed without saving and also tried to restore my back up (but think my back up software isn't working properly in 10) I will copy and paste the query SQLs shortly from PC (on tablet so I could faff with laptop)

2016-07-23 10:30:42 +0100 commented answer Problem with Base split database after upgrading

I reset my profile and I'm still having the same issue

2016-07-22 21:12:53 +0100 answered a question Problem with Base split database after upgrading

I meant to say when LO crashes out I get the message libreoffice 5.1 fatal error SEH Exception:ACCESS VIOLATION

2016-07-22 20:57:28 +0100 asked a question Problem with Base split database after upgrading

I've just upgraded to Windows 10 and so upgraded to Libreoffice Version: 5.1.4.2 (Build ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a) I have a split database - it is relatively new. It was made using the wizard here https://forum.openoffice.org/en/forum.... There is a table in it that is basically just an archive - it was originally in Access 02 -it was a bit of a faff to get it into Base -I can't remember how I did it. And a completely new table which I was using. I was happily entering data using a form into the new table and then decided I needed to make a query. When I opened the queries there were 3 queries already there called Query 1-3. They were about system tables or something - don't think I made them? But I guess I could when I was trying to get the archive table into that file. I deleted them -but I've since got them back. I tried to copy and paste my 'in use' new table -basically just temporarily whilst I faffed with the query - to protect it. I couldn't - it didn't like any of the names I tried to call it. I decided to close without saving. Both table names appear but when I click on them they disappear and I get this message 'integrity constraint violation: unique or index violation; SYSTEM_TABLES table: system:SYSTEM_TABLES The form is still there -when I click on it it says the table doesn't exist... Then when I go back to the table view both tables aren't there... It keeps crashing LO I have another independent split database -with no old tables in and that seems to be fine -no mysterious queries or disappearing tables....

Any advice before I roll back to Libre Office 4 and/or Windows 7?

2015-05-27 16:07:58 +0100 received badge  Famous Question (source)
2015-03-22 23:04:18 +0100 received badge  Famous Question (source)
2015-03-22 23:04:18 +0100 received badge  Popular Question (source)
2015-03-22 23:04:18 +0100 received badge  Notable Question (source)
2014-11-30 11:42:48 +0100 received badge  Famous Question (source)
2014-09-03 10:48:00 +0100 received badge  Teacher (source)
2014-09-03 10:48:00 +0100 received badge  Self-Learner (source)
2014-09-02 13:37:40 +0100 answered a question Mail merge send emails

Hi I've worked it out so posting in case anyone else needs a reminder -it was just the password that needed changing and as I suspect easy enough to do if you know where to look. It is under Tools/Options/LibreOfficeWriter/Mail Merge Email Then all pretty straight forward ... Hope that helps someone else - and sorry for being stupid...just panicking and couldn't see it ... Thanks.

2014-09-02 12:32:33 +0100 asked a question Mail merge send emails

Hi Help! I've done this successfully before but struggling now up against a deadline! I suspect it might be pretty easy but I just can't find out how to do it... Two things have changed. First (and I don't think this is the problem) I've updated to libre office Version: 4.2.6.3, Build ID: 3fd416d4c6db7d3204c17ce57a1d70f6e531ee21 Secondly the password on the google account has been changed....which I am pretty sure is causing the problem...

So I have mail merge emails to send from a Google email account - it is a shared account, not my usual one. And they won't go. In the error message it is trying to sent them from the correct email account.
I can't remember how to change the settings - so change the password . Think more confusing because I have thunderbird desktop. The google account I want to use is not linked to this but my personal email accounts are. If I try and open send to it is automatically opening thunderbird... I can't remember if I had to change this in the past ...and the update has changed it back to Thunderbird being the default or something....or if there is a completely different way of setting up emails for the mail merge ...

Have tried the help - it isn't helping ...I need the idiot's guide!

Any ideas?

2014-03-28 03:32:26 +0100 received badge  Notable Question (source)
2014-03-26 20:09:29 +0100 received badge  Popular Question (source)
2014-03-26 19:41:43 +0100 answered a question Writer - Paste two tables on one page? - or reveal codes?

Thanks Regina but I had made new simple tables in the converted doc so it wasn't a MS word table/table in a frame I was using.

In the new file under table properties, text flow the 'break' was selected (why I don't know!). I unchecked it and can now paste more than one table on a page.

However when I went back to the converted file 'break' wasn't highlighted and no matter what I did (saving as an odt etc, checking the box and unchecking , making a new table etc) I couldn't get more than one table on a page! I managed by having both files open next to each other and dragging across but it would have been easier if I could have done it within one file...

A 'reveal codes' option would be incredibly useful as even then the occasional 'odd' format happened - solved by undoing paste and just typing that bit of text in ...

(Sure problem is with Word adding random rubbish rather than Libre office though - if only I could persuade everyone to dump MS office the world would be happier place!)

2014-03-26 13:00:28 +0100 asked a question Writer - Paste two tables on one page? - or reveal codes?

I have a document containing lots of identical tables, same headings but containing different text. It was a pdf, it has been converted to word. During conversion the tables were converted to drawings so I have had to deleted them, also it contains lots of column breaks etc...

I am trying to insert new tables and copying the text into them. And it isn't going well! There is obviously hidden formatting...driving me insane! (I do have the paragraph marks, tabs etc displayed)

So I have made a new doc, and am pasting the text from the original converted doc into it. I have made a new table and pasted the text into it - if I copy it and paste the table it goes onto the next page - even though there is enough space for two tables on the page...

It could just be a simple setting for the tables?

Or some code in the converted doc transferring across...from reading around I don't think you can do reveal codes? or am I wrong? If I could it would make my life easier as I could use the converted doc...

Using windows 7 home premium, Libre office Version 4.0.3.3 (I know it needs updating - got a year end next week so will update after I've got that done in case anything goes haywire!)

2014-03-26 11:51:03 +0100 received badge  Notable Question (source)
2013-11-29 16:45:17 +0100 received badge  Popular Question (source)
2013-11-28 11:41:32 +0100 received badge  Editor (source)
2013-11-28 11:40:07 +0100 asked a question Bug? or me? - default open path...

I don't use windows 'my documents' I have a folder on my d drive for data called 'asafedocs' Within this I have about 14 folders which all contain many more folders, personal and ones to do with different groups I'm involved with.

I had Libreoffice set up to go to 'asafedocs' if I wanted to open a file from the tool bar/file menu. It suddenly started to go to one of my folders within asafedocs (a very specific one! - and not one of my frequent use ones but I have used relatively recently).

Been a minor irritation for a few weeks and it was doing it from all programs (would have been using writer for files in that folder - to save a mail merge linked to Access 2002 - can't do queries in base yet!)

Finally got round to sorting it out. Went to tools/options/libreoffice/paths from the main page, calc, writer, impress - they all said the my documents path was d:\asafedocs. After looking around, looking at help pages, 'editing' the path, restarting etc, I clicked on 'default' , restarted, edited my documents path back to d:\asafedocs and restarted.

Now 'open' is taking me to me asafedocs again. YIPEE

But does anyone know if I 'did' something by accident - or if it is a (minor) bug? Thanks! Using windows 7 , libreoffice version 4.0.3.3 (awaiting update...)

Further update: Just done another mail merge (different file and database) and the same has happened again. Clicking on open now goes to the file containing the saved mail merge document. I think it must be a bug. ( when mail merging I find if you save as a single merged document, it saves it but the merged document is also an open untitled file. I usually make changes to this, which I then 'save as' and overwite the saved merged doc. )