?
Solved

Microsoft Access 2007 Inexplicable issues

Posted on 2014-10-04
14
Medium Priority
?
47 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
[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
  • 7
  • 6
14 Comments
 
LVL 12

Accepted Solution

by:
James Elliott earned 2000 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

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
 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Suggested Courses

801 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