Solved

Microsoft Access 2007 Inexplicable issues

Posted on 2014-10-04
14
43 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 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

749 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