Solved

Access 2010 form to replicate old Database window not functioning properly

Posted on 2013-02-06
9
362 Views
Last Modified: 2013-02-14
Hi-

I'm using Access 2010 and have imported a form that replicates the old database window from Access 2003. I found the form here, listing under number 4:
http://www.accessjunkie.com/Pages/faq_13.aspx

I've attached the database with the form. The form is frmDatabaseWindow. As the source page indicates, you'll need to add the reference MSCOMCTL.OCX in order for the tables, queries, etc. to appear properly.

The columns in the form are supposed to be sortable.  i.e., if you click on "Modified date", it should sort the objects by modified date. They are not sorting for me. Also, when you click on an object in the form, it is supposed to open. That is, if you click on a table name, it should open the table. When I do this, nothing happens.

I should note that when I first imported this form months ago, it was functioning properly. I'm not aware of any changes that would have caused it to stop behaving properly.

Any ideas of why the form is not functioning properly?

Thanks for your help.
DatabaseWindow.zip
0
Comment
Question by:Kenjay
9 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 38859455
the form is working ok here

try doing a decompile
see this link    
http://www.granite.ab.ca/access/decompile.htm

then from VBA window do
Debug>Compile
then
compact and repair of your db
0
 

Author Comment

by:Kenjay
ID: 38861095
Hi-

Thanks for the advice. I tried what you indicated and the form still does not function properly. I should note that the database I originally attached, and the database I'm using now, is the one directly downloaded from the site I mention above. I've tried downloading and using it both on my Work PC and my home laptop, both which use  Windows7 and Access 2010.  I downloaded a fresh copy and found that the form still does not sort and still does not allow me to open up the objects from the form.
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 38861100
Also - has the machine been updated recently (Office or Windows)? If so, one of those updates could have broken the ActiveX controls. Only fix for that would be to rollback the update, or determine which control is broken and see if a hotfix is available.
0
 

Author Closing Comment

by:Kenjay
ID: 38886013
Thanks--I  believe that this is the issue--I think updates on both my personal and work PCs must have broken the ActiveX  controls related to this form.  Will try to investigate further when I get a chance.
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38886040
0
 

Author Comment

by:Kenjay
ID: 38888581
Thank you, fyed!! That did the trick.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38888592
you're welcome!
0
 

Author Comment

by:Kenjay
ID: 38888616
I should note that I fixed it on my personal computer. Now I just have to convince my IT team at work to either make the change, or give me the admin rights to do so. Wish me luck-I'll need it.  ;-)
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 38888630
Yeah, I had to pass that to the IT team at work as well.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

919 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now