Solved

Access 2010 form to replicate old Database window not functioning properly

Posted on 2013-02-06
9
359 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
Comment Utility
0
 

Author Comment

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

Expert Comment

by:Dale Fye (Access MVP)
Comment Utility
you're welcome!
0
 

Author Comment

by:Kenjay
Comment Utility
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)
Comment Utility
Yeah, I had to pass that to the IT team at work as well.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

763 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

7 Experts available now in Live!

Get 1:1 Help Now