Search results

  1. C

    VBA code only half working

    Hi All I have built a string of VBA code to reset a password if the user enters all of the correct details. This part works fine. The issue is that if the incorrect details are entered instead of retunring a MsgBox saying incorrect details enterd, it returns an access error Run-time error 3075...
  2. C

    Help with DLookup Mis-Match

    Hi All I have been working for hours and got to the stage where i can not spot what is going wrong with my DLookup. Could anyone please cast an eye? Getting a Mis-Match error. If (IsNull(DLookup("[ID]", "Contacts", "[ID] ='" & Me.Contact_Selector.Value & "' And [Date_of_Birth] = #" &...
  3. C

    expression query 3 calculated dates?

    Hi. I really need some help for something i am building. I have a query in Access that runs however their are a lot of records. What i want to do is have the criteria for Date to pull back the follow records Current Day Yesterday 7 Days ago 8 Days ago 14 Days ago 15 Days ago Can anyone...
  4. C

    Search Criteria

    Hi Please Help I have a multiple item form with search boxes. I want to be able to type in one of the boxes OR 2,3,4 of the boxes. click search and the form will filter based on the criteria. This is what i have so far. Private Sub Search_Accounts_Click() Me.Filter = "Account_ID= " &...
  5. C

    Simple Mis Match

    I have created a Lookup function and i have used this exact layout before and it has worked however this time i get a data mis-match. Can anybody see where i have gone wrong? If (IsNull(DLookup("[Username]", "Users", "[Username] ='" & Me.Username.Value & "' And [Date of Birth] = '" &...
  6. C

    VBA to replace table record

    Hi All. I have created a login form with a password reset function. Everything works with the exception of updating the password. The reset function looks up and confirms the pin exists in that users line on the table/ A form opens "Reset Password" and you need to enter your username, Pin...
  7. C

    Simple DLookup not working.

    Hi All. I think this could be a formatting issue or doing something simple, incorrectly however i am at the end of my tether. Please be so kind to help. Enter_Username = the name of the text box on the login page. Also "Profile field" value is a drop down list selection within the table...
  8. C

    Please help with VBA filter

    Hi All. I am still trying to wrap my head around some of the simple code. Please can someone help with the below. I have created a button called "Search". When clicking it should look at the data put into 1 or more of 7 text boxes (with search criteria typed in) and filter a continuous form...
  9. C

    Value to different form.

    Hi All Im struggling with something that should be quite simple. I have a form named "Task" which can have actions added to it by clicking new it opens the "Add Action" form. Both forms have a field called "Task Id" What i want to do is when you click new action and it opens to form as new...
  10. C

    Adding maximum amount of login attempts

    Hi. I have built a login form that works fine currently with the exception of login attempts. The current features are 1) Checks login is in users table. 2) Ensures the user status is not blocked in the table. 3) Sends the user to the correct page based on their authorisation in the user...
  11. C

    User login form with different levels of access?

    Hi. I have recently started a project and become stuck already. I have a login form created that works (code below). What i want to do is allow access to the users of 1-7 in table (level of access) which will determine which page they view after logging in. IE if the have Access in table "Users"...
  12. C

    Hello

    HI. Glad to be part of the forum
Top Bottom