I'm a self-taught user who is trying to create a data entry form for about 10-15 users. I have a data entry form created that I was using yesterday (called "frmResponses") . The form is unbound (I run an append query when a 'Save' button is clicked to add a record to the table that collects my data).
I tried opening the form this morning and now nothing happens. The mouse pointer changes to an hourglass for about one second, then reverts to an arrow without the form opening. When I try to open the form in Design view, the same thing happens.
I have a button on another form (frmMainMenu) that opens the frmResponses form. When I click this button, I get the following error: Run-time error '2001': You canceled the previous operation. When I debug this error, it points to my line of code: DoCmd.OpenForm "frmRespons es" I don't see any issue with this line of code (it has worked for weeks). The 'Help' from MS Access is blank and I cannot find any information on microsoft.com.
There has to be something wrong with my form but I don't know what and I don't know if I can do anything with it. I am getting my file restored to a previously saved state (I'll just have to re-do what I did yesterday). I'm hoping someone knows what's going on and can lend some advice.
Thanks.
5 2654
I'm a self-taught user who is trying to create a data entry form for about 10-15 users. I have a data entry form created that I was using yesterday (called "frmResponses") . The form is unbound (I run an append query when a 'Save' button is clicked to add a record to the table that collects my data).
I tried opening the form this morning and now nothing happens. The mouse pointer changes to an hourglass for about one second, then reverts to an arrow without the form opening. When I try to open the form in Design view, the same thing happens.
I have a button on another form (frmMainMenu) that opens the frmResponses form. When I click this button, I get the following error:Run-time error '2001': You canceled the previous operation. When I debug this error, it points to my line of code:DoCmd.OpenForm "frmRespons es" I don't see any issue with this line of code (it has worked for weeks). The 'Help' from MS Access is blank and I cannot find any information on microsoft.com.
There has to be something wrong with my form but I don't know what and I don't know if I can do anything with it. I am getting my file restored to a previously saved state (I'll just have to re-do what I did yesterday). I'm hoping someone knows what's going on and can lend some advice.
Thanks.
If the db is in development then it could be a bad compile on the form. You could try decompiling the database or creating a new one and importing all of your forms\tables\mo dules\queries.. .etc into it.
Don
If the db is in development then it could be a bad compile on the form. You could try decompiling the database or creating a new one and importing all of your forms\tables\mo dules\queries.. .etc into it.
Don
How do I decompile a database?
How do I decompile a database?
This works for 2002, can't vouch for any other versions of access
Go to a comman promt and enter the following. Replace Path with the path to your database and DatabaseName with the name of your db. Make sure to make a backup first. - msaccess.exe "Path\DatabaseName.mdb" /decompile
Thanks for your help!
Glad I could help...
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Christopher Brandsdal |
last post by:
Hi!
I get an error when I run my code
Is there any other way to get te information from my form?
Heres the error I get and the code beneath.
Line 120 is market with ''''''''''''Line 120'''''''''''''''''''''
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
|
by: Matt |
last post by:
My problem is when the user click the submit button, it will launch another
new window for the request page. I want to confirm we cannot use JavaScript
open window functions to open a request page? The following page2.asp won't
output the value entered in page1.asp. However, if we do <form
action="page2.asp" method="get" target="_blank">, then it will open a new
window for the request page, instead of using the same window as page1.asp....
|
by: Yasutaka Ito |
last post by:
Hi folks!
I have a BaseForm class that inherits System.Windows.Forms.Form. It has a
property, whose value I need supplied by the class that inherits it. The
BaseForm usees the value supplied into this property in its Load event.
So, I gave the BaseForm and the property 'abstract' modifier, and put the
implementation of the property in the inherited class; say MyForm. However,
when I did this, I no longer can open MyForm in the design...
|
by: Bob |
last post by:
I am displaying a form with a datagrid populated from a select of database
records which now exceed 12,000 when I select them all.
The form displays just fine with all 12,000+ entries but when I leave the
form to go back to the originating program, I get a "The page cannot be
displayed" screen for "Cannot find server or DNS error" "Internet Explorer".
But when I select a lesser number of records - under 12,000 (don't think
there is...
|
by: Bas Cost Budde |
last post by:
I have a form with a Collection variable to store several objects with
WithEvents children, to have all controls of a certain type behave
alike. This has been working for the last day, since creation.
Suddenly I cannot open the form in normal view anymore. "the OnOpen
property does not yield a valid event procedure, or an error occurred in
a function" -- the wording is in Dutch, that wouldn't help you
Normally, I recognize this as error...
| |
by: ericvdb |
last post by:
Hi all,
I'm trying to fill a PDF form with asp.net using the FDF Toolkit.
I have a simple form with a textbox and a button. When the button is
clicked, the pdf should open with the field filled from the textbox.
When I open the page in IE (whatever version) i get :
############################################################
The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and then
|
by: epearce301 |
last post by:
Hi, I have table1 and table2, both are linked, and a query has been
run. I created forms that use both just the tables, and then another
one using just the query. All of the information is there, but I
cannot edit any records nor can I move to a new record on the forms.
I checked to see if they were locked, and they are not.
Please help!
|
by: teenagelcruise |
last post by:
hi,
i have a problem with my code which is i cannot update and addnew data into the database but i can delete the data.plz give me an idea.this is my code that i wrote.
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Order Record</title>
<meta name="Microsoft Border" content="tlb, default">
</head>
|
by: Mick1000 |
last post by:
Hi all,
I am new to perl and this forum. I am trying to setup a mailing list subscription functionality for customers to receive a periodic newsletter from me. My perl program grabs the html form 'email address' text input but I am then having issues writing this data to a plain text file.
Below is my html form followed by my perl script. When i run this on IIS, i dont receive any errors, nor does anything get written to the file. Any help...
|
by: Musa via AccessMonster.com |
last post by:
I have the following code to Open a form and set the form to the Survey_ID
from the first form.
I keep get errors like cannot update file --- The Survey_ID is an autonumber.
Could this be the problem ?
Private Sub Command259_Click()
' Open Form
'DoCmd.OpenForm "frmCHAR2", acNormal, , , acFormEdit
'Set Value ID
'Forms!!Survey_ID.Value = Me!.Value
|
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 usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |