Hi,
It sounds as if you have a corrupted VBA module.
If it's just one Form do the following:
- Open the Form in design view
- Select the menu option View > Code
- Select the menu option Edit > Select All
- Copy the selected VBA code
- Open Notepad and paste the code in the NotePad file
- Close the VBE window
- While in the Form's properties change the "Has Module" property
from Yes to No (this deletes the code behind the Form)
- Close and save the Form
**** this next part is not needed but will not hurt ****
- Press ALT + F11 to switch to the VBE window
- Select the menu option View > Immediate Window
- In the Immediate Window type the following and hit
Enter
Application.SaveAsText acForm, "name of your Form",
"C:\MyForm.txt"
- Delete the Form in the Database Window
- Back in the Immediate Window type the following and
hit Enter
Application.LoadFromText acForm, "name of your
Form", "C:\MyForm.txt"
**** this next part is not needed but will not hurt ****
- Open the Form in design view and select the menu option View >
Code
- Select the menu option Edit > Select All
- Switch to the NotePad file and copy the code from the NotePad
file back to the VBE Window
- Close and save your Form
If it's more than just one Form (i.e., your entire VBA Project is
corrupted) then you would need to do it for each object like ALL Modules,
Forms and Reports that have VBA code (there's sample code to loop through
all objects --- let me know if you need it).
You can also try performing the following on a COPY of your database:
- Click > Start > Run
- In the Open Run command line type and hit OK
"full path name to msaccess.exe" "full path name to the copy
of your MDB" /decompile
I hope this helps! If you have additional questions on this topic, please
respond back to this posting.
Regards,
Eric Butts
Microsoft Access Support
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
--------------------
| Thread-Topic: "you canceled the previous operation"
| thread-index: AcPrM+jrDh9+JXJ4TDavyBscgZZRbw==
| X-Tomcat-NG: microsoft.public.access.modulesdaovba
| From: "=?Utf-8?B?Sm9obkI=?=" <
[email protected]>
| Subject: "you canceled the previous operation"
| Date: Wed, 4 Feb 2004 07:31:08 -0800
| Lines: 1
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.modulesdaovba
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.modulesdaovba:123462
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.modulesdaovba
|
| Using Access 2000 front end and SQL Server back end, I started getting
"you canceled the previous operation" when I try to change almost anything
from a control on a form to VBA code. The Help message says something
about Project options. The only Project info I have is the project Name.
|
