Search results

I was originally creating it on a command button, but after thinking it through i decided to throw it in the before update for that exact reason that it is a bound form. Edit: Although I can't do it on the before insert portion because it compares 2 fields on the form to 2 fields in the table...

Hmm so i tried to put the code in and im not sure if its not necessarily comparing it correctly or not but it seems that every time i put in any sort of entry whether it is a duplicate or not it automatically rolls over to the msgbox i put in. It might be because of the fact that im not totally...

So I'm trying to put a check on this table to prevent one user for putting more than one input per date. The problem is i cant do this with a primary key cause multiple users use the same table instead of creating the same table for hundreds of users. I attempted to look up some sort of...

I took that same basic idea and simply applied a if statement that returned them to the menuform having the same effect as a cancel. So thank you for the idea :-)

Ok so call me stupid or whatever but i forgot to code in the second half of the input box in case the user hit the cancel button. My code looks like this DoCmd.OpenForm "formUserLoginAccess", acNormal If IsNull(Forms!formUserLoginAccess!txtUSL) = True Then intCaseN = 2 Select Case intCaseN...

Ah thanks :-)

That worked well. Although i guess i have the wrong command? It keeps trying to print that report to the default printer. What is the command to view it in access?

Hey, So i looked up some other threads on getting filters on reports pre-emptively before you actually open the report. What I am trying to do is take my ULS which contains the last name and the access level and look up the user ID number (which is displayed in the employeeinformation table)...

Thanks worked like a charm!

So I want to put in some code to restrict the user from pulling up anything other than the initial Login screen. Currently that form is the formUserLogin and is set to be loaded on startup. Does anyone know a way to write code to either loop the focus onto the login form or if they open...

While you didnt directly help me you move me in the right direction. The problem i was having was i was trying to access a table cell that wasnt there! Although I will implement that replace on my password! So thank you for that too :)

This might be an easy question it might not be. I'm having another problem with my code and either my eyes are goin crazy or i just dont see where the problem is. Anyway my code is basically supposed to take the password and put it into the system along with the generic user security level...

Haha wow. That solved it -.- Sometimes i hate computer code... i really do!

Fair enough. I suppose i should have thought about that.

Ok so I keep running into problems with my code :-( . This time I'm trying to add in another aspect in case there is no initial password for the user. For the first time login i have them input a password anyway and then it pops up a messagebox. This works great. When the message box attempts to...

Thanks again SoS :-P

Actually I solved my first problem by inputting an OpenForm "UserLoginAccess" form command at the beginning of the login if statement. The second question still stands however. After some thinking would i have to limit the access on each of the commands that the user would be doing for an...

So I have modified the basic user level login script to fit my database and have come to a problem that i need help solving. What i currently have is a user password and access level in my employee information table. When they login it checks the password and then logs the user and the access...

Alright, Thanks a lot!

Ah i suppose it is a bound form. So if I used a beforeUpdate event how would i keep it from saving the data? Maybe msgbox?