Form locked up from data entry

[KahluaFawn]

I am using Access 2000 and have had this database working for several years. I have used a form for data entry into my database. The form is populated by a query that brings together several related tables.

A couple days ago I accidentally perfomed a sort on the form in the datasheet view and save it and now I can no longer update any of the text fields in the form. The sorted query had populated the datasheet/form view, so I'm sure that somehow this action (sorting a form field) has caused my update problem.

I am open to any suggestions. Please let me know what you can suggest that will help me over this hurdle. Thanks.

 

[KahluaFawn]

Clarify - form lock up problem

I posted the problem with the "form" locking up on me. I do not use the form view to update, but instead the datasheet view. When I go to "insert record" either from the menu or the lower status bar, the new record option is disabled. Is there anywhere to look in the properties to see and alter what I have changed (unknowingly) to allow me to add and change records again? I am not experienced with writing Access code. I'm simply using the basic form and query options to operate this database.

Thanks.

 

[missinglinq]

In Design View for the form goto Properties - Data and check AllowEdits, AllowAdditions and while you're at it AllowDeletions. They should all be set to YES.

 

[KahluaFawn]

Response to "missinglinq"

I went to the design view of the form. The Data properties of Allow Filters, Edits, Deletions, Additions, and Data Entry are all set to "Yes" and I still can not edit my data. Can you suggest somewhere else to look or something else to try?

Thanks for helping me with this frustrating problem.

 

[KahluaFawn]

still trying to make form work

1. I copied the OLD query and simplified it to only include only the 3 tables that contain the fields necessary for this form.
2. I displayed the NEW query in Data Sheet view and the data was valid and updateable in this query.
3. I copied the OLD form to a NEW form name and used the Data Record Source to reference the NEW query.
4. When I display the Field List on the NEW form, it reflects the name of the NEW query in the title bar and all the correct fields are listed.
5. When I displayed the NEW form in Form and Datasheet views, though, none of the data is not retrieved. All the fields from the NEW query are blank. Is there something else that I need to change in the NEW form design that allows the data from the NEW query to be recognized?

Thanks.

 

[ajetrumpet]

3. I copied the OLD form to a NEW form name and used the Data Record Source to reference the NEW query.

Which data record source?? Reference the NEW query, or to provide a basis for your new FORM??

4. When I display the Field List on the NEW form, it reflects the name of the NEW query in the title bar and all the correct fields are listed

5. When I displayed the NEW form in Form and Datasheet views, though, none of the data is not retrieved. All the fields from the NEW query are blank.

Did you change the control sources?? does the new query have a different name than the old one??

 

[KahluaFawn]

response to "ajetrumpet"

Yes. In the NEW form I changed the Data Record source to the NEW stored name that I used for the NEW query.

 

[ajetrumpet]

Well,

You might want to check on the ControlSources and Rowsources and see if all of those names and fields match.

You do not have any module code written in the file whatsoever?? If you do (even a few lines), that's another place to look.

Only other thing that comes to mind is trying to sort on a child field (that is part of a one-to-many) from one of the tables, although I don't think that's possible. Maybe too, if you've sorted on a primary key...these are just spitball guesses though...

 

[KahluaFawn]

All the field names in the the query only reflect one of three tables that they are retrieved from. The form uses all those names directory from the query. There is no embedded macros or code anywhere that I know of.

Thanks.

 

[ajetrumpet]

If you want to post your database, you are welcome to do so...I cannot think of any other reason why this might be happening.

 

[KahluaFawn]

posting a data base

How do I do that?

 

[KahluaFawn]

I don't know whether this "quick reply" area is faster than the regular post or not, but I'll try it also. "How do I post a data base to this forum?"

 

[ajetrumpet]

reply to the message and attach a file to it. There is a button below the message window for this. You cannot post .mdb's or .accdb's so you will have to ZIP the file using WinZip.

You can use the "SendTo" command in your desktop shortcut menu to do it.

 

[KahluaFawn]

winzip

I just resently got a new custom computer built with Vista and now I can't load my old WinZip software ... so I need to go out and purchase new version. I will follow through on uploading zipped database file when I am able ... hopefully within a few minutes. Thanks for helping me.

 

[ajetrumpet]

Kahlua,

The WinZip program comes with the windows operating system. If you have Vista, you have it. Either run a search for it, or right click on the desktop to get your shortcut menu to pop up.

 

[KahluaFawn]

I am running Vista, but all I can access is the old one (I think) that I tried to install which keeps saying it has compatibility issues.

 

[KahluaFawn]

uploading zip folder

I hope this works. Please let me know if this works. Thanks.

 

[ajetrumpet]

is it the query CSM Members??

You have no controlsources set!!!

 

[ajetrumpet]

nevermind, I'm looking at the wrong form...

 

[ajetrumpet]

frm CSMMembers and frmCSMMembers NEW are both set as DATA ENTRY = YES

that is why you don't see any records.