Search results

Hi Arnelgp - Thank you again for replying and providing additional code. I still cannot get the form to unlock when the New Job button is clicked. I have tried the following for OnCurrent: EnableDisableControlsOnForm Me, True Call EnableDisableControlsOnForm(Me, True) Call...

Thank you Arnelgp for supplying the function. It works as I asked, but will you please tell me how to unlock the controls, including subforms, when I click on a button I have set to open a new form. Micron suggested I give detailed information for what I was trying to do. I wanted to avoid a...

I have a form with a search textbox. The form has a subform. To prevent data errors on new Record when form opens - disable/lock all controls on main and subform, except search textbox. When record is found, enable/unlock all controls on main and subform, including search textbox. Does this...

Hi DBGuy, Thanks for the prompt reply. After much searching and trials of various codes, I ran across the code posted here: https://www.access-programmers.co.uk/forums/threads/how-best-to-allow-edits-to-some-fields-but-not-others.182661/ by Missinglinq. The original code had 'If Not Me New...

Hi All, I'm looking to disable/lock all controls, except search text box, including subform control. Currently, I'm using the code below and added the 'TypeOf ctrl is Subform', but am still able to enter data into the subform. I have users who occasionally enter data in the wrong field when...

All, Thank you for your time and help. I've decided to discard the idea of the shortcut (right-click popout) menus for unassociated labels and include an unbound textbox to search for the job number. After multiple attempts with various ideas, I agree with zeroaccess, that it is faster and...

I've set the border to None and every other option available and it will not change when the form is opened vba acdialog. The acdialog overrides the border option. Too me quite a while and a lot of internet searching to figure it out. Thanks again, Pam

Wow, thanks for the replies and suggestions. Please let me give a little background for the right-click shortcut menu I'm trying to create. I'm redesigning an old 2000 format database. The main form contains tracking info for job repairs. The navigation menu, on this job form, contains...

Thank you for responding. Are you saying a combo/list box on the shortcut (pop out) menu? I had thought of using a combo box on the form itself, not in the shortcut menu, but didn't like that idea. We have a large number of jobs in this database. Is it not possible to have a text box in the...

Hello, I've created a shortcut menu for a label on a form with buttons to open other forms. All works well. Now, I would like to add a textbox to the shortcut menu, so that users can enter a job number and have the form open to that number, basically a search option. I've tried various code...

Hi, I'm trying to use NeAlvey's Audit Trail code I found on this site to track changes in a database. I like the idea of having a table that stores additions, deletions, as well as edits. If I apply the code to a form based off one table, everything works fine, but if I apply it to a form...

I have found a great deal of information on this forum when searching for Access solutions online, specifically the latest, audit tracking info. I still have a problem or two to work out, so I decided to join. Just want to say thanks to all those who devote their time and help to all of us who...