Prev: Password protection
Next: Missing files
From: Bob H on 31 May 2010 04:50 I created/inserted a combo box on my form to select records from the form. So the combo box has a list of records from the querry, and when I select a record from the combo box, all the rest of the data/information about that said record is then shown on the form. Which sample Microsoft database are you referring to, because I have looked at the Northwind database and it looks like it is an mdb file. Thanks On 31/05/2010 00:24, Tom van Stiphout wrote: > On Sun, 30 May 2010 20:58:01 +0100, Bob H<bob(a)despammer.com> wrote: > > OK, back to the original problem. You wrote: "when I select a record > from the list, it is not shown on the form". > What do you mean by that? I'm thinking you have a combobox, you drop > down the list, select an item, and the dropdown closes and the item is > shown in the combobox. Correct so far? If not, tell us the rowsource, > columncount, columnwidths, and boundcolumn properties. > > Do you have the same problem with a sample database downloaded from > Microsoft? > > -Tom. > Microsoft Access MVP > > >> I have also just converted the mdb database back to an accdb database, >> then converted to an accde database. The combo box still does not work >> as it should. >> >> Why is this. >> >> Thanks >> >> On 30/05/2010 19:12, Bob H wrote: >>> I added a Trusted Location, then re did? the mde conversion. I don't get >>> the error message now, but neither does the combo box work as it should >>> either. >>> >>> Thanks anyway >>> >>> On 30/05/2010 18:22, Tom van Stiphout wrote: >>>> On Sun, 30 May 2010 18:00:40 +0100, Bob H<bob(a)despammer.com> wrote: >>>> >>>> Did you put the database in a Trusted Location (see help file)? >>>> >>>> -Tom. >>>> Microsoft Access MVP >>>> >>>> >>>>> I have just converted a mdb database in Access 2007 to a mde file, but >>>>> now the said database does not work correctly. When I opened up the mde >>>>> database, I got a message from Access 2007 saying there was a potential >>>>> security concern, and I clicked the ok button to open up the database. >>>>> Now the combo box to find records does not function, as when I select a >>>>> record from the list, it is not shown on the form. >>>>> >>>>> Thanks >>>
From: Tom van Stiphout on 31 May 2010 14:42 On Mon, 31 May 2010 09:50:47 +0100, Bob H <bob(a)despammer.com> wrote: Your combobox should be unbound (the ControlSource should be empty). Then check out this article: http://www.mvps.org/access/forms/frm0005.htm MDB or ACCDB, the techniques are the same. I was just checking if you have problems with ANY combobox. -Tom. Microsoft Access MVP >I created/inserted a combo box on my form to select records from the >form. So the combo box has a list of records from the querry, and when I >select a record from the combo box, all the rest of the data/information >about that said record is then shown on the form. > >Which sample Microsoft database are you referring to, because I have >looked at the Northwind database and it looks like it is an mdb file. > >Thanks > >On 31/05/2010 00:24, Tom van Stiphout wrote: >> On Sun, 30 May 2010 20:58:01 +0100, Bob H<bob(a)despammer.com> wrote: >> >> OK, back to the original problem. You wrote: "when I select a record >> from the list, it is not shown on the form". >> What do you mean by that? I'm thinking you have a combobox, you drop >> down the list, select an item, and the dropdown closes and the item is >> shown in the combobox. Correct so far? If not, tell us the rowsource, >> columncount, columnwidths, and boundcolumn properties. >> >> Do you have the same problem with a sample database downloaded from >> Microsoft? >> >> -Tom. >> Microsoft Access MVP >> >> >>> I have also just converted the mdb database back to an accdb database, >>> then converted to an accde database. The combo box still does not work >>> as it should. >>> >>> Why is this. >>> >>> Thanks >>> >>> On 30/05/2010 19:12, Bob H wrote: >>>> I added a Trusted Location, then re did? the mde conversion. I don't get >>>> the error message now, but neither does the combo box work as it should >>>> either. >>>> >>>> Thanks anyway >>>> >>>> On 30/05/2010 18:22, Tom van Stiphout wrote: >>>>> On Sun, 30 May 2010 18:00:40 +0100, Bob H<bob(a)despammer.com> wrote: >>>>> >>>>> Did you put the database in a Trusted Location (see help file)? >>>>> >>>>> -Tom. >>>>> Microsoft Access MVP >>>>> >>>>> >>>>>> I have just converted a mdb database in Access 2007 to a mde file, but >>>>>> now the said database does not work correctly. When I opened up the mde >>>>>> database, I got a message from Access 2007 saying there was a potential >>>>>> security concern, and I clicked the ok button to open up the database. >>>>>> Now the combo box to find records does not function, as when I select a >>>>>> record from the list, it is not shown on the form. >>>>>> >>>>>> Thanks >>>>
From: Bob H on 1 Jun 2010 08:56
The combobox is unbound, and I have a button which brings up a subform, that also doesn't work in the mde file. I think I'll leave it as an mdb file for the moment. Thanks On 31/05/2010 19:42, Tom van Stiphout wrote: > On Mon, 31 May 2010 09:50:47 +0100, Bob H<bob(a)despammer.com> wrote: > > Your combobox should be unbound (the ControlSource should be empty). > Then check out this article: > http://www.mvps.org/access/forms/frm0005.htm > > MDB or ACCDB, the techniques are the same. I was just checking if you > have problems with ANY combobox. > > -Tom. > Microsoft Access MVP > > >> I created/inserted a combo box on my form to select records from the >> form. So the combo box has a list of records from the querry, and when I >> select a record from the combo box, all the rest of the data/information >> about that said record is then shown on the form. >> >> Which sample Microsoft database are you referring to, because I have >> looked at the Northwind database and it looks like it is an mdb file. >> >> Thanks >> >> On 31/05/2010 00:24, Tom van Stiphout wrote: >>> On Sun, 30 May 2010 20:58:01 +0100, Bob H<bob(a)despammer.com> wrote: >>> >>> OK, back to the original problem. You wrote: "when I select a record >>> from the list, it is not shown on the form". >>> What do you mean by that? I'm thinking you have a combobox, you drop >>> down the list, select an item, and the dropdown closes and the item is >>> shown in the combobox. Correct so far? If not, tell us the rowsource, >>> columncount, columnwidths, and boundcolumn properties. >>> >>> Do you have the same problem with a sample database downloaded from >>> Microsoft? >>> >>> -Tom. >>> Microsoft Access MVP >>> >>> >>>> I have also just converted the mdb database back to an accdb database, >>>> then converted to an accde database. The combo box still does not work >>>> as it should. >>>> >>>> Why is this. >>>> >>>> Thanks >>>> >>>> On 30/05/2010 19:12, Bob H wrote: >>>>> I added a Trusted Location, then re did? the mde conversion. I don't get >>>>> the error message now, but neither does the combo box work as it should >>>>> either. >>>>> >>>>> Thanks anyway >>>>> >>>>> On 30/05/2010 18:22, Tom van Stiphout wrote: >>>>>> On Sun, 30 May 2010 18:00:40 +0100, Bob H<bob(a)despammer.com> wrote: >>>>>> >>>>>> Did you put the database in a Trusted Location (see help file)? >>>>>> >>>>>> -Tom. >>>>>> Microsoft Access MVP >>>>>> >>>>>> >>>>>>> I have just converted a mdb database in Access 2007 to a mde file, but >>>>>>> now the said database does not work correctly. When I opened up the mde >>>>>>> database, I got a message from Access 2007 saying there was a potential >>>>>>> security concern, and I clicked the ok button to open up the database. >>>>>>> Now the combo box to find records does not function, as when I select a >>>>>>> record from the list, it is not shown on the form. >>>>>>> >>>>>>> Thanks >>>>> |