D
Daniel Lees
HI
I am doing a database and have a primary key in a table which prevents
duplicates, but i want to be able to check that and show an error message of
my own before access complains. I have a data entry form that has an ok
button access complains when this is pressed can i put my own message up and
return back to the form if it is a duplicate but execute a different set fo
commands if it isn't?
I have a similar thing in that i want to do the opposite check the number
entered into a form is in a specific table if it isn't allow the user to
change it, if it is carry on and execute a macro or set of commands
Can any1 help me plz
Cheers
Danny
I am doing a database and have a primary key in a table which prevents
duplicates, but i want to be able to check that and show an error message of
my own before access complains. I have a data entry form that has an ok
button access complains when this is pressed can i put my own message up and
return back to the form if it is a duplicate but execute a different set fo
commands if it isn't?
I have a similar thing in that i want to do the opposite check the number
entered into a form is in a specific table if it isn't allow the user to
change it, if it is carry on and execute a macro or set of commands
Can any1 help me plz
Cheers
Danny