Solved

CheckBox Problem In Access97

Posted on 1998-10-15
9
250 Views
Last Modified: 2006-11-17
After conversion of application written in Access 7 to
Access 97 the check-box does not function properly:
clicking on mouse doesn't do anything, but pressing <space> does check the box.

When we "Design" the form and then change to "Form View" it works OK, but when we "Open" directly to form view we encountered this problem

We tried to create a new database in Access97 and to import everything into this new database, but it doesn't solve the problem.

How can we fix this problem ?        
0
Comment
Question by:davidpo
  • 4
  • 4
9 Comments
 
LVL 3

Expert Comment

by:SPECIALIST
Comment Utility
If your sure the code is correct, I would write the names down of each check box, delete them and replace with new boxes, making sure the correct names are attached.  this should solve your problem.

specialist
0
 

Author Comment

by:davidpo
Comment Utility
Even a new check-box on the same form does not function properly.
Only on a new form the check-box  works OK
Of course, it is not reasonable to recreate every form in the application.
0
 
LVL 5

Expert Comment

by:kulikuli
Comment Utility
I would strongly recommend an old (and very often and boring mentioned) trick: create a new database in MS Access97 and import all the objects from the converted database. This will cause MS Access to create all objects using the 97 standards.
0
 

Author Comment

by:davidpo
Comment Utility
As mentioned, we tried this trick first.
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 5

Accepted Solution

by:
kulikuli earned 200 total points
Comment Utility
Sorry for misunderstanding. I suggest you write a function that:
opens each form in the form's documents collection of the database
loops through all the controls
if the control Is TypeOf check then store it's name, controlsource, left and top property in variables
delete the checkbox control
create a new checkbox control using the createcontrol method
put the stored properties' values in that control
save and close the form using the docmd object

It will cost very few lines to code and you don't have to worry about anything when it is finished.
0
 
LVL 5

Expert Comment

by:kulikuli
Comment Utility
If none of your checkboxes works ok (as you mentioned in another comment) then I would consider reinstalling MS Access in the first place. I converted forms from 95 to 97 without any problems considering checkboxes.
0
 

Author Comment

by:davidpo
Comment Utility
We would like to try  kulikulis answer.
Can you add sample code ?
0
 

Author Comment

by:davidpo
Comment Utility
The problem is a BUG in Access 97 which causes this phenomenon when the "Navigation Buttons" property is "No".
0
 
LVL 5

Expert Comment

by:kulikuli
Comment Utility
DavidPo,
I am very happy you got it solved. I guess I just learned something new. Thanks for commenting your own solution. Also many thanks for grading me, although I didn't know about the bug.
I still can't logically explain any link between the navigation buttons and a checkbox, however. Does your solution mean that you HAVE TO have the navigation buttons displayed in order to avoid errors???

Best regards,
kulikuli
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
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…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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

14 Experts available now in Live!

Get 1:1 Help Now