Form problem
|
View:
New views
15 Messages
—
Rating Filter:
Alert me
|
 |
Form problem
by Clifton Liles
::
Rate this Message:
Hi All
Sorry about the weak subject, but I don't know what to call it. The problem: I have a table of DVDs and a table of genres. One of the items in the DVD table is genre. The table of genres has an ID, genre ( MYST, HIS, ACT, SIFI, ...), and a name ( Mystery, Historical, Action, Science Fiction, ...) . I have a form called Input that I use to enter new DVDs. I can also use this form to view DVDs. It has a Genre input box. What I would like to do is: If the current 'genre' "IS EMPTY" THEN display the list genres from the genre table, showing the full name and when selected enter the genre in the DVD genre table. ELSE show the current entry. OK this is somewhat confusing. If DVD_genre is not empty show that. IF it is empty the show a selection list from the GenreTable. Show the full name and insert the abbreviation in the DVD_Table. I thought I use BASIC but all I see in the form editor is SQL and some others I don't think will work ( I could be wrong). Any thought and or suggestions would be appreciated. Thanks Cliff -- mailto: c.liles@... Clifton R. Liles "Software to the Stars" lilescr@... Pearland, TX 77581 c.r.liles@... c.liles@... - Speaking for myself! Standard disclaimer applies. - This address may *not* be used for unsolicited mailings. Failure is not an option. It comes bundled with your Microsoft products. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Form problem
by Drew Jensen-4
::
Rate this Message:
Hi Clifton,
I think this will answer your question: http://showmedo.com/videotutorials/video?name=1120050&fromSeriesID=112 Best wishes, Drew --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Form problem
by JZA
::
Rate this Message:
Andrew Pitonyak toucnh on other things beside the SQL and go into
using forms. I havent read it thoroughly but I hope it helps. http://www.pitonyak.org/database/ On Sun, May 31, 2009 at 8:33 PM, Clifton Liles <c.liles@...> wrote: > Hi All > Sorry about the weak subject, but I don't know what to call it. > The problem: > I have a table of DVDs and a table of genres. One of the items in the DVD > table is genre. The table of genres has an ID, genre ( MYST, HIS, ACT, > SIFI, ...), and a name ( Mystery, Historical, Action, Science Fiction, ...) > . > I have a form called Input that I use to enter new DVDs. I can also use this > form to view DVDs. It has a Genre input box. What I would like to do is: > If the current 'genre' "IS EMPTY" THEN display the list genres from the > genre table, showing the full name and when selected enter the genre in the > DVD genre table. ELSE show the current entry. OK this is somewhat > confusing. > If DVD_genre is not empty show that. IF it is empty the show a selection > list from the GenreTable. Show the full name and insert the abbreviation in > the DVD_Table. > > I thought I use BASIC but all I see in the form editor is SQL and some > others I don't think will work ( I could be wrong). > Any thought and or suggestions would be appreciated. Thanks > Cliff > > -- > mailto: c.liles@... > Clifton R. Liles "Software to the Stars" lilescr@... > Pearland, TX 77581 c.r.liles@... c.liles@... > - Speaking for myself! Standard disclaimer applies. - > This address may *not* be used for unsolicited mailings. > Failure is not an option. It comes bundled with your Microsoft products. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > > -- Alexandro Colorado OpenOffice.org Español IM: jza@... --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Form problem
by Clifton Liles
::
Rate this Message:
Alexandro Colorado wrote:
> Andrew Pitonyak toucnh on other things beside the SQL and go into > using forms. I havent read it thoroughly but I hope it helps. > > http://www.pitonyak.org/database/ > > On Sun, May 31, 2009 at 8:33 PM, Clifton Liles <c.liles@...> wrote: > >> Hi All >> Sorry about the weak subject, but I don't know what to call it. >> The problem: >> I have a table of DVDs and a table of genres. One of the items in the DVD >> table is genre. The table of genres has an ID, genre ( MYST, HIS, ACT, >> SIFI, ...), and a name ( Mystery, Historical, Action, Science Fiction, ...) >> . >> I have a form called Input that I use to enter new DVDs. I can also use this >> form to view DVDs. It has a Genre input box. What I would like to do is: >> If the current 'genre' "IS EMPTY" THEN display the list genres from the >> genre table, showing the full name and when selected enter the genre in the >> DVD genre table. ELSE show the current entry. OK this is somewhat >> confusing. >> If DVD_genre is not empty show that. IF it is empty the show a selection >> list from the GenreTable. Show the full name and insert the abbreviation in >> the DVD_Table. >> >> I thought I use BASIC but all I see in the form editor is SQL and some >> others I don't think will work ( I could be wrong). >> Any thought and or suggestions would be appreciated. Thanks >> Cliff >> >> -- >> mailto: c.liles@... >> Clifton R. Liles "Software to the Stars" lilescr@... >> Pearland, TX 77581 c.r.liles@... c.liles@... >> - Speaking for myself! Standard disclaimer applies. - >> This address may *not* be used for unsolicited mailings. >> Failure is not an option. It comes bundled with your Microsoft products. >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: users-unsubscribe@... >> For additional commands, e-mail: users-help@... >> >> >> > > > > Yes, I too have Andrew Pitonyak's AndrewBase and have not completely read it. I have looked through it and have not found what I am looking for, or at least I did not recognize it. I'll keep looking, but I was hopping for a few suggestions or hints. Thanks Cliff -- mailto: c.liles@... Clifton R. Liles "Software to the Stars" lilescr@... Pearland, TX 77581 c.r.liles@... c.liles@... - Speaking for myself! Standard disclaimer applies. - This address may *not* be used for unsolicited mailings. Failure is not an option. It comes bundled with your Microsoft products. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Form problem
by drewjensen
::
Rate this Message:
Well try this again...seems everything I send from Linux is being held up...
Take a look at this video - it covers how to use a list box to do what you want. http://showmedo.com/videotutorials/video?name=1120050&fromSeriesID=112 hth Drew --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Form problem
by Marc Santhoff
::
Rate this Message:
Am Montag, den 01.06.2009, 16:12 -0400 schrieb Drew Jensen:
> Well try this again...seems everything I send from Linux is being held up... > > Take a look at this video - it covers how to use a list box to do what > you want. > http://showmedo.com/videotutorials/video?name=1120050&fromSeriesID=112 This may sound sort of heretical, but there is a chapter in the online help on this topic, so hitting the F1 key would suffice? Cheers, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Form problem
by Drew Jensen
::
Rate this Message:
Marc Santhoff wrote:
> Am Montag, den 01.06.2009, 16:12 -0400 schrieb Drew Jensen: > >> Well try this again...seems everything I send from Linux is being held up... >> >> Take a look at this video - it covers how to use a list box to do what >> you want. >> http://showmedo.com/videotutorials/video?name=1120050&fromSeriesID=112 >> > > This may sound sort of heretical, but there is a chapter in the online > help on this topic, so hitting the F1 key would suffice? > > Cheers, > Marc > > ROFL - you know that honestly didn't cross my mind Question I would have for you is this - How would he know to even look up the information on the listbox control? --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Form problem
by Marc Santhoff
::
Rate this Message:
Am Dienstag, den 02.06.2009, 07:39 -0400 schrieb Drew Jensen:
> Marc Santhoff wrote: > > Am Montag, den 01.06.2009, 16:12 -0400 schrieb Drew Jensen: > > > >> Well try this again...seems everything I send from Linux is being held up... > >> > >> Take a look at this video - it covers how to use a list box to do what > >> you want. > >> http://showmedo.com/videotutorials/video?name=1120050&fromSeriesID=112 > >> > > > > This may sound sort of heretical, but there is a chapter in the online > > help on this topic, so hitting the F1 key would suffice? > > > > Cheers, > > Marc > > > > > > ROFL - you know that honestly didn't cross my mind > > Question I would have for you is this > - How would he know to even look up the information on the listbox control? Good question. It can be found at the topic "Unterfomulare" (subforms). Hitting F1 with a combobox selected in form design mode leads to the index tab being displayed. Dunno what happens when the wizard jumps in. So at least he'd have to know that he wants to design a subform relation ... Marc --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Form problem
by Clifton Liles
::
Rate this Message:
Marc Santhoff wrote:
> Am Montag, den 01.06.2009, 16:12 -0400 schrieb Drew Jensen: > >> Well try this again...seems everything I send from Linux is being held up... >> >> Take a look at this video - it covers how to use a list box to do what >> you want. >> http://showmedo.com/videotutorials/video?name=1120050&fromSeriesID=112 >> > > This may sound sort of heretical, but there is a chapter in the online > help on this topic, so hitting the F1 key would suffice? > > Cheers, > Marc > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > > > F1 or Help has done very little to help me. I've been through the help files several times and have found no solutions. Cliff -- mailto: c.liles@... Clifton R. Liles "Software to the Stars" lilescr@... Pearland, TX 77581 c.r.liles@... c.liles@... - Speaking for myself! Standard disclaimer applies. - This address may *not* be used for unsolicited mailings. Failure is not an option. It comes bundled with your Microsoft products. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Form problem
by Clifton Liles
::
Rate this Message:
Drew Jensen wrote:
> Well try this again...seems everything I send from Linux is being held > up... > > Take a look at this video - it covers how to use a list box to do what > you want. > http://showmedo.com/videotutorials/video?name=1120050&fromSeriesID=112 > > > hth > > Drew > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > > It took a while but I looked at the video. In fact I looked at all fifteen of them. I think I learned that what I was trying to do is not the "right" way to implement it. Alas, I see how it should be done, but since my database is mostly done I'll leave it the way I have it now. On the positive side, I did learn several new thing watching the videos. I would recommend them to any one starting out in Base. Thanks for the tip. Cliff -- mailto: c.liles@... Clifton R. Liles "Software to the Stars" lilescr@... Pearland, TX 77581 c.r.liles@... c.liles@... - Speaking for myself! Standard disclaimer applies. - This address may *not* be used for unsolicited mailings. Failure is not an option. It comes bundled with your Microsoft products. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Form problem
by drewjensen
::
Rate this Message:
Clifton Liles wrote:
> Drew Jensen wrote: >> >> Take a look at this video - it covers how to use a list box to do >> what you want. >> http://showmedo.com/videotutorials/video?name=1120050&fromSeriesID=112 >> >> > > ... In fact I looked at all fifteen of them. .....I would recommend > them to any one starting out in Base. Howdy Clifton, I'm glad you found the videos useful. @Question to the group - Do we have an easily found link to these on the OO.o documentation pages? (areas in the wiki, etc) - Should we? Drew --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Form problem
by Clifton Liles
::
Rate this Message:
Drew Jensen wrote:
> Clifton Liles wrote: >> Drew Jensen wrote: >>> >>> Take a look at this video - it covers how to use a list box to do >>> what you want. >>> http://showmedo.com/videotutorials/video?name=1120050&fromSeriesID=112 >>> >>> >> >> ... In fact I looked at all fifteen of them. .....I would recommend >> them to any one starting out in Base. > > Howdy Clifton, > > I'm glad you found the videos useful. > > @Question to the group > - Do we have an easily found link to these on the OO.o documentation > pages? (areas in the wiki, etc) > - Should we? > > Drew > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > > If there is such a link, I have not found it! And Yes there should be. Maybe a web page with the various links and a short description of what they are. Cliff -- mailto: c.liles@... Clifton R. Liles "Software to the Stars" lilescr@... Pearland, TX 77581 c.r.liles@... c.liles@... - Speaking for myself! Standard disclaimer applies. - This address may *not* be used for unsolicited mailings. Failure is not an option. It comes bundled with your Microsoft products. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Form problem
by John Meyer-8
::
Rate this Message:
Thanks for the video. I was looking for a solution like this, but I have
a problem. The table that I have has several fields, and a meaningful drop down list would have to include two of those fields. Now I got around the limits by using a view and CONCAT(), but CONCAT can only take two input items and I need three (field1 + space + field2). Is there any way around that. Drew Jensen wrote: > Clifton Liles wrote: >> Drew Jensen wrote: >>> >>> Take a look at this video - it covers how to use a list box to do >>> what you want. >>> http://showmedo.com/videotutorials/video?name=1120050&fromSeriesID=112 >>> >>> >> >> ... In fact I looked at all fifteen of them. .....I would recommend >> them to any one starting out in Base. > > Howdy Clifton, > > I'm glad you found the videos useful. > > @Question to the group > - Do we have an easily found link to these on the OO.o documentation > pages? (areas in the wiki, etc) > - Should we? > > Drew > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Form problem
by Frank Schoenheit, Sun Microsystems Germany
::
Rate this Message:
Hi John,
> Now I got > around the limits by using a view and CONCAT(), but CONCAT can only take > two input items and I need three (field1 + space + field2). Is there > any way around that. nest them: CONCAT( CONCAT( ..., ... ), ... ) Ciao Frank -- - Frank Schönheit, Software Engineer frank.schoenheit@... - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Form problem
by John Meyer-8
::
Rate this Message:
Frank Schönheit - Sun Microsystems Germany wrote:
> Hi John, > > >> Now I got >> around the limits by using a view and CONCAT(), but CONCAT can only take >> two input items and I need three (field1 + space + field2). Is there >> any way around that. >> > > nest them: > CONCAT( CONCAT( ..., ... ), ... ) > > Ciao > Frank > > Thanks. I tried that at first before sending off the e-mail and the HSQL engine screamed at me. Switched out the space to be enclosed in single quotations and it worked fine. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
| Free embeddable forum powered by Nabble | Forum Help |
