Search results

Yes it works. Thanks a lot. To verify, I have this percentage field, is it correct If I use this txtQAScore.Value = Format((txtAPE.Value / txtTPP.Value), "Percent") Sometimes it gives me an error if the value is 0/0.

How can I add multiple fields? I have almost 15 textfields with values and i want to get the sum of it. I have a total textfield where the sum of all these fields will be inputted. How can I get the sum not using the 'txtAPE.Value = txtAPE11.Value + txtAPE12.Value + txtAPE13.Value +...

How will I use the "WHERE" clause in my recordset? Like this? Set rst = db.OpenRecordset("SELECT * FROM tbl_UsernamesQry WHERE [Enterprise ID] = '" & strUsername & "'", dbOpenDynaset) Ive declared the db as DAO.Database and rst as DAO.Recordset in my GVar Modules, which is the Global Variables.

I have this Update Entry Form.. I have so many fields here but the logic thing to do was, when I open the Update Form, the textfields will display all the data that it can get from the table I've made. Then I can edit those fields and when I press SAVE button, a prompt will show if the data will...

It still doesnt works.. but thanks to that because it is really a big help,, I've added my codes before and now its ok.. still you help a lot.. Thank you so much.. Here is my final code for that which it really works..:) Private Sub btnSetOk_Click() If (Me.txtSetPassword1 <>...

Hmm.. what may seems the problem since I copied the code to the OKButton but nothing happens, there is no msg of password changed or password mismatched.. :(

In my Login Form, the Combo Box of users are all existing according to its table, anyway I still used your code, I tried it, yes it works for Login Form, and SetNewPassword Form is shown, but in the OK button of the form it doesn't works, If I typed the passwords in the 2 textfields the...

Answer: *Data type of [Enterprise ID] > in my table tbl_UsernamesQry is Text * Rowsource > SELECT tbl_UsernamesQry.[Enterprise ID] FROM tbl_UsernamesQry; Bound Column > 1 Column Count > 1 Column widths> [empty] Name> txtUsername *Is the set password form bound to...

Thanks for suggesting to use CODE tags, i dont know about it.. i am very new here.. but thanks with that. In the Login button there is dropdown menu for usernames, if the selection reads that user has an empty password, the Set new password form is displayed. Login Form If...

Sorry for the late reply, it works. I've learned a lot in your suggestions and answers. Thanks a lot. ;)

Hi I am having a problem with my codes.. :banghead: I have a login button in which if the username has an empty password or the user is his/her first time to login, another form will appear which is the Set New Password. How can I change the password of that current user, my Set New Password...

Hi i am such a newbie with MS Access 2007. I am trying to make a form and there are few questions I would like to ask. Form2 Text0 = Textfield for ID Text2 = Textfield for LName Text3 = Textfield for FName btnRet = Button for retrieve when ID is entered in Text0 btnUpdate = Button for...