Shut down when saving a form

I'm using 2002.  The problem has just recently started.  In updating a form, 
moving from Design View to Form View, or just saving the form, Access will 
just shut down with no warning.
Everything was running fine around Monday of one week, but later that same 
week is when the issue started.  It only happens on that one form.  
I've gone back to several previous backups that never had this problem, and 
they are suddently doing the same thing on this same form. 
I had another person try it on her machine, and the same thing happened.  No 
warning, no error message, just full application shut down.
0
Utf
2/9/2010 6:17:01 PM
access 16762 articles. 3 followers. Follow

9 Replies
759 Views

Similar Articles

[PageSpeed] 37

Smart troubleshooting about checking it with backups. I had to restrain my 
knee-jerk reaction about saying it was a corruption issue. It still might be 
a possibility, but not likely as backups have the same issue.

The question is: What has changed? Since it happens on older versions of the 
database, it's probably not the form itself. It also happens on other 
computers, so that gives a clue.

I wonder if there was a recent update from Microsoft. Microsoft often does 
auto updates on Tuesday nights and that would fit in with the working on 
Monday.

Here's what you could try: Depending on your operating system, find System 
Restore on a computer and pick a restore date in the past before this all 
happened. See if the form works OK then.

The only other things that I can think to look at would be the code behind 
the form and maybe going to the VBA window and checking for broken references.

Oh! Maybe Set Warnings has been shut off in code or a macro and not turned 
back on. That might explain the lack of warning messages. 
-- 
Jerry Whittle, Microsoft Access MVP 
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Lou-Jean" wrote:

> I'm using 2002.  The problem has just recently started.  In updating a form, 
> moving from Design View to Form View, or just saving the form, Access will 
> just shut down with no warning.
> Everything was running fine around Monday of one week, but later that same 
> week is when the issue started.  It only happens on that one form.  
> I've gone back to several previous backups that never had this problem, and 
> they are suddently doing the same thing on this same form. 
> I had another person try it on her machine, and the same thing happened.  No 
> warning, no error message, just full application shut down.
0
Utf
2/9/2010 6:29:01 PM
Okay, I've only been using it about 2 years and not a very strong user.  You 
mentioned Set Warnings.  Where do I search for these warnings?

As far as system updates, I'll have to refer that to our LAN people.  But 
you have given me more advice that our Help Desk could.
0
Utf
2/9/2010 6:41:01 PM
Lou-Jean wrote:
> I'm using 2002.  The problem has just recently started.  In updating a form, 
> moving from Design View to Form View, or just saving the form, Access will 
> just shut down with no warning.
> Everything was running fine around Monday of one week, but later that same 
> week is when the issue started.  It only happens on that one form.  
> I've gone back to several previous backups that never had this problem, and 
> they are suddently doing the same thing on this same form. 
> I had another person try it on her machine, and the same thing happened.  No 
> warning, no error message, just full application shut down.


Did you change the name of a field in a table that a query in the form 
references???   if you did and then didnt update the query, I think that 
could cause it.  Since all the backup forms are crashing , the problem 
could be a field in the table.
0
Advance
2/9/2010 7:10:47 PM
SetWarnings could be a lot of different places. It could be set in a macro or 
any of the forms or reports that you use.

Try this on a COPY of the database. Do some normal stuff in the copy of the 
database. Next open up the form in question, but nothing else. Press the F11 
key which should bring up the database window. Open up a table and select a 
record. Delete it (now you know why I say to use a copy of the database). Do 
you get an error message about the record being deleted? If so, Set Warnings 
probably isn't a problem as you wouldn't get that error message if it was 
turned off. If you don't get that message, we will need to investigate 
further.
-- 
Jerry Whittle, Microsoft Access MVP 
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Lou-Jean" wrote:

> Okay, I've only been using it about 2 years and not a very strong user.  You 
> mentioned Set Warnings.  Where do I search for these warnings?
> 
> As far as system updates, I'll have to refer that to our LAN people.  But 
> you have given me more advice that our Help Desk could.
0
Utf
2/9/2010 8:38:03 PM
Advance Scout wrote:
> Lou-Jean wrote:
>> I'm using 2002.  The problem has just recently started.  In updating a 
>> form, moving from Design View to Form View, or just saving the form, 
>> Access will just shut down with no warning.
>> Everything was running fine around Monday of one week, but later that 
>> same week is when the issue started.  It only happens on that one 
>> form.  I've gone back to several previous backups that never had this 
>> problem, and they are suddently doing the same thing on this same 
>> form. I had another person try it on her machine, and the same thing 
>> happened.  No warning, no error message, just full application shut down.
> 
> 
> Did you change the name of a field in a table that a query in the form 
> references???   if you did and then didnt update the query, I think that 
> could cause it.  Since all the backup forms are crashing , the problem 
> could be a field in the table.



As I previously wrote - you might have changed a field name in a table. 
  There is a feature called "name auto-correct" that is supposed to 
update  a name change into the query but it is buggy.

Solution if that is what is causing the problem: change the field name 
back; change the query reference or turn off the name auto-correct 
feature as per Allen Browne:
http://allenbrowne.com/bug-03.html
0
Advance
2/9/2010 10:08:19 PM
Thanks - it gives me more to research.  I had thought a field name was the 
issue, but couldn't find it initially. Will keep researching.

"Advance Scout" wrote:

> Advance Scout wrote:
> > Lou-Jean wrote:
> >> I'm using 2002.  The problem has just recently started.  In updating a 
> >> form, moving from Design View to Form View, or just saving the form, 
> >> Access will just shut down with no warning.
> >> Everything was running fine around Monday of one week, but later that 
> >> same week is when the issue started.  It only happens on that one 
> >> form.  I've gone back to several previous backups that never had this 
> >> problem, and they are suddently doing the same thing on this same 
> >> form. I had another person try it on her machine, and the same thing 
> >> happened.  No warning, no error message, just full application shut down.
> > 
> > 
> > Did you change the name of a field in a table that a query in the form 
> > references???   if you did and then didnt update the query, I think that 
> > could cause it.  Since all the backup forms are crashing , the problem 
> > could be a field in the table.
> 
> 
> 
> As I previously wrote - you might have changed a field name in a table. 
>   There is a feature called "name auto-correct" that is supposed to 
> update  a name change into the query but it is buggy.
> 
> Solution if that is what is causing the problem: change the field name 
> back; change the query reference or turn off the name auto-correct 
> feature as per Allen Browne:
> http://allenbrowne.com/bug-03.html
> .
> 
0
Utf
2/10/2010 3:03:01 PM
Thanks for your advice.  I'll keep trying.  

What really confuses me is that it occurs on old versions of the database 
that hadn't been touched.  I guess I should go back to our Help(less) Desk 
people and ask them this question. But do you know if there were any patches, 
updates, whatever, recently released that could have caused some sort of 
quirk in the program?
0
Utf
2/10/2010 3:07:01 PM
Advance Scout wrote:
> Lou-Jean wrote:
>> I'm using 2002.  The problem has just recently started.  In updating a 
>> form, moving from Design View to Form View, or just saving the form, 
>> Access will just shut down with no warning.
>> Everything was running fine around Monday of one week, but later that 
>> same week is when the issue started.  It only happens on that one 
>> form.  I've gone back to several previous backups that never had this 
>> problem, and they are suddently doing the same thing on this same 
>> form. I had another person try it on her machine, and the same thing 
>> happened.  No warning, no error message, just full application shut down.
> 
> 
> Did you change the name of a field in a table that a query in the form 
> references???   if you did and then didnt update the query, I think that 
> could cause it.  Since all the backup forms are crashing , the problem 
> could be a field in the table.

just try this- turn off your name auto correct function- it will take 
you two seconds and you will know if a query in the form is causing your 
issue. Heres the link:

http://support.microsoft.com/?id=319491
0
Advance
2/10/2010 6:45:36 PM
The Name Auto Correct was already unchecked.  
So I'm still hunting.  Thanks.
0
Utf
2/10/2010 10:15:01 PM
Reply:

Similar Artilces:

A SALES Form that can update both PRODUCT & SALE Tables
Hi Well, allow me to ask this question! Am creating a Product-Sales Database, and I would like the corresponding Sales made in the Sale Table to be automatically deducted or to be reflected in the Product Table. The product table contains all my stock and has a relationship with the Sales Table. The Sale Table does not necessarily include the Stock. How can I create possibly a Sales Form that will be used as an entry point for all the products (stock) sold and automatically register the sold products in the Sales Table and at the same time make the required adjustments in the Produ...

Split form problem
I’ve created a contacts form with a browser control to preview a picture. In order to refresh the browser I’m using the form_OnCurrent event. This is working fine in a single form but fails when I navigate in the split form datasheet. The main problem seems to be that Access runs my code in the context of the split form datasheet and not my main form. A similar problem is also occurring when resizing controls in split form view; Access resize controls in the split form datasheet and not my main form. Is there anyone else experience this behavior? What do you mean by "synchron...

Create a Web Address on a Form for Followhyperlink
I am trying to create a web address in Access. I have a form that has text boxes numbered 1-8. It is my intention to concatenate the text in the text boxes to create an address then use the followhyperlink method. I can create the string that I need but I get an error when the code gets to the followhyperlink method; runtime error 490 cannot open the specified file. The reason why I intend to concatenate the text in the text boxes is to allow the user flexibility. Some portions of the address are going to be static and others are going to depend on a value in a list box. Here is an exampl...

Form will not allow data entry 01-30-08
Today my database which has been working fine for 10 years quit working. I have tabbed controls of which some are subforms. All of the subforms work fine, but the tab-control pages will not allow any data entry and no error is given. I checked to make sure that the page properties and field properties are not locked. I can enter data directly into the backend of this database. Why would this happen to only tab controls and not subforms. I suspect this is a problem of the back end as prior front ends (that have not been used for months) do not allow the changes also. Any suggestions....

Office saves docs in app folder
A friend has Office 2004 on Mac OS 10.3.8 and complains that it's sometimes, randomly, saving docs into the Office folder in Application instead of into the Documents folder. He never said *which* of the apps in Office, though. Is there a fix for this? TIA Jonny in article ei4APQAKFHA.1052@TK2MSFTNGP10.phx.gbl, Jonny at invalid@invalid.com wrote on 05/03/13 11:37: > Is there a fix for this? When you "save" a new document, you get a dialog box showing a proposed folder location. Your friend needs to learn to look at this and browse to the desired folder if desired. Al...

Getting ' database full' error message trying to save in Publisher
I am getting a pop up error which states 'The disk is full trying to write C: etc etc. Save this file on a different disk and/or drive." My C; drive has plenty of space and when I try to save to a CD, I get an error message as well. This is a trial version of Office which has about 28 days left of a 60-day trial if that makes a difference. Last night I WAS able to save the same document. I am on a deadline and I really need help. Thanks so much Never save directly to removable media. Won't work. What is the exact error message you get when you try to save to the ...

double-click to new form in Access 2003
An application (which I am not familiar with) was written in Access 2002. There is a form with a subform where double-clicking on a row is supposed to go to another form using the information from the selected row in the subform. The user's Access has been upgraded to Access 2003 and double-clicking now brings him to an empty form rather than the next form according to the fields of the selected row. I have Access 2002. However on my computer, double-clicking doesn't do anything. The Action on On Dbl Clk on the fields in the Details section of the subform of the main form is OpenF...

Long time to save or open a form
hi all I have a problem when opening a form or save the code behind . I am using Access XP with Windows XP on machine P4 3.4 GHz, 1.5 GB RAM the problem is that access take too much time to save or to open a form ,any idea to solve this problem is appreciated thanks in advance Wael Hi Wael, Is there a network that separates your computer from the actual .mdb file? If so, my advice is to only do design changes on a local copy. You might also try the undocumented /decompile switch. First, make a backup copy of your database, just in case something horribly wrong happens. With Acce...

Excel 2007 Save As PDF Bug
any news or workaround concerning this bug? facing the same problem with the german version. ...

Add capability to graph in the form of y=x.
Mathematical functions are very difficult to accurately graph even with massive amounts of coordinates. Excel will not graph variable-dependant equations; that is it will not graph them without a lot of tinkering and results in very unprofessional looking end product. Please add a way to make y=x graphs that doesn't take hours to create through mixed graphs. Joshua@watsonhome.org ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message p...

how to save extracted audio as .wav
hi all, I have a video format(.cam) and audio files are stored in it.I can able to extract and play audio using waveout funtions in wave class. I would like to save the extracted audio in .wav format. how to do this.do i need to add any class like waveIn I saw the following code to record wav file. // Uses the MCI_OPEN, MCI_RECORD, and MCI_SAVE commands to record and // save a waveform-audio file. Returns 0L if successful; otherwise, // it returns an MCI error code. DWORD recordWAVEFile(DWORD dwMilliSeconds) { UINT wDeviceID; DWORD dwReturn; MCI_OPEN_PARMS mciOpenParms; M...

raise form events programmatically
Is it possible to raise built-in form events programmatically? I have a feeling it isn't but thought I would check. For instance, I want to do something like this within a private sub on the form: RaiseEvent Delete(Cancel) and have it trigger the Access.Form delete event -- i.e. without actually deleting a bound record. Note my delete event is not handled by the form itself but by an external class, so I can't simply call Form_Delete(Cancel). Thanks, Eric No need to raise an event: just call the procedure Dim intCancel As Integer Call Form_Del...

Create Email From Access W/Information From Form or Query in
I have designed Databases for many years now, but never attempted this: I need to know how to create an email with information located in the active form or off of a query. I would like to have the email automatically generated with the To Address, The Subject Line and the Body of the Text. I would like that email to open but not to send until the operator has a chance to make modifications. (one record per email). -- Mark Matzke "mmatzke@comcast.net" <mmatzkecomcastnet@discussions.microsoft.com> wrote in message news:F3F01720-2676-4DE6-A881-0E640CAF4CB5@microsoft.com...

Open a form with TABS from another form
This is my problem: I have a form with TABS (formVisitReason) i use to create a record with many yes/no buttons. After I create the record, I want to view the record I just created, but impossible to make it work. The form always comes back blank, even though the record was created and i can see it in teh database. Here is teh logic: I open the above form from the visit table, which has a visitID. Tha visitID is passed to the formvisitreason. This is working like a charm. But when i want to view what I just created, impossible visitReasonID is an autonumber from the visit table...

Passing avalue from one form to another
I have a form (ItemBrowse_frm) that provides me a list of active Item numbers. When I click the Item number I want to pass the Item number to my other form (SingleBill_frm) and requery the form based on that part number. I am using the following OnClick Forms![SingleBill_frm]![ParentItembx].Value = Forms!ItemBrowse_frm.[ItemNumber] Forms![SingleBill_frm].Requery Somehow the SingleBill_frm does not requery and the field that I am passing the value to does not show the value passed until I highlight the field. Is there a better way to do this or what am I doing wrong? Thank you! ...

Converting Access Forms to Webforms
Hello, I've scanned through the forums here and didn't notice any up-to-date links for my answer, so I thought I'd post my question and see if I could get any response that I could understand, lol. I have several databases that individuals use with user interfaces (forms) that I would love to be able to convert, and still retain their functionality with the database, to a webpage. How can I successfully do this? The forms themselves are a lot of work in combination with queries and reports, and I'd rather not have to recode them all if possible. If this is possible, ...

Recieving forms
For some reason I no longer recieve my front page forms and possibly related problem my e-mail no longer automatically downloads when I open my e-mail the header of the e-mails come on there but I have to click on the header to view the message. Steve ...

Help Creating Form
I have 5 tables: Manufacturers, Products, Brands, Varieties, Sizes. I would like a combobox Manufacturer that would filter a Products combobox that would in turn filter a Brands combobox. After selecting a Brand from the Brand combobox, I need to enter several Varieties for each Brand and several Sizes (Size, Unit, Pkg) for each Variety. Please help. I am new to this. I have the relations set in the order that the tables appear on the 1st line of this post. On Thu, 11 Mar 2010 06:38:14 GMT, "rnjalston" <u58689@uwe> wrote: >I have 5 tables: Manufacturers...

Adding form textbox to subform textbox
Hi, I have a form named frmBusiness which has a subform named frmInspectionsSub. Each business can have several inspections (One to Many). I would like to add a number in frmBusiness's textbox named "InspectionCycle" to a textbox in frmInspectionsSub named "InspectionDate" which contains a date. I would like to display this in a textbox on frmBusiness. I need to have the "InspectionCycle" add to the year in "InspectionDate". I also need the InspectionDate that it adds to be the last or largest date of that record, (not of the entire domain just of th...

Saving on a shared Excel workbook
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Greetings: My company uses a shared excel workbook to record the status of our projects on a daily basis. We recently converted from Windows/Office to Mac/Office. We're having problems with this scenario: Colleagues A & B have the document (workbook) open. A saves a change. (makes a change and then hits "save") Then B saves a change. Under Windows/Office, when B saved, a message would pop up alerting B that other users had also made changes, and the saved document would display both A's and B'...

Check Mark does not show in form check box
I have a form with two check boxes that the user may check their choice. Upon receipt of the form the check marks do not show. Any ideas? Did you bind each check box to an Outlook yes/no property, on the Value page of the control's Properties dialog? If you don't do that, Outlook does not know where to store the data. FYI, there is a newsgroup specifically for Outlook forms issues "down the hall" at microsoft.public.outlook.program_forms or, via web interface, at http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_forms -...

auto-saving emails as files on the network
Does outlook have the capability to save incoming/outgoing emails to a standard file structure on a server. eg. I have a directory for clients and the next level down is client a, client b etc. If I receive a mail from client a, when I open it, I would like it to auto save to d:\client\clienta\correspondence. Any ideas? ...

close form automatically after say 2 second
I guess I cannot close msgbox after predetermined time in code. So I want to use a form to display message and close automatically in 2 seconds. How to do that? Thanks. Check the Access help for the OnTimer event. Steve "Song Su" wrote: > I guess I cannot close msgbox after predetermined time in code. So I want to > use a form to display message and close automatically in 2 seconds. How to > do that? > > Thanks. > > > These code works. How to supply message to the form in code? Option Compare Database Option Explicit Private Sub Form_Open(C...

Newbie
Hi guys, I am kind of new to Outlook. I would like to know of any fast shortcut or a Macro for Save As many messages. I work in a NGO and due to the Haiti crisis we recive like 500 emails at day. I have to save each one them and ONE BY ONE that says Donations (not all emails says donation). I would like to know if there is any way i can select a bunch of emails and save them all at once to my disk location not having to do it one by one. Any help or ideas, Cheers, S. Submitted using http://www.outlookforums.com You can drag and drop the messages out of Outlook and into an ...

Hot Spots on Photo image after saving to Web Page.
For those of you familiar with Publisher (I'm using 2000). I'm working on my family's holiday e-card. And every once in while I've had this happen over the years...not always though so having problems troubleshooting it. When I insert my photo file, it looks fine. File is currently saved as JPEG but I've tried various formats too. BUT, then when I 'save to web page' (then I copy/paste this into my email so it comes through as a graphic (e-card) there are hot spots on parts of my kids' faces....it's weird. Their nose, cheeks are 'hot' (almost w...