Stop user deleting all records

[patatrac]

HOW IS POSSIBLE DISABLE IT...
ok shift11

 

[vbaInet]

HOW IS POSSIBLE DISABLE IT...
ok shift11

I think this is now requiring a new thread patatrac. Also, if you do a search on the forum you will find that this topic has been discussed so many times.

 

[SOS]

Oh, the link wasn't there when I did it. Yes, do a new post and in the meantime search google for "Microsoft Access Disable QAT")

 

[patatrac]

Thanks a lot

 

[Robbie]

what does a role represent? can a company have more than 1 role?

Yes a role would be a customer, supplier etc. The reason I did this is because there are going to be alot of companies and I want to be able to filter the list to only show appropriate companies in certain situations, eg: when selecting a customer in a transaction only show companies with a customer role. Sometimes a company can have several roles so it has to be a one to many...

The reason I don't want users to delete all the roles for a given company is because I don't want companies about with no role, because they would not be able to be used anywhere else and would just be a waste of space, and more accurately it would annoy me that they were there!

I like the idea of only letting admin delete roles because this would also prevent inexperienced users from messing up the data!

 

[Robbie]

The following code on your own delete button on a continuous form will display a message box to users telling them how many records are about to be deleted. Replace the names with those of your own Tables etc

Hey Rich,

Would this work in the on_delete event? So users could hit the delete key instead of having to click the button?