Forum Discussion

Arunkj's avatar
Arunkj
Copper Contributor
Apr 10, 2023

Unlock locked fields in MS Access

Hi Experts,   I'm new to MS access. I've a file which I need to use as an input for my development work. I would like to know how I can edit the form in the file to update the required values. Pl...
access
Access Web App
Access Web Database
arnel_gp's avatar
arnel_gp
Steel Contributor
Apr 10, 2023
try to bring your form in Design view and click on one of the textbox.
on Property Sheet->Data, set to:

Enabled = Yes
Locked = No
  • Arunkj's avatar
    Arunkj
    Copper Contributor
    Apr 12, 2023
    Hi Arnel, could you please help me with my follow-up query?
    • arnel_gp's avatar
      arnel_gp
      Steel Contributor
      Apr 12, 2023
      show the SQL statement of your query.
      • Arunkj's avatar
        Arunkj
        Copper Contributor
        Apr 12, 2023
        I'm sorry. I'm only using the MS Access file I was provided. Kindly guide me on where to find the SQL Query for my file.
  • Arunkj's avatar
    Arunkj
    Copper Contributor
    Apr 10, 2023

    Hi arnel_gp,

     

    Thank you so much. It helped.

    However after changing the filepath, while I try to get data, it is throwing a strange error.

    The filepath in the error pop-up is preceded with a documents folder path to the filepath I have mentioned in the fields.

    Is there a default database path which I need to correct to resolve this issue?

     

     

     

Resources