Recent content by shwilsonjr

Would like to secure the completed form, its a activity form that I would like to lock when completed and give the ability to open it to a list of supervisors

I would like to be able to lock the form when completed but allow certain people access to form, is this possible using a macro? If so some guidance would be appreciated.

Thanks for the replies, I found the issue was in the table design for a couple of the controls.

I have a database that has 2 queries that run as soon as the form is opened and I would like to stop them from running. I removed them from the record source and it caused the form to not open properly, it filled all the inputs with #name?, how do I stop this from happening?

I am using a form for a daily report and would like to have a cmd button to lock the form when the report is complete and be able to unlock the form using a username and password. This is a multi-user form on a network, I would like to allow the managers, director and VP to be able to unlock the...

I am going through this book and when I was following along with the sample file for chapter one I received a compile error. I am running MS Office Professional 64 bit w/Windows 7 OS. Is there a issue with the sample databases?

This is current code that I have tried. I tried the with the Me., but it didn't work either. I got the variable not defined error with the "NoEdit" highlighted Option Compare Database Option Explicit '------------------------------------------------------------ ' EditReview '...

Form_frmDailyReports.CurrentRecord = NoEdit "NoEdit" is highlighted in blue, When I click okay the following is highlighted yellow: Sub macReportComplete()

This the code I used for the cmdReortClosed command button and received a compile error “variable not defined” Option Compare Database Option Explicit Sub macReportComplete() If Form_frmDailyReports.cmdReportComplete = True Then Form_frmDailyReports.CurrentRecord = NoEdit End If...

Should I use the VBA editor to enter this code for the cmdReportComplete button?

I have a from named frmOpeningForm which has three command buttons as follows: cmdNew (opens new form) cmdEditReview (allows users to edit and review the Daily Report that they are completing for their shift. Once completed they will click the cmdReportComlete button at which time I would like...

Once the Report form is completed the user will click the cmdReportComplete command button to make the form read only. Once that occurs I would like to lock or disable the cmdReportComplete button.

Can I use this in a If...Then sequence to lock the control after it has been clicked? If so can you show the syntax?

I have a command button on my main form that I want to use to set the property of the current form to read only. Not sure of the proper syntax to perform this feature.

Thanks Simon, I will attempt to use your example and get back to you. If I decided to use a command button would the code be useful?