Solved

Access Database error when I open it and click on a control with code

Posted on 2008-10-22
3
223 Views
Last Modified: 2013-11-27
I've only found this error in Access 2007. I create a database and a form and add controls with code behind them - say a button to open a form. It works great. Then when I close the db and reopen and click on that same control if gives the error message I descibed. I have to go into design view, click on the even procedure, simply just open up the vb screen, make no changes, close the screen and it works again. Its definitely a bug which poses a problem when the users need to use the db on a daily basis. Any ideas on how to fix this?
0
Comment
Question by:Anneline
  • 2
3 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
do you have the SP1 installed?

http://support.microsoft.com/kb/949585/
0
 

Author Comment

by:Anneline
Comment Utility
Ah, I don't have it installed on this machine. Downloading now and will test. Thanks,
0
 

Author Closing Comment

by:Anneline
Comment Utility
Hi, I had a problem installing it - said it failed. I'll try again another time. Decided to close the question as it might be when I move to Mac with Win XP operating system through Virtual Box :D
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

763 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

9 Experts available now in Live!

Get 1:1 Help Now