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.
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...
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...
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.
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...
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?
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.
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.