Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Serious Bug in Access 2007
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   12 years ago

There is a SERIOUS bug in Access 2007. I discovered this after a couple of you emailed me and posted in the Forums that you're trying to follow one of my lessons (Access 202, Lesson 1) where you use the Command Button Wizard to "open a form and find specific data to display." Specifically, where you click on a button on the CustomerF form to open the ContactF form and show that customer's contacts.

Well... it doesn't work in Access 2007. Yes, it's a BUG.

The good news... it's FIXED in Office Service Pack 2.

So if you haven't downloaded SP2 yet, now is the time to do so. After playing with this for an hour and researching it online, I found many mentions of other nasty bugs in the Office 2007. I'll be the first to admit that I don't usually apply service packs myself until I have a reason to do so (bug, problem, etc.) but this is definitely a reason to download and install SP2.

I had the original release of Access 2007 on my machine. I tried creating a command button using the wizard. It didn't work. It opened the form and showed ALL records even though I picked "specific records" in the wizard.

The command button wizard in Access 2007 creates something new called an "embedded macro." Instead of generating VBA code like previous wizards did, this new wizard makes a macro that's embedded (stored) in the form itself. I don't particularly care for it, but I can live with it.

See, I never would have found this bug otherwise because I always write VBA code by hand. I don't usually rely on the macros. It's one simple line of code:

  DoCmd.OpenForm "ContactF",,,"CustomerID=" & CustomerID

That's it. That's all you need to open a form and show a specific record or records. You can do the same thing with a report too (just change OpenForm to OpenReport).

So, for those of you having trouble with this, download Office Service Pack 2 from Microsoft. It's free, but its 200 MB, so unless you have a FAST connection, be prepared to go get lunch while it downloads.

Bug In Access!!! Upload Images   Link  
Robert Lilly 
12 years ago
Remember the old guy with the memory problem told you about this two months ago. I'm so glad you came with resulation. I had tryed to fix the VBA code by placing the "ME" in the statement but it would not work. Read More...
Add a Reply

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

12/3/2021Access Beginner 2
12/3/2021Access Beginner 2 Lessons
12/3/2021Access Beginner 2
11/30/2021Import Multiline Cells
11/30/2021Adam's Access Games
11/29/2021Prevent Close
11/22/2021Currency Symbols
11/13/2021Access Developer 36
11/13/2021Access Developer 36 Lessons

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: office 2007 sp2 access bug specific records  PermaLink