Hi all,
I'm trying to edit VBA code in my mdb file for a form. Basically, I
want to delete and comment out some lines of code. (I'm quite good at
VBA, so I don't need help there).
I'm trying to comment out a procedure, and delete all calls to that
procedure.
The problem is, as soon as I try to delete or comment anything, Access
crashes.
It shows a popup that says "Access has encountered an error, and needs
to close", and gives me the option of reporting or not reporting the
error to MS.
No error info is given.
Has anyone run into this before?
I was able to add the code with no problem, and don't know why taking
the code out would cause any problems.
Yes, I have run the Database utility "Compact and Repair Database".
Thanks for any help,
John
2  2407 
Greetings,
I have had a similar issue with Access2003, but with changing
printer/page settings on a report from the Print menu. I then changed
printers from the PageSetup menu, and Access stopped crashing on me.
The issue here is that Acc2003 is kind of finicky.
In your case, I would try changing the name of the procedure instead of
commenting it out. Then do a debug/compile to trap the errors you will
get when the calls to the old name complain. Then comment out those
calls. Then rerun the Debug/Compile.
HTH
Rich
*** Sent via Developersdex http://www.developersdex.com ***
This certainly sounds as if it is some form of corruption. Two suggestions:
1. Just because it's simpler, first, get your Office 2003 CD/DVD and repair
your installation.
That might fix it.
If not,
2. Create a new database:
A. Make a copy of your database, then delete all the code.
B. Then import the objects into a new database.
C. Then use Save as Text on code from the original, and Load from Text on
the new database.
D. Then for Controls and Forms with event code, reset the Event to "Event
Procedure."
Search this newsgroup at http://groups.google.com for assistance on the
undocumented (or, at best, unofficially documented) Save as Text and Load
from Text features.
Larry Linson
Microsoft Access MVP
<jj****@gmail.c omwrote in message
news:11******** ************@q4 0g2000cwq.googl egroups.com...
Hi all,
I'm trying to edit VBA code in my mdb file for a form. Basically, I
want to delete and comment out some lines of code. (I'm quite good at
VBA, so I don't need help there).
I'm trying to comment out a procedure, and delete all calls to that
procedure.
The problem is, as soon as I try to delete or comment anything, Access
crashes.
It shows a popup that says "Access has encountered an error, and needs
to close", and gives me the option of reporting or not reporting the
error to MS.
No error info is given.
Has anyone run into this before?
I was able to add the code with no problem, and don't know why taking
the code out would cause any problems.
Yes, I have run the Database utility "Compact and Repair Database".
Thanks for any help,
John
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Graham Taylor |
last post by:
I've tried posting this in the 'microsoft.public.access' but I will post it
here also, as I think it might be the webserver which is causing my problem.
---------
I have an Access 2003 database which is in the "fpdb" folder of my
webserver. Its located there so that I can use asp to build a web-based
front-end for users to read the database...
|
by: Peter Frost |
last post by:
Please help
I don't know if this is possible but what I would really like to do is
to use On Error Goto to capture the code that is being executed when
an error occurs.
Any help would be much appreciated.
Thanks in advance
|
by: j.mandala |
last post by:
Someone is trying to run my Access 2002 database under Access 2003. He
has had a number of problems:
1) i used the MSComCt2.ocx for it's Date and Time picker. I can't find
it under 2003. Do I need to send it to them?
2) I have a function to fill a table with values, that store the page
and column numbers of a display of staff members. I...
|
by: Matt Alanzo |
last post by:
On another newsgroup an Access knowledgable party posted:
>You should be able to connect an Access ADP to an existing SQLExpress
>database running in SQLS 2000 compatibility mode. The only thing you
>won't be able to do is access any of the design surfaces for SQLS
>objects in the ADP. I checked with the Access team on this :-)
>
I...
|
by: JMCN |
last post by:
object invalid or no longer set - confusion of the recordset in access
2003.
i am currently converting from access 97 to access 2003. majority of
the codes converted over perfectly fine, though my recordset did not.
i read from pasts posts that some references will not convert. so i
tried to change the dao 3.51 reference to dao 3.6 in...
| | |
by: Stan |
last post by:
This is how I access Pieces field in my editable datargid during Update
event:
protected void grdMain_OnUpdate(Object sender, DataGridCommandEventArgs e)
{
string Pieces = ((TextBox) e.Item.FindControl ("txtPieces")).Text;
....
}
|
by: Mell via AccessMonster.com |
last post by:
Is there a way to find out where an application was created from?
i.e. - work or home
i.e. - if application sits on a (work) server/network, the IT people know the
application is sitting there, but is there a way they can find out if that
application was put there from a CD or email or created at work?
Hint: It's not on a client/server...
|
by: PW |
last post by:
Hi,
I have a form with unbound fields on it. The user selects a record
from a recordset and I populate the unbound fields. When I try to
change the unbound quantity text box, Access 2003 tells me "The data
has been changed. Another user edited this record and saved the
changes before you attempted to save your changes. Re-edit the...
|
by: Earl Anderson |
last post by:
One of the users in our departmental db has Read/Write permissions to a
particular form. He was able to access and edit the form at will until 2
weeks ago. His current problem was that he was not able to edit the data
(no message ever appeared telling him he could not change any data). The
only change to the db since he experienced the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
