sja13
Professional Idiot
- Local time
- Today, 15:13
- Joined
- May 3, 2017
- Messages
- 63
Hi Guys, it's the amateur seeking help again!
I want to delete a record from a Table, but that record might be referenced by an entry in another Table.
For example i have a Table of Locations, and a Table of Boards. Boards exist in Locations.
If my user chooses to delete a Location, I'd like to prevent them by identifying that there are Board(s) in that Location.
I faintly remember that in Access 2003, there was a setting such that "Delete Integrity" was maintained, i.e. the Deletion caused a warning that the database would be compromised.
My research suggested that
would achieve my aim - that of automatically generating a warning.
All it seems to de is to warn be I am about to "delete (1) records".
Can anyone point me in the right direction?
Any help would be gratefully appreciated....
I want to delete a record from a Table, but that record might be referenced by an entry in another Table.
For example i have a Table of Locations, and a Table of Boards. Boards exist in Locations.
If my user chooses to delete a Location, I'd like to prevent them by identifying that there are Board(s) in that Location.
I faintly remember that in Access 2003, there was a setting such that "Delete Integrity" was maintained, i.e. the Deletion caused a warning that the database would be compromised.
My research suggested that
Code:
DoCmd.SetWarnings True
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDeleteRecord
All it seems to de is to warn be I am about to "delete (1) records".
Can anyone point me in the right direction?
Any help would be gratefully appreciated....