Hi All
Some advice and comments please.
I'm running a MySQL Database (5.1.55) with Base as the Front-End
(3.6.2.2) on PCLinuxOS (2012).
I have a Membership Database and have added a SubForm to show all the
eMails sent and received from each Member.
The eMails are all in a separate Table.
On my Main "Membership" Form I have added a button to bring-up the eMail
SubForm. (I have this part working!) But what I see as the best way to
do the last step is to add a ListBox named "Find Member" to the SubForm
and this will read from a Query holding the concatanated First Name and
Surname of each Member and that Member's ID Key. Once these are inserted
into the SubForm it will extract all the relative eMails, sort them into
date order and display them.
So - Questions and Advice please on the following...
* Is this the right way to approach this requirement?
* Will the Query update automatically each time it is called so as to
pick-up new eMails?
* How do I make the ListBox 'read' the results of the Query?
* How do I make these results automatically insert into their
respective fields on the SubForm?
* How do I make the SubForm do the sort as a final step? (Maybe a
'Sort' Button??)
Any help, suggestions or comments would be greatly appreciated!!
IanW
Pretoria RSA.
--
For unsubscribe instructions e-mail to: users+help@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
Context
- [libreoffice-users] Base scenario · Ian Whitfield
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.