?
Solved

CheckBox Problem In Access97

Posted on 1998-10-15
9
Medium Priority
?
257 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
[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
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

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

Accepted Solution

by:
kulikuli earned 400 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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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…
Suggested Courses

771 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