Search results

Hello. Here is my situation...I'm making an "Process End of the Month Records" button on a switchboard page. The user will click on this button at the end of each the month to finish her monthly process. What I want it to do when the button is clicked on is: 1. Run a form that asks the user...

Thanks for the help. I had someone here at work look at it too and we renamed the option box and put the code in the Before Update event so now it works. Here is the only part we changed: Private Sub Form_BeforeUpdate(Cancel As Integer) 'Field validation when a work order record is marked...

Its still not working. Here is what I have so far. Private Sub WorkOrderStatus_AfterUpdate() 'Field validation when a work order record is marked as complete If WorkOrderStatus = 2 Then If IsNull(Me.Descrip) Then MsgBox "Description is a required field."...

Hello. I hope someone can help me or point me in the right direction to get help. Here is my problem: I have a form, frmNewWorkOrder that has an option box on it. The option box has two options, "Pending" and "Complete". The values for the options (Pending = 1, Complete = 2) are stored in the...

Thanks for all of your help! I ended up making a form and using a message box. I made a seperate form for each query that is on the switchboard. When a button is pressed on the swithboard it runs the corresponding form. The form gives two options: Run Query or Don't run query. When you...

That is what I started off doing actually. The database that I'm working on was created by someone else and they originally made macros to run the query. And they used the message box function in the macro. But the message box saying "The query was run successfully" ran every time even if the...

Hello. I am new to Access so any help or point in the right direction would be greatly appriciated. In my main swithboard(which was set up using Switchboard page comes up with 5 buttons that all run seperate queries. What I would like to do is, when the user clicks on a button to run a query...

Hello. I am new to using Access so bare with me :) I am working on a project for work that has me testing Access's built in security features. I used the Security Wizard to create groups and users. My problem came when I set up group permissions. I want Access to display a message box...