Search results

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

Hi, I have following codes written in module to open form: But it is not working. So plse help me. Public Function Openform(myformname As String) DoCmd.Openform myformname End Function **************************** Private Sub Command2_Click() Openform (“deleteDataF”) End Sub

okay Sir, But how do I call that code from module (or what code should I write in PasswordAddF form where textbox name =textpw and command button name= cmdOK) Thank you sir, sangpo

Private Sub cmdOK_Click() If dlookup("count(*)","UserT","password= '" & CStr(textpw) & "'") = 0 then MsgBox "Sorry, Your Password is incorrect." Else DoCmd.Close acForm, "PasswordaddF", acNosave DoCmd.OpenForm ("editRecordF") End If End Sub Sir, I meant to say that this code will...

hellow Sir. Please refer to the below code that u have suggested. U know Sir this code will only open the form which I have named as editRecordF . I have marked the name of form with #######. So i wanted to know if there is any possibility to call this set of code from anywhere within the...

dear jon sir, I have gone through the link that explains about procedure and module. Since I m in learning stage, I really rlealy cannot undestand much. thanks alot