Recent content by Sangpo

sir/madam, what is the code for displaying warning message when enterenig duplicate information in unbound form in BeforeUpdate event procedure thank you

I have shared my database over local area network, it does work fine. but others can delete the database . So it is not safe to share. How do prenevt others from deleting ? Thaanks mr. sangpo

i mean it works fine now. I am so careless in typing. sangpo

Sir, eugin, Not it works fine. so Thumbs up for you. all those in learning stage surely must have benefited and thank you so much. I applogise for wasting most of your valuable time making me to understand. U know since it is self learning, it very difficult under the programming terms . Thank...

sir this is for both security reason and learning . No matter sir for getting into very part of my db, because is for pr acting only. I think many people like me who is learning VBA access would be benefited and all credits owe by you . Thank you

Thank you sir, I have downlaod the corrected db of mine. But here, it is not opening the form called addRegistrationF. Refer the mainMenuRegistrationF. Here when I click add registration, button, it must prompt for password input. If the password i have stored in the table userT matches with...

i have forgot to add ome more button the main form. so im uploading the db gain for better understanding of problems. thank you sir

i have uploaded.

Eugin Sir, I gave copied the code you have provide. Now no action when I click ok button and same when i enter the password also. when I click the cancel button the form closes. My password is store in table called userT and password is dra. So where in below mention Dlookup code insert. ...

Sir, Yes I get password box . but when I click Ok I get error message as InValid use of properties If I remove the code Form visible then error message i get is as argument not optional . Can pleaese the following code if I have written in sequence? Public Function...

Sir, still not working

Dear G37sam Sir, The below is a part of code suggested me for data searching. This code is simple and short which is better than the code I have been using. Thank you for that. But i would appreciate if you explain how does this codes work. MY QUESTION IS , WHAT DOES ("count(*)" ) AND...

Dear Eugin Sir, As suggested by you i have written following code inside module.Then I tried to call this function from frmpassword_box Where the code are written like this. Private Sub cmdOK_Click() Form Visible Call_Password_Box '("addRegistrationF") 'password ...

yes I tried,but still probelms. Anyway thank you for response.

I am trying to open forms using function Just to learn more about function and procedures. With this code I get error message, ambicouse name detected