Forum home » Delegate support and help forum » Microsoft Access Training and help » access course london - Editing Fields in forms
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access course london - Editing Fields in forms
Resolved · Low Priority · Version Standard
Reply Fri 20 Jul 2007, 16:47Delegate Min said...
Min has attended:
No courses
Editing Fields in forms
I have just added a wizard created button on a form, which opens another form while linking the two forms together and opening a specific record.
The only problem is after doing this i can change any of the values on the fields on the new form that has just been opened, the fields act as if they have been locked.
For upcoming training course dates see: Pricing & availability
RE: Editing Fields in forms
Hi,
Do you want to change the values in the new form, or do you want them to be locked?
Regards
Richard
Reply Mon 30 Jul 2007, 12:07Delegate Min said...
RE: Editing Fields in forms
i want to change and edit the value.
RE: Editing Fields in forms
OK, lets take a look at some aspects that may be creating this:
1. <b>Form properties</b>
If you open the forms properties, and view the Whole Forms Properties (click on the small sqaure where the ruler guides meet at the top left of the form).
Click the DATA tab, and look at the following settings:
Allow Edits
Allow Deletions
Allow Adds
They should be set to YES.
2. <b>Source Data</b>
Is the form that you are trying to edit based on an editable data source?
In other words, if you open that form without using the button, and just open the form from the database window, can you edit the data?
Let me know how that goes.
Regards
Richard
Reply Fri 3 Aug 2007, 10:44Delegate Min said...
RE: Editing Fields in forms
yup everything you mentioned was on yes,and it was an editable data source
RE: Editing Fields in forms
Min,
Please send a copy of your database to info AT microsofttraining DOT net, and ask them to forward to me. I will take a look and see if there is anything that I missed.
Regards
Richard
RE: Editing Fields in forms
Min,
I noticed that when I clicked on the GO TO button on the overview form, that there was a message in the bottom left corner breifly as the form opens, that says " The recordset us not updatable".
This is the cause of the issue you spek of.
There are many reasons why this occurs and the best way to get lots of info on this is to go to the HELP in Access and type in "When can I update data from a query?" This will list all the details you may need.
On the other questions you had, that would require some indepth consultancy work. If you would like us to assist you with that, please talk to our enquiries team on main number.
Regards
Richard
|