Solved

Microsoft Access 2007 Inexplicable issues

Posted on 2014-10-04
14
39 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
ID: 40361931
Create a new database and import everything using the standard wizard.

See if the problems persist.
0
 

Author Comment

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

Expert Comment

by:danishani
ID: 40362557
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
ID: 40362602
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
ID: 40362614
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
ID: 40362635
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
ID: 40362677
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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 12

Expert Comment

by:danishani
ID: 40362727
Did you try to re-create the trouble Form?
0
 

Author Comment

by:Ei0914
ID: 40363679
I did.
0
 
LVL 12

Expert Comment

by:danishani
ID: 40365013
no dice?
0
 

Author Comment

by:Ei0914
ID: 40365036
No - so weird, right?
0
 
LVL 12

Expert Comment

by:danishani
ID: 40367399
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
ID: 40370705
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
ID: 40952668
Thank you!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

896 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

18 Experts available now in Live!

Get 1:1 Help Now