Search results

Please can someone tell me the format for the DLookup validation, if my table name is "Analysts" and the field i'd like to look-up is called "AnalystID". When entering this AnalystID data into the form, how do i write the code in the code builder and also be confident that it will work.

How would u phrase the code? If the table is called tblAnalysts and u want to make sure duplicate data is not entered into the column called Reference? The syntax for the code line is where i'm having problems. Thanks

I have a form with which my colleagues and i enter data into a table. I would like to make sure that the same data is not entered twice by 2 or more different people, so i want to attach a validation code that would check that the reference number has not been entered into that table in the...

I have a form with which my colleagues and i enter data into a table. I would like to make sure that the same data is not entered twice by 2 or more different people, so i want to attach a validation code that would check that the reference number has not been entered into that table in the...

Hi all, I have created an auto-form from my table, and on that auto-form, i've created a combo box with some values in it. What i want to do is: When a particular value from that combo box is selected, i want 2 more fields to become visible so that my employees can add further information...

Right out of the top drawer, that was AWESOME! Dude u made my day, many thanks, many thanks, many thanks! It worked well

Hi folks, I have created a nice form which i use to enter data and populate several tables and everything is working okay but i would like to make things a bit easier for myself and thats where i'm having a bit of a problem. After entering all the data into my form, i hit the SAVE button and...