Re: [libreoffice-users] LO Base Problem

On 18/02/2015 15:23, Ian Whitfield wrote:
> *Hi All*
>
> I have been rebuilding/revamping my Database over the past few weeks 
> and everything has been going great.
> I'm using LO 4.3.5.2 and MySQL 5.1.73 on PClinuxOS (latest).
>
> Yesterday I found I had not set my Keyfield (RecordID) to Auto 
> Increment so I set a new field with phpMyAdmin called 'id'. And this 
> is now working fine and Auto incrementing. I deleted the old RecordID 
> field.
>
> Now many of my fields are greyed out in the Form and will not accept 
> input and all my drop-down boxes are inactive.
probably in your "data" properties from the greyedout ListBoxcontrols 
you have used in a sql statement the name off the deleted field or the 
data connection is based on this deleted fields ?

Hope it helps

fernand
> I created a new temporary Form (using the Wizard) and it works fine 
> and displays all fields. But as soon as I replace a field with a 
> drop-down or Combo Box box that box becomes inactive again and is 
> greyed out and will not display the options.
>
> I've looked everywhere in the field properties but can find no obvious 
> cause.
>
> Anyone have any ideas please?? Thanks.
>
> IanW
> Pretoria RSA


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted