|
tech
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Table Information No Longer DisplayedWe have an Access2000 database that we have been using for a number of years now. On one of the forms there is a combo box which displays a list of countries which are associated with each of our Customer's address. The row source for this control is a table tbCountry. For some reason when we try to add a new customer and assign a country, nothing is displayed in this combo box for selection. This is a split database with the tbCountry table in the back end. I have tried refreshing the link to the table with no change. However, if I open the front end in design view, I can open the table via the link and the country list is there. Can anyone suggest why the table contents are not being displayed in the combo box please? TIA Phil How many columns does the table have and how many columns does the combo box
have? Which is the bound column? What are the column widths? Have you changed Access versions since it worked before? Show quote "TheScullster" wrote: > Hi all > > We have an Access2000 database that we have been using for a number of years > now. > On one of the forms there is a combo box which displays a list of countries > which are associated with each of our Customer's address. > The row source for this control is a table tbCountry. > For some reason when we try to add a new customer and assign a country, > nothing is displayed in this combo box for selection. > > This is a split database with the tbCountry table in the back end. > I have tried refreshing the link to the table with no change. However, if I > open the front end in design view, I can open the table via the link and the > country list is there. > > Can anyone suggest why the table contents are not being displayed in the > combo box please? > > > TIA > > > Phil > > > "mscertified" wrote
> How many columns does the table have and how many columns does the combo Thanks for response mscertified> box > have? Which is the bound column? What are the column widths? Have you > changed > Access versions since it worked before? > No changes have been made to the database directly, so I do not understand why column widths/bound columns etc would have altered. The only "system" changes that have occurred are: Microsoft updates One user now connects to the back end using the same front end but running on Access2007 (all other users have Access2003) Will check the column info on Monday and revert Phil Users have 2003?
In that case, what you are seeing might be one of the known bugs caused by Office 2003 SP3. http://allenbrowne.com/tips.html (This would also explain the "no changes except MS updates") From reading other posts, it seems that the suggested fix is to open the backend and remove any formatting applied to the problem field at the table level and then reapply any formattinge needed at the form/control level. However, if your 2007 user has the same problem, this might be the wrong tree to bark at. -- Show quoteHTH, George "TheScullster" <phil@dropthespam.com> wrote in message news:Paqdncs2Pv_NUaDaRVnyiwA@eclipse.net.uk... > > "mscertified" wrote > >> How many columns does the table have and how many columns does the combo >> box >> have? Which is the bound column? What are the column widths? Have you >> changed >> Access versions since it worked before? >> > Thanks for response mscertified > > No changes have been made to the database directly, so I do not understand > why column widths/bound columns etc would have altered. > The only "system" changes that have occurred are: > Microsoft updates > One user now connects to the back end using the same front end but running > on Access2007 (all other users have Access2003) > > Will check the column info on Monday and revert > > Phil > "George Nicholson" wrote
Show quote > Users have 2003? George> > In that case, what you are seeing might be one of the known bugs caused by > Office 2003 SP3. > http://allenbrowne.com/tips.html > (This would also explain the "no changes except MS updates") > > From reading other posts, it seems that the suggested fix is to open the > backend and remove any > formatting applied to the problem field at the table level and then > reapply any formattinge needed at the form/control level. > > However, if your 2007 user has the same problem, this might be the wrong > tree to bark at. > -- > HTH, > George Many thanks for comprehensive response. Yes I tried this on a 2007 client and all is well so it looks like the bug is to blame! The formatting is simply a > sign to force upper case country names. Will try removing this from the back end table when all users are out. This may be a minor issue for a smaller player like us, but I could see this sort of sudden change having major impact in very large multi-user environments. Excellent site that allenbrowne.com BTW. Phil  |
|||||||||||||||||||||||
Other interesting topics