Re: Edit fields on form that are unlocked?
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
If the form is based on a query (not a table), open the query and see if you
can edit the data there. If not, you will not be able to edit in in the
form.
What do you have in the form's AllowEdits property? (Should be Yes)
What about the form's RecordsetType property? (Should be Dynaset.)
What do you have in the Enabled and Locked properties of the controls?
(Should be Enabled = Yes, but Locked = No.)
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"winlock" <winlock@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4451C256-DF4E-4405-9C03-448CB7A4B503@xxxxxxxxxxxxxxxx
I cannot edit the data on any field on a form even though it is showing
that
the form is unlocked.
.
Relevant Pages
- Re: Keeping Tracking of whos adding new data..
... Macro to open the form in Add mode, but no edit mode. ... You should be able to use your form query to set the RC criteria to... ... Not sure what you're doing with the TempLue. ... Candia Computer Consulting. ...
(microsoft.public.access.formscoding) - Re: DB Result Wizard Error
... open the hidden folder /_fpclass/ and edit the ... > For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... > to display the new equipment information. ... > is in the table was added to the query. ...
(microsoft.public.frontpage.programming) - Re: Modifying the current record in code
... You should be able to modify the current record, ... I think that iterating ... > )) I think the best thing to do is run an update query and the ... >> You should remove the Edit and Update also. ...
(microsoft.public.access.formscoding) - RE: Link Excel To Access
... You could then use the Links command to edit the file paths (very handy if a ... A query is a one-step data dump from an outside source. ... promtped with "enable automatic refresh" or disable automatic refresh" is ... Then, edit again under Import Data - Edit Query, setup your query to ...
(microsoft.public.excel.misc) - RE: Select Query to create a Total field
... What is happening in your form when you edit a field value? ... Do I have to close and rerun the query or will the ... The calculation will update when the record is updated. ... The query works and returns the totals I require in a column Expr1. ...
(microsoft.public.access.queries) |
|
