Solved

Microsoft Access 2007 Inexplicable issues

Posted on 2014-10-04
14
37 Views
Last Modified: 2016-02-11
This morning I began working on an existing application and noticed some bizarre behavior that I didn't see yesterday. I tried to repair the Office installation and then decided to uninstall, reinstall, download and update any needed updates but the issues persist.

Here are some examples of what I'm experiencing:

1. In the OnOpen event of a form I go to new record (DoCmd.GoToRecord , , acNewRec) and the form opens with the autonumber showing (New) as it should but the bound form data -- is from the last record in the table. Wasn't doing that yesterday??

2. DoCmd.ShowToolbar "Ribbon", acToolbarYes  -- suddenly no longer works. I have no idea if I need a reference for that to work.

Any ideas? I'm stumped.
0
Comment
Question by:Ei0914
  • 7
  • 6
14 Comments
 
LVL 12

Accepted Solution

by:
James Elliott earned 500 total points
Comment Utility
Create a new database and import everything using the standard wizard.

See if the problems persist.
0
 

Author Comment

by:Ei0914
Comment Utility
I tried that too. No luck. I even created new forms from scratch and the issues persist.
0
 
LVL 12

Expert Comment

by:danishani
Comment Utility
Did you made any changes before this behavior happened?

Make sure your database is in Trusted Location, so VBA code can execute properly.

Did you try a Compact & Repair database?

Is this a Split Database in Front End and Back End>?
If it is, hopefully you have a Backup in place, so you could replace the FE with a fresh copy.

Hope this helps,
Daniel
0
 

Author Comment

by:Ei0914
Comment Utility
At present the tables are in the front-end. I decompiled, compiled, repaired, compacted, etc. Locations are trusted. I even reinstalled the entire Office Suite.

Since the application is in development I am constantly making changes. The odd thing is that the functions were working the night before and then for some reason just stopped working. I'm not getting error messages or anything.

The strangest issue is when I open the form to a new record and the autonumber is (New) as it should be yet the bound fields are from the last record in the recordset.
0
 
LVL 12

Expert Comment

by:danishani
Comment Utility
Do you have a backup in place of the FE to see if that one works properly?

It might be something in the design of that particular Form.
Re-creating that Form is an option as well if issue persists.
0
 
LVL 12

Expert Comment

by:danishani
Comment Utility
I am reading it correctly that you have Tables in your Front End, does that mean you haven't split your database?

Just to make sure I understand your situation correctly.
0
 

Author Comment

by:Ei0914
Comment Utility
I have not split it yet because there are only a few test records and once I deploy it will split the fe/be.
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 12

Expert Comment

by:danishani
Comment Utility
Did you try to re-create the trouble Form?
0
 

Author Comment

by:Ei0914
Comment Utility
I did.
0
 
LVL 12

Expert Comment

by:danishani
Comment Utility
no dice?
0
 

Author Comment

by:Ei0914
Comment Utility
No - so weird, right?
0
 
LVL 12

Expert Comment

by:danishani
Comment Utility
It is, are you able to post a stripped down version of your database with that form, and some test data, so I can have a look?

I still think its per design that something went out of whack.

Daniel
0
 

Author Comment

by:Ei0914
Comment Utility
OK - I managed to resolve the issue where a new record would open displaying records in a subform representing the previous or last record in the recordset. I changed the setting "Filter on Empty Setting" to YES and that seemed to do the trick. I have been developing in Access since its initial release  and I have no recollection of even editing that setting.

On another note, and in reference to a previous post --- I had another client today who's subforms suddenly stopped totalling (using the Sum(field)) -- I did a repair on their Office Installation as I did previously and that resolved the issue. I suspect that some random Microsoft or Windows update ran and had an unintended impact on some reference or library file perhaps?

I just thought I'd mention that.

Also -- the DoCmd.ShowToolbar "Ribbon", acToolbarYes is still no longer working.

I'm wondering if they're hiring at McDonalds? :)
0
 

Author Closing Comment

by:Ei0914
Comment Utility
Thank you!
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now