Combo Box Problem
in [General]
|
Prev: excel 2000
Next: Raymond
From: Bob Vance on 9 Apr 2010 02:44 Ok No luck there can i force a text box to show Clients Name and make the combo box not visible? Thanks Bob "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message news:kausr51tcvj0b9mhint1ioaip8qh13h6ql(a)4ax.com... > On Fri, 9 Apr 2010 10:20:39 +1200, "Bob Vance" <rjvance(a)ihug.co.nz> wrote: > >>Thanks Guys, When I drag the combo box out on Design view I can see then >>click Form View I see Dobbie,Chris but when i go to save from I am >>getting >>this error "Item cannot be found in the collection corresponding to the >>requeste name or ordinal" and it goes back to just Dobbie >>Thanks Bob > > Sounds like the form has become (or is becoming) corrupt, possibly because > you've been trying so many things. > > Make sure that Name Autocorrect is turned OFF (it can mess things up), > create > a new, empty form, and copy and paste all the controls except this combo > box > onto it. Delete the original form; compact and repair the database, and > recreate this combo, and see if that restores functionality. > -- > > John W. Vinson [MVP]
From: John W. Vinson on 9 Apr 2010 12:49 On Fri, 9 Apr 2010 18:44:26 +1200, "Bob Vance" <rjvance(a)ihug.co.nz> wrote: >Ok No luck there can i force a text box to show Clients Name and make the >combo box not visible? Bob, this is making NO SENSE AT ALL. Of what earthly good would a combo box be if you couldn't see it!?? There are forms in every real Access database ever built using combo boxes to show data. There's something you're not telling us, or not doing correctly. It's like pulling teeth to get any details out of you. This is a *very simple problem* and somehow we've spent a month making it into a monstrously difficult one. Rereading the messages, you posted: ClientID (Number) LastName (Text) FirstName (Text) > > using your own fieldnames. > > 2. What Query did you use for the rowsource? Please open the query in SQL > view > and copy and paste the entire SQL to a message here. > SELECT tblOwnerInfo.OwnerID, IIf(IsNull(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName & ', ') & " " & IIf(IsNull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName) AS ClientName, tblOwnerInfo.OwnerFirstName, tblOwnerInfo.OwnerLastName, tblOwnerInfo.Status FROM tblOwnerInfo ORDER BY IIf(IsNull(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName & ', ') & " " & IIf(IsNull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName); So you have *some* table with fields named ClientID, LastName and FirstName. YOu have some *OTHER* table with fields OwnerID, OwnerLastName and OwnerFirstName. Are these two redundant tables with the same data? Does the first table contain Dobbie's first and last name, and the other table only the last name? Are you posting incorrect and misleading information about your database? Do you understand what's even IN your database????? -- John W. Vinson [MVP]
From: Bob Vance on 9 Apr 2010 18:30 Sorry John , there is no such thing as ClientID its OwnerID which is a number field, It is Frustrating because what I have done is correct, because every time I open my form and move the combo box size and select F5 the combo box is Correct with both names but when I go to save it I get that error message each time Regards Bob Vance I did try making a new form! "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message news:uamur5tv11mhjatsdnnlc9hftpvgmj5fit(a)4ax.com... > On Fri, 9 Apr 2010 18:44:26 +1200, "Bob Vance" <rjvance(a)ihug.co.nz> wrote: > >>Ok No luck there can i force a text box to show Clients Name and make the >>combo box not visible? > > Bob, this is making NO SENSE AT ALL. > > Of what earthly good would a combo box be if you couldn't see it!?? > > There are forms in every real Access database ever built using combo boxes > to > show data. There's something you're not telling us, or not doing > correctly. > It's like pulling teeth to get any details out of you. This is a *very > simple > problem* and somehow we've spent a month making it into a monstrously > difficult one. > > Rereading the messages, you posted: > > ClientID (Number) > LastName (Text) > FirstName (Text) >> >> using your own fieldnames. >> >> 2. What Query did you use for the rowsource? Please open the query in SQL >> view >> and copy and paste the entire SQL to a message here. >> > SELECT tblOwnerInfo.OwnerID, > IIf(IsNull(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName & ', > ') > & " " & > IIf(IsNull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName) AS > ClientName, tblOwnerInfo.OwnerFirstName, tblOwnerInfo.OwnerLastName, > tblOwnerInfo.Status > FROM tblOwnerInfo > ORDER BY > IIf(IsNull(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName & ', > ') > & " " & > IIf(IsNull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName); > > > So you have *some* table with fields named ClientID, LastName and > FirstName. > YOu have some *OTHER* table with fields OwnerID, OwnerLastName and > OwnerFirstName. > > Are these two redundant tables with the same data? > Does the first table contain Dobbie's first and last name, and the other > table > only the last name? > Are you posting incorrect and misleading information about your database? > Do you understand what's even IN your database????? > > -- > > John W. Vinson [MVP]
From: Bob Vance on 10 Apr 2010 22:39
Thanks Guys Fixed It :) Commered out these 2 codes Regards Bob 'cbOwnerName.RowSource = .Fields("OwnerID") & ";" & .Fields("OwnerName") 'If CurrentProject.AllForms("frmActiveHorses").IsLoaded = True Then 'cbOwnerName.value = Form_frmActiveHorses.cboClient.value 'End If "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message news:ekPPARD2KHA.4016(a)TK2MSFTNGP05.phx.gbl... > Sorry John , there is no such thing as ClientID its OwnerID which is a > number field, It is Frustrating because what I have done is correct, > because every time I open my form and move the combo box size and select > F5 the combo box is Correct with both names but when I go to save it I get > that error message each time > Regards Bob Vance > I did try making a new form! > "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message > news:uamur5tv11mhjatsdnnlc9hftpvgmj5fit(a)4ax.com... >> On Fri, 9 Apr 2010 18:44:26 +1200, "Bob Vance" <rjvance(a)ihug.co.nz> >> wrote: >> >>>Ok No luck there can i force a text box to show Clients Name and make the >>>combo box not visible? >> >> Bob, this is making NO SENSE AT ALL. >> >> Of what earthly good would a combo box be if you couldn't see it!?? >> >> There are forms in every real Access database ever built using combo >> boxes to >> show data. There's something you're not telling us, or not doing >> correctly. >> It's like pulling teeth to get any details out of you. This is a *very >> simple >> problem* and somehow we've spent a month making it into a monstrously >> difficult one. >> >> Rereading the messages, you posted: >> >> ClientID (Number) >> LastName (Text) >> FirstName (Text) >>> >>> using your own fieldnames. >>> >>> 2. What Query did you use for the rowsource? Please open the query in >>> SQL >>> view >>> and copy and paste the entire SQL to a message here. >>> >> SELECT tblOwnerInfo.OwnerID, >> IIf(IsNull(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName & ', >> ') >> & " " & >> IIf(IsNull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName) >> AS >> ClientName, tblOwnerInfo.OwnerFirstName, tblOwnerInfo.OwnerLastName, >> tblOwnerInfo.Status >> FROM tblOwnerInfo >> ORDER BY >> IIf(IsNull(tblOwnerInfo.OwnerLastName),'',tblOwnerInfo.OwnerLastName & ', >> ') >> & " " & >> IIf(IsNull(tblOwnerInfo.OwnerFirstName),'',tblOwnerInfo.OwnerFirstName); >> >> >> So you have *some* table with fields named ClientID, LastName and >> FirstName. >> YOu have some *OTHER* table with fields OwnerID, OwnerLastName and >> OwnerFirstName. >> >> Are these two redundant tables with the same data? >> Does the first table contain Dobbie's first and last name, and the other >> table >> only the last name? >> Are you posting incorrect and misleading information about your database? >> Do you understand what's even IN your database????? >> >> -- >> >> John W. Vinson [MVP] > > |