Solved

"The expression On Click you entered" yada yada yada...

Posted on 1998-03-30
6
550 Views
Last Modified: 2011-09-20
I've created a form in MSAccess for Win95--nothing fancy, just a couple of buttons to go
to next record, open pre-defined forms, etc.  Suddenly all of the buttons have stopped
functioning, and report a compile error.  Each control was created using the control
wizard, so it shouldn't be coding (and the code is still there).  Am I missing a patch, or
should I wave dead chickens?

Thanks much,

Michael M Murphree
0
Comment
Question by:SAGEM
[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
6 Comments
 
LVL 17

Expert Comment

by:ramrom
ID: 1972403
Have you tried opening the form's module and compiling? That uwually pinpoints the problem.
0
 
LVL 1

Expert Comment

by:zircon
ID: 1972404
Did you rename any tables involved in the form and controls?

...I kind of like the "wave dead chickens" approach, though.
0
 
LVL 2

Expert Comment

by:marti
ID: 1972405
Could you submit the code with the exact statment where the error occurs?
0
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.

 
LVL 3

Expert Comment

by:guillems
ID: 1972406
Do you make any change in the fields of your tables?

It's probably you change a name and the access doen't compile the database, and give you this error, so try to check every control in the form, and see if the controlSource has the right reference.
 
I hope this help you!
0
 
LVL 5

Accepted Solution

by:
tstaddon earned 50 total points
ID: 1972407
I have had this problem before. It usually occurs when there has been a code procedure set up which has been either replicated across different objects, or relevant objects have been  renamed. It also occurs when a macro is replaced with code.

Unfortunately, I couldn't fix it unless I deleted off the objects and recreated them.
0
 

Author Comment

by:SAGEM
ID: 1972408
Off to the butcher's...
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
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