Recent content by inkbird01

  1. I

    Login Form - Check if password reset flag before continuing.

    Perhaps another way could be then there is a mechanism to check that when the user logs in, and their username has a temppflag of '1' then show the change password form - how could i achieve this? Something like If DCount("*", "tbl_Users", "username= '" & Me.txtloginID & "' AND Password = '" &...
  2. I

    Login Form - Check if password reset flag before continuing.

    In the admin section i already have a mechanism that updates the tbl_users[temppflag] to 1 when the amdin resets the password. What is not working is that when the user clicks the login button (after the admin has reset their password) - if the username entered has a tbl_user[temppflag] value of...
  3. I

    Login Form - Check if password reset flag before continuing.

    Thanks - the difference is that you use a combobox to store the flag value - I use a text box and only have the username. So should I create a invisble combo box that on the change event of the username textbox gets the flag status as its rowsource?
  4. I

    Login Form - Check if password reset flag before continuing.

    Thanks already have! all i need is something like Private Sub cmd_login_Click() ' CHECK IF USERNAME OR PASSWORD FIELD IS BLANK If IsNull(Me.txtloginID) Then MsgBox "Username cannot be blank", vbInformation, "Please enter a username" Me.txtloginID.SetFocus ElseIf...
  5. I

    Login Form - Check if password reset flag before continuing.

    Hi Plog, thank you for your detailed reply. I had used the code I found on the internet .I am new to MS Access, i like your structure but no idea how to recreate it full work! any help appreciated
  6. I

    Solved Click listbox record, click button then append this record

    Hi, I have a form with a list box (lst) and a button (cmdbutton), I have a stored query (qry). I want to click the record, then click on the command button and run the stored query to update the record selected in the list box? Thanks
  7. I

    Login Form - Check if password reset flag before continuing.

    Hi, I have a login form and a table of users. In the table of users there is a column called TempPFlag that is set to '1' if the password has been reset. I have the following code and want it to first check if the username and password entered matches what is in the table but also check if they...
  8. I

    Open form from Listbox - not record but form for data entry

    Hi, I have a list box that is used for navigation. If the user clicks on a list box item (row) then open the from with that name. I have a table tbl_controls that haves [ID].[Form Name]. I.e on click, lookat column o of the listbox and open the form that match the ID in the table What is the...
  9. I

    Overflow error - not using integer right?

  10. I

    Overflow error - not using integer right?

    Thank, i changed the table field to integer but i am getting an "Overflow" error
  11. I

    Overflow error - not using integer right?

    Hi, my form has a textbox (txt_PIN), when the text box is updated i want to check the user table to see if it already exists. I keep getting errors, i think itt is because of the way the numerical value is being referenced? Private Sub txt_PIN_AfterUpdate() Dim PIN As Integer Dim...
  12. I

    Managing Checkboxes - SQL append and insert

    I have a form with 5 unbound checkboxes (chk_1, chk_2, chk_3, chk_4, chk_5) I want to click on the checkbox, then click a a save button (On click event btn_save.Visble = True) then to insert the value (0 (unchecked) 1 (checked) into the tbl_data.Chk1, chk2 etc Thanks
  13. I

    Solved Click on listbox item and requery report on subform?

    ohh it is working now thank you!
  14. I

    Solved Click on listbox item and requery report on subform?

    O ok, when i click on the listbox item nothing happens to the subform?
  15. I

    Solved Click on listbox item and requery report on subform?

    Thanks for your reply but i get an error " Can't build a link between unbound forms "
See more
Top Bottom