Search results

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?

I was able to recreate my db into the .mdb, it is attached. I hope that this works for you.

I tried to convert it to A2003 but it won't allow it. I tried the save and publish then save as a .mdb and get the following error message: "You cannot save this database in earlier version format because, it uses features require the current file format."

I uploaded the database (dailyreports.zip).

I have two forms (this is the opening form) one contains three command buttons: cmdCreateNew - used to open a blank form (I used a macro to program this button but I get a pop up that asks for a parameter, would like to stop that.) cmdEdit/review - used to open forms that were started and can be...

I am familiar with Access, but a new to VBA programming. I got started in the programming side as part of a task given to me by my manager. I live in New Jersey, USA. Look forward to the expertise of the members of this forum as I jump into customizing a database that I created for work.