Search results

  1. K

    Creating userlevel access type mismatch error

    I'll just leave this right here: https://youtu.be/n-wUdetAAlY
  2. K

    Creating userlevel access type mismatch error

    Right, but the way this has been built; it's impossible for users to get here without a login and password except for me. I'll look into your second suggestion though even though I'll probably be the one assigning usernames.
  3. K

    Creating userlevel access type mismatch error

    Thank you, sneuberg and pbaldy. Works as intended.
  4. K

    Creating userlevel access type mismatch error

    I'm getting the following: SELECT UserT.AccessLevelID FROM UserT WHERE (((UserT.Username) = testuser)); SELECT UserT.AccessLevelID FROM UserT WHERE (((UserT.Username) = testuser)); SELECT UserT.AccessLevelID FROM UserT WHERE (((UserT.Username) = testuser));SELECT UserT.AccessLevelID FROM UserT...
  5. K

    Creating userlevel access type mismatch error

    I think I could do with less criticism from the likes of you. I am trying to solve the problem myself as much as I can so that I might learn something, but since you asked: Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb() strSQL = "SELECT...
  6. K

    Creating userlevel access type mismatch error

    I tried using DLookup, but I was having issues trying to get it to pull the right data. I'm trying to implement recordset as we speak, but I'm missing a parameter I'm trying to track down.
  7. K

    Creating userlevel access type mismatch error

    Right, well I also Dimmed as a String, but then I got type mismatch Here: If UserLevel = 2 Then
  8. K

    Creating userlevel access type mismatch error

    I have a form the end user logs in on. When successful it opens a menu form that grants access to other forms. I want to restrict these forms to read only or full rights based on their userlevel. If the userlevel is set to 2 it should be read only. So I have a query that pulls their userlevel...
  9. K

    Append Query "Too few parameters. Expected 1"

    Awesome, Thanks. Works perfectly!
  10. K

    Append Query "Too few parameters. Expected 1"

    Ok so I have a button on a forum that should append the data from this form to a table. The query works perfectly, but I'm getting an error. Obviously from the title I'm getting "Too few parameters. Expected 1" Any ideas on what I'm missing?
  11. K

    Gun laws do they work

    Gun laws are stupid. You can order parts to an AK47 and piece it together completely unregistered and drill one hole to make it entirely automatic all for around 400 bucks.
  12. K

    Story

    jumped over the
  13. K

    What's your best/worst joke?

    I plan to live forever, so far so good.
  14. K

    Hey from Florida

    Hey guys, I've been browsing this place a little bit since I started creating a simple database for work. Seems like a great community. I look forward to being apart of it.
Top Bottom