Re: Read Only Form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Adrian Jansen (qqv_at_noqqwhere.com)
Date: 05/06/04 

Date: Fri, 7 May 2004 08:18:05 +1000

If the recordsource for the form is a non editable query, then naturally you
cannot edit any of the form fields. I suppose you could still expect to
edit unbound fields, but to what purpose ? Where will the data go you edited
? 

-- 
Regards,
Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
"Chris" <anonymous@discussions.microsoft.com> wrote in message
news:98a201c433b0$13d36be0$a001280a@phx.gbl...
> Please help!
> I believe I have covered all bases with this problem, ok
> except one which is why I'm writing.  I have an Access
> 2002-2003 database with several forms locked for
> editing.  I've checked each of these forms to be sure my
> Allow Filters / Edits / Deletions / Additions are all set
> to yes, Data Entry set to No (so user can modify
> existing), and checked each field to verify Enabled = Yes
> and Locked = No.  The only thing I can think of is that
> each of these forms has an ODBC link to a SQL query in
> another db.  However the information gathered from that
> query is locked down as it does not need to be modified.
> Would that lock me out of all other fields?  What about
> the JetPack download Microsoft is pushing?
>
> Thanks in advance!

Relevant Pages

  • Form not allowing edits
    ... but I am unable to edit the Parent form data. ... the form fields are set to Enabled and Locked is set to no. ... I have tried opening the query that the form is based on and editing ...
    (comp.databases.ms-access)
  • 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)