Normal Topic How to control deleting sub records (Read 729 times)
obfusc88
Full Member
***
Offline


No personal text

Posts: 194
Joined: Dec 17th, 2005
How to control deleting sub records
Jan 21st, 2006 at 3:05am
Print Post Print Post  
I have many subforms on the same parent form.

How can I disable the F3 key for certain sub forms but allow it for other subforms.  I want to be able to allow Delete from some sub forms but not from other sub forms.

  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: How to control deleting sub records
Reply #1 - Jan 21st, 2006 at 6:11am
Print Post Print Post  
On Form Enter, use NotifyForm(4)

Or, put it into Form Exit with other conditions.
You can combine NotifyForm(4) with a User ID or other conditions to only allow if certain field values exist or a specific person or group member is accessing that record.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: How to control deleting sub records
Reply #2 - Jan 22nd, 2006 at 10:21pm
Print Post Print Post  
I just noticed that Programming Guide, page 36 only references 2 options for NotifyForm(), but all seven options are noted on page 192. 

Suggest making reference on page 36 that seven options exist, not just the two shown.

  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: How to control deleting sub records
Reply #3 - Jan 23rd, 2006 at 2:16pm
Print Post Print Post  
Quote:
I just noticed that Programming Guide, page 36 only references 2 options for NotifyForm(), but all seven options are noted on page 192. 

Suggest making reference on page 36 that seven options exist, not just the two shown.


Page 36, and that entire little section, is meant to be a quick reference for general syntax and a brief description. If every flag or option for a command was listed there then the section would grow vastly and would not be as usable in my opinion.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: How to control deleting sub records
Reply #4 - Jan 23rd, 2006 at 4:55pm
Print Post Print Post  
Ii agree, but since it listed 0 and 1, I thought a mention that five others existed would be helpful, was not suggesting all the details.  Just enough to sugget more reading was needed.

Not a big deal.  Just thinking about how the initial question may have been missed.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
obfusc88
Full Member
***
Offline


No personal text

Posts: 194
Joined: Dec 17th, 2005
Re: How to control deleting sub records
Reply #5 - Jan 24th, 2006 at 5:02am
Print Post Print Post  
Thank you for telling me about the NotifyForm=4. That is working for me now.  And I agree that more about NotifyForm should be in summary section.  I did not know that this existed and never would have found it if I did not find out here.  I have printed out those 10 summary pages for reference for all commands and did not see anything about stopping Delete.

  
Back to top
 
IP Logged