Microsoft Access 2007 Inexplicable issues

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.
Eileen MurphyIndependent Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

James ElliottManaging DirectorCommented:
Create a new database and import everything using the standard wizard.

See if the problems persist.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Eileen MurphyIndependent Application DeveloperAuthor Commented:
I tried that too. No luck. I even created new forms from scratch and the issues persist.
0
danishaniCommented:
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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Eileen MurphyIndependent Application DeveloperAuthor Commented:
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
danishaniCommented:
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
danishaniCommented:
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
Eileen MurphyIndependent Application DeveloperAuthor Commented:
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
danishaniCommented:
Did you try to re-create the trouble Form?
0
Eileen MurphyIndependent Application DeveloperAuthor Commented:
I did.
0
danishaniCommented:
no dice?
0
Eileen MurphyIndependent Application DeveloperAuthor Commented:
No - so weird, right?
0
danishaniCommented:
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
Eileen MurphyIndependent Application DeveloperAuthor Commented:
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
Eileen MurphyIndependent Application DeveloperAuthor Commented:
Thank you!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.