Forum Discussion
Arunkj
Apr 10, 2023Copper Contributor
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...
Arunkj
Apr 12, 2023Copper Contributor
Hi Arnel, could you please help me with my follow-up query?
arnel_gp
Apr 12, 2023Steel Contributor
show the SQL statement of your query.
- ArunkjApr 12, 2023Copper ContributorI'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.
- Apr 12, 2023
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- ArunkjApr 26, 2023Copper ContributorThank you all for your responses. It really helped me resolve my issue.
Sorry for the delay in acknowledgement