Solved

CheckBox Problem In Access97

Posted on 1998-10-15
9
254 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
ID: 1965445
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
ID: 1965446
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
ID: 1965447
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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:davidpo
ID: 1965448
As mentioned, we tried this trick first.
0
 
LVL 5

Accepted Solution

by:
kulikuli earned 200 total points
ID: 1965449
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
ID: 1965450
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
ID: 1965451
We would like to try  kulikulis answer.
Can you add sample code ?
0
 

Author Comment

by:davidpo
ID: 1965452
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
ID: 1965453
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
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…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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…

830 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