?
Solved

Problem Listbox Control on Tab Control

Posted on 2005-03-11
5
Medium Priority
?
789 Views
Last Modified: 2008-01-16
I have several access 200x apps with a menu system that utilizes the tab control.  One page of the tab control I have a listbox that lists all of the reports that the user can print.  This has worked fine for several years, but now there is a problem were I cannot select any values from the list box.  I can scroll but otherwise the control behaves as if is not enabled.  All the form, tab and llistbox control properties are fine.  I have cut & pasted and recreated the Listbox.  I have rebuilt the entire form from scratch including the tab control, buttons and listbox.  I have created a new database and imported all the objects.  I have deinstalled and reinstalled Access.  Nothing has helped.

My customer has the previous version of the app and it is fine.  This happened while I was working on an upgrade.  I suspect it is VB-related but I can't prove it.

I have read that the Access Tab control is problematic, but at this point I am out of things to try and could use some help.
0
Comment
Question by:k2jeff
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 54

Expert Comment

by:nico5038
ID: 13521933
Hmm, best to ask your customer for a copy so at least you have a backup and you can check that's also working on your system, as then you know it's system and not database related.

On your system all I can advise it to check for virusses and/or trojans, etc.
Or to do the steps for a corrupted database you didn't do from my list:
MS Access database recovery steps:

1) Create a backup of the corrupt database. (Just in case of)

2) Create a new database and use File/Get external data/Import to get all objects of the damaged database.

3) Try these Microsoft solutions:
Repair A97/A2000:
http://support.microsoft.com/support/kb/articles/Q109/9/53.asp
Jetcomp:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q273956
and/or read the article:
ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;306204

4) Bit "heavier":
Access decompile:
http://www.granite.ab.ca/access/decompile.htm

5) Try a recovery tool / Table rescue
Table datarecovery:
www.mvps.org/access/tables/tbl0018.htm
Access recovery:
http://www.officerecovery.com/access/index.htm

6) Ask a company (will cost $$'s ! )
http://www.pksolutions.com/services.htm 

check also: http://www.granite.ab.ca/access/corruptmdbs.htm


Nic;o)
0
 

Author Comment

by:k2jeff
ID: 13521987
Nic, Thanks.  

I have a copy of the old version in a very safe place.  I have good backup and version management habits... ever since getting bit in the past.

I've been throught the corruption route, but not the last three steps you suggest.  I'll give it a try.

It is interesting that I can copy and paste the Listbox onto a brand new form and it works fine.  It also works on a brand new form on a brand new tab control.  There is some object or code on the menu form that is causing the conflict... possibly some object is corrupt.  I think I will also consider rebuilding the form from scratch (not copy past any objects).  What a pita!

I'll post the results.  Wish me luck!
0
 
LVL 54

Accepted Solution

by:
nico5038 earned 750 total points
ID: 13522010
Hmm, I've had the same behaviour, but found that it would only be solved by no longer using the "old" formname.
Looks like Access "remembers" them somewhere....

Thus perhaps the decompile does solve that, otherwise try living with a new formname...

Nic;o)
0
 

Author Comment

by:k2jeff
ID: 13522162
Well it was a bit tedious, but I was able to create a new working form by copying one item at a time and pasting it to a new form.  Then I copied all the VB code behind the form and pasted it... and the Listbox failed again.  So, the conclusion was that the VB code was corrupt.  So, I did the whole process again, but this time I copied the code to Wordpad, and then copied it from Wordpad and pasted it behind the new form... and...  drum roll while I test...  IT WORKS!

Thanks again for your help.  I'm going to close this and award you the points since you got me thinking about other corruption issues.  It doesn't make sense that VB code can have hidden corruption, but then again there is much about Access that doesn't make sense some times.  If it worked perfectly it wouldn't be as much fun  ;)

k2Jeff Out...
0
 
LVL 54

Expert Comment

by:nico5038
ID: 13523612
Glad I could help, success with the application !

Nic;o)
0

Featured Post

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question