Restricted Data Enty

Resolved · Low Priority · Version 2007

Wed 9 Mar 2011, 16:01 Delegate Vivien said...

Vivien has attended:
Access Introduction course
Access Intermediate course

Restricted Data Enty

Hi there,
I have a with Work hour list. once I enter the name or the work code I would like a message coming up if the name or the work code are not in the related tables-so I am not able to enter anything that is not in the list. It should asked of I want to do a new entry if I press yes the form for the New Employee entry or the form for the new Work code should come up.

CAn you help?

Tue 15 Mar 2011, 12:43 Edited on Tue 15 Mar 2011, 12:44 Trainer Jacob said...

RE: Restricted Data Enty

Hi Vivien

Thanks for the detail on your post.

I have run this by one of my team and they are reasonably confident that you can pick up the skills to create a solution yourself by attending our 2 day Access VBA course, more info here

Regards

Jacob

Tue 22 Mar 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Modal forms

If you have created a form / switchboard and dont want people to get away from using the switchboard, you can change the form properites for Modal to On.

View all Access hints and tips