Search results

Hi All, On a form, I want to disable the save button, 'cmdSave' whilst the form's mandatory fields have been left blank. I've put in a smart tag, called, 'Req' against each required field and have used the following code on the forms current event. Private Sub Form_Current() Dim ctl As...

Hi, I need to be able to produce an error on a form where the user attempts to create a new user that already exists. The error needs to be produced when the save button is clicked. Please see below for the existing code on my save button which exists in form, 'frmAddEditUser': Private Sub...

SOLVED: Search Form & Error Messages Hi All, I have two unbound text boxes and a search button adjacent each that allows me to search for a user via two methods: 1) Payroll ID 2) Surname They have the following code: txtPayrollIDSearch Private Sub txtPayrollIDSearch_AfterUpdate() Dim...

Hi All, I have a simple search form that has a two text boxes and two search buttons. One of the search buttons and text boxes is as below: txtPayrollIDSearch and cmdPayrollIDSearch I have the following code for the search button: Private Sub cmdPayrollIDSearch_Click() If...

Hi All, I have several forms which are basically a copy of one another, the only difference is is that each one has a combo box or two missing, and or a variation of buttons. I also have some simple vba code I want each of these forms to use. At the moment I have the code on each form, but if I...

Hi There, I'm not sure that this is the correct section... I have a form whereby a user for my database can be created. The fields required are listed below: Payroll ID Forename Surname Location Manager The last two fields are related to two other tables; tblLocation and tblManager, which...

Hi All, I'm not sure about the best way to go about this as I'm new to access... I've got a bit of a headache so hopefully I am explaining things properly! I'll explain the relevant tables first: tblEmployees UserID (PK - Autonumber) PayID (Unique employee ID) EmpName (Employees' first...