General advice on forms

[Hayley Baxter]

I was just wondering I notice that in the northwind.mdb the forms where you can add,amend and delete records are not protected. By that I maean you can highlight the text and press delete and there it goes as easily as that - do most of you create your add,amend and delete forms in the same way? I know you need to do this to amend but at the same time users can accidentaly delete data when they don't really mean to so what happens there if it is designed in this way? I know how to protect data to disable and lock but if you're going to have add, amend and delete on the same form you cannot do this!

 

[Accessable]

What I personally like to do is have a command button or toggle button on my form that locks/unlocks any worrisome fields. I do this with code. When the user clicks the button, I set the locked property of each field I want to protect to yes (locked). I also put in some statements that if the fields are locked and the button is pressed again, unlock the fields. I like this a lot as it is simple, easy and effective, and you still have access to the tables whenever you want.

I also have seen this done using update/add/delete queries. Somehow, the programmer locks the tables for any editing except by query. I personally do not like this because then no updating can occur from bound controls. However, I must admit I know little about this method, and the added security must have some advantages, especially where security is a real issue.

Feel free to reply if you need more.
Hope this helps!
-Mark

[This message has been edited by Accessable (edited 02-21-2002).]

 

[LiamIngram]

I dont want to seem like im prying or anything but what is it that your company does, because by the posts of yours that i have read your database seems very similar to mine.
And to know there is someone out there doing similar work to me is a relief as we could share ideas and help each other out.
Now I'm not pretending that I am an expert, because im not but I'm certainly learning alot quicker than I first thought I could.
Anyhow please come back to me, even if it is just to tell me to p**s off and not to be so nosey.

Thanks,

Liam

 

[Hayley Baxter]

Liam

I work for BskyB. I am still very much on a learning curve myself but this forum has helped me a great deal. If I can be of any assistance to you then I wouldn't have a problem giving you advice but I tend not to give out to much information on the forum only if I really know the answer. No point in me confusing others when I am not 100 per cent sure myself.

Hayley

 

[Rich]

Any chance of a free dish and decoder then?

 

[Hayley Baxter]

Would love to help you out there Rich but I wouldn't get a say in that matter!!