Solved

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

Posted on 2008-10-22
3
225 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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 22785033
do you have the SP1 installed?

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

Author Comment

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

Author Closing Comment

by:Anneline
ID: 31509097
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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Launch app from Access custom ribbon 8 32
Access query expression 6 19
Need to Populate a MS Access Table via VBA Code 3 22
Help with DoEvents 8 23
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
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…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

816 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

10 Experts available now in Live!

Get 1:1 Help Now