Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-25-2013, 08:14 AM   #1
Tango
DB/Application Dev Newbie
 
Join Date: Jun 2011
Location: Sumter, South Carolina
Posts: 141
Thanks: 27
Thanked 1 Time in 1 Post
Tango is on a distinguished road
Odd... Anyone seen this?

I have a simple form based on a one-to-one query on two tables. For some odd reason it suddenly started acting "strangely" and I have not been able to nail down why.

The first field on the form is automatically selected (normal).

When the form is open. The problem is that if you attempt to edit the value of that field it beeps at you (not normal).

If the user selects the 2nd field on the form and then goes back to the first field they can edit the first fields values without any beeping. Both the 1st and 2nd fields are from the same table.

-------
The form is setup to allow additions or edits of values as is the query. Not sure what's going on. Anyone seen this?



edit---- The form does not use subforms of any kind.

__________________
---------------
If I helped you, please click thanks or the balance scales on my post.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Tango is offline   Reply With Quote
Old 01-25-2013, 08:28 AM   #2
mdlueck
Sr. Application Developer
 
Join Date: Jun 2011
Posts: 2,625
Thanks: 114
Thanked 296 Times in 283 Posts
mdlueck will become famous soon enough mdlueck will become famous soon enough
Re: Odd... Anyone seen this?

Do you have any VBA on this Form? If so, set some break points to see what events are getting fired.

Try making a backup copy of the database and decompile it:

NT Command Script and Documented Steps to Decompile / Compact / Compile an Access DB
http://www.access-programmers.co.uk/...d.php?t=219948
__________________
--
Michael Lueck
Lueck Data Systems

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
mdlueck is offline   Reply With Quote
The Following User Says Thank You to mdlueck For This Useful Post:
Tango (01-25-2013)
Old 01-25-2013, 10:09 AM   #3
Tango
DB/Application Dev Newbie
 
Join Date: Jun 2011
Location: Sumter, South Carolina
Posts: 141
Thanks: 27
Thanked 1 Time in 1 Post
Tango is on a distinguished road
Re: Odd... Anyone seen this?

No VBA, on this form. I will try the decompile route.

__________________
---------------
If I helped you, please click thanks or the balance scales on my post.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Tango is offline   Reply With Quote
Old 01-25-2013, 10:37 AM   #4
Tango
DB/Application Dev Newbie
 
Join Date: Jun 2011
Location: Sumter, South Carolina
Posts: 141
Thanks: 27
Thanked 1 Time in 1 Post
Tango is on a distinguished road
Re: Odd... Anyone seen this?

Had to edit the script to make it reflect the office 2010 folder location but otherwise it worked great. Unfortunetly it did not fix the problem though. Any other ideas?
__________________
---------------
If I helped you, please click thanks or the balance scales on my post.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Tango is offline   Reply With Quote
Old 01-28-2013, 11:05 AM   #5
Tango
DB/Application Dev Newbie
 
Join Date: Jun 2011
Location: Sumter, South Carolina
Posts: 141
Thanks: 27
Thanked 1 Time in 1 Post
Tango is on a distinguished road
Re: Odd... Anyone seen this?

For the record, I am still having this problem. Anyone have ideas?
__________________
---------------
If I helped you, please click thanks or the balance scales on my post.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Tango is offline   Reply With Quote
Old 01-28-2013, 11:22 AM   #6
mdlueck
Sr. Application Developer
 
Join Date: Jun 2011
Posts: 2,625
Thanks: 114
Thanked 296 Times in 283 Posts
mdlueck will become famous soon enough mdlueck will become famous soon enough
Re: Odd... Anyone seen this?

Quote:
Originally Posted by Tango View Post
For the record, I am still having this problem. Anyone have ideas?
Since you said...

Quote:
Originally Posted by Tango View Post
No VBA, on this form.
I have no ideas. If the Form does not have ANY VBA code on it, then the form should operate with default behavior, apart from preference changes you have specified. I could not begin envisioning what default preferences could possibly be messed with to cause the unexpected operations you originally described.
__________________
--
Michael Lueck
Lueck Data Systems

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
mdlueck is offline   Reply With Quote
Old 01-28-2013, 11:56 AM   #7
Tango
DB/Application Dev Newbie
 
Join Date: Jun 2011
Location: Sumter, South Carolina
Posts: 141
Thanks: 27
Thanked 1 Time in 1 Post
Tango is on a distinguished road
Re: Odd... Anyone seen this?

Could it be something odd from the Access 2007 - Access 2010 conversion?

__________________
---------------
If I helped you, please click thanks or the balance scales on my post.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Tango is offline   Reply With Quote
Old 01-28-2013, 01:18 PM   #8
mdlueck
Sr. Application Developer
 
Join Date: Jun 2011
Posts: 2,625
Thanks: 114
Thanked 296 Times in 283 Posts
mdlueck will become famous soon enough mdlueck will become famous soon enough
Re: Odd... Anyone seen this?

It works correctly in A2007, you opened the working DB file with A2010 and there it is behaving differently?
__________________
--
Michael Lueck
Lueck Data Systems

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
mdlueck is offline   Reply With Quote
Old 01-29-2013, 03:58 AM   #9
Tango
DB/Application Dev Newbie
 
Join Date: Jun 2011
Location: Sumter, South Carolina
Posts: 141
Thanks: 27
Thanked 1 Time in 1 Post
Tango is on a distinguished road
Re: Odd... Anyone seen this?

Oddly enough it worked under 2010 and 2007 until eventually I started getting "unrecognized database type" when trying to open it under 2007. I *noticed* the error in question roughly about that time. Unfortunetly I can't say for sure when it started.

I keep a backup of every version of my database for the last 4 years. Going back to old versions that I know worked before under 2007, the problem is there. So in short, even in old untouched versions written under 2007 the problem exists now (opened with 2010) while it did not exist the last time that front end was edited.

__________________
---------------
If I helped you, please click thanks or the balance scales on my post.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Tango is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 03:23 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World