OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[SOLVED] Use Find Record (Binoculars) on a listbox

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
cazbym
Power User
Power User


Joined: 16 Mar 2009
Posts: 63

PostPosted: Sun Apr 08, 2012 11:51 pm    Post subject: [SOLVED] Use Find Record (Binoculars) on a listbox Reply with quote

I have searched the forums but cannot seem to find an answer to this one.

I have a table with two fields ID (PK) and Name (VARCHAR).

I have a form with a table control displaying just ONE listbox based on SQL - Name , ID, which displays all the Names. (The ID field is required as it is picked up by a macro which then opens and filters another form based on another table.

My problem is - is it possible to use "Find Record" to search through the listbox. I have been trying to find "Fred Bloggs", but it says no records match, because presumably it is actually searching the ID field.


Last edited by cazbym on Tue Apr 10, 2012 12:52 am; edited 3 times in total
Back to top
View user's profile Send private message
Billyray
OOo Enthusiast
OOo Enthusiast


Joined: 06 Mar 2007
Posts: 144
Location: Lake Erie's Shore in Ohio

PostPosted: Mon Apr 09, 2012 1:46 pm    Post subject: Reply with quote

Can you sort the Name alphabetically, then use a combo box? Then you can start typing the name and it will automatically fill in the rest of the name. (find the record) I'm doing that with a large list of names.
_________________
Billyray
using:
Linux distro: Ubuntu 10.04 LTS, Lucid Lynx, OOo Base 3.3, connected to MySql database using Java jdbc (note: ONLY sun-java-6-1.6.0_22 jre works right), and converted from MS Access 2003.
Back to top
View user's profile Send private message
dacm
Super User
Super User


Joined: 07 Jan 2010
Posts: 769

PostPosted: Mon Apr 09, 2012 4:33 pm    Post subject: Reply with quote

Billyray wrote:
...start typing the name and it will automatically fill in the rest of the name.

Typing into a List Box jumps to the relevant record as well.
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Splitting 'Embedded databases'
Back to top
View user's profile Send private message
cazbym
Power User
Power User


Joined: 16 Mar 2009
Posts: 63

PostPosted: Tue Apr 10, 2012 12:50 am    Post subject: Reply with quote

Thanks for responses - the answer for me was to check the "apply field format" in the "find record" options. Thought I had already tried that before but apparently not. Rolling Eyes
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group