Recent content by Lissymd

Hi I've copied the code you posted and now I just get input boxes popping up asking for parameter value????. Lissy

Hi I seem to be getting a syntax error from the "FROM" statement down. Here is the code I'm using, (The only thing I have modified is the table and field names to match mine.) SELECT EmpeID, EmpeSurname FROM tblEmployee WHERE NOT EXISTS (SELECT EmpeID, MAX(Jap_Date) FROM tblJob Application...

Ok What exactly do I put on the form? Do I just use an ordinary form?

HI Yes I wouldn't mind trying this solution Lissy

Hi There is no "input mask" property for the button. I am using a command button on a form. The code is placed as an event procedure of the "on click" property. I have been through all the properties for the button several times and input mask is not listed. ??? Lissy

Where is the input mask properties? The code I'm using is: Password = InputBox("Please Enter Password") If Password = "password" Then 'Run Button Code Here This is placed in the "on Double Click" event. Lissy

Ok, your on the right track. I want to display a list of all the employee's who have not applied for a job (job application) within 3 months. Also, if possible, change the account status of an employee to "Hold" if it fits this criteria. (Not totally essential for functionality as the user can...

Can someone please help me with this problem. I am designing an employment database and need to create a query that searches an application date against an employee and if there is no date registered over a 3 month period, it displays the employee's name. If you don't understand my problem...

Hi I am using the simple password protection code on a command button that opens a form. Is it possible to encrypt (or something to that effect) the password when a user types in the password? Otherwise, anyone can see the password as it is being typed. Thanks Lissy

Sorry about that, I didn't have the 'end if' statement in the right place Lissy

Hi I am trying to password a form which is opened using a command button. I have tried just adding the simple password protection code but you can just click on 'cancel' or 'ok' and it will open up the form. Can anyone help? Thanks Lissy

Hi I am using a parameter query to prompt users to enter in ie their name to produce information about them. Is there a way that whent he input box prompts them, you can set or point it to a combo box for the user to select their name rather than having to type it in. I am trying to avoid...