Forum Discussion
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...
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
on Property Sheet->Data, set to:
Enabled = Yes
Locked = No
Hi Arnel, could you please help me with my follow-up query?
- show the SQL statement of your query.
- 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.
Hi,
It's more likely that you have to change the code behind the button you click. To let us see what is happening:
1. open the form in design view
2. do a right mouse click on the button and in the context menu that pops up choose the very first entry "Build Event"
3. now it depends on what opens:
a) If it is a window titled "Microsoft Visual Basic for Applications" then copy the VBA program code into your next message here.
b) If instead it is a window where a menu item "Macro Design" is highlighted, then post a screenshot of this macro window.
Servus
Karl
****************
Access Bug Trackers
Access News
Access DevCon
