Search results

I'm working on a button that takes the user to the previous entry for that date/employee. I have that coded but the problem is that I need it to delete the record that they had put in for that date. Example they put in 1/1/09 and enter data... they try to save... an error message pops up...

So i did a little research on recordsets and tried to get my code to put a new record in for a new user. The form has 4 fields that input and 2 that are a access check. The code basically checks if the desired password and confirmed password are the same.. if the admin and password are in the...

Im trying to filter the report based off the team manager's name. When i do this I have the name put into a hidden form called UserLevelAccess. When they open the report it should look in that textbox marked txtTM and apply it as a filter on the report. Here is the code and the line marked with...

I searched this forum for autopopulating but nothing really seemed exactly like i'd like it to happen. What im trying to do is once the user is done changing the information i.e. his name... it will autopopulate the ID from the information in a table. Im currently using the onchange event of...

So I'm working on an algorithm to prevent the user from putting in duplicate records for the same employee on a particular date. BUT i DO want to allow the user to edit his previous post. As a result I cant do a cancel on the before update but if i ignore the before update then I cant...

Ok so my database contains a duplicate record check. My boss wants me to have the prompt box that comes up if there is, take the user to the duplicate record to modify instead of what it currently does which is asks if they want to save a new record. Can someone help me with this general line...

So i've created the checker to make sure that the user entered a name that matches with a form. The problem is that when i use the Dcount function no matter what the user enters it is considered false (0). There is a table with all of the form names in it and what Dcount is supposed to do is...

Hey I'm writing this prompt box and I want to have it check to see if there is anything entered in the drop down menu except what is supposed to be there. If so I would like for it to do a MsgBox saying error please put something in ... yadda yadda. My problem is every thing that i have tried...

I have created a custom menu bar that checks for duplicates via before update. This menubar attempts to bypass it however when i close the form and try to open another it keeps giving me the error you cannot modify a new report while another is already being processed. here is my code...

Ok so I have the basic outline for how to check for duplicates but my problem now is when im comparing two different text fields that have text/numbers EX: Enter the week/month (drop down menu with Aug/01, Aug/02, Aug/03) ect. I have my code to check the Emp_ID with the table and to...

Ok so I'm in a function on a beforeUpdate event and I have it set so that it cancels the event in case of duplicates. The problem im having is that if they navigate away from the page via that button it will continue to leave the form. How do i cancel that event as well ONLY if there is a...

Ok quick question. I have looked up on the internet and found nothing about it but is there a way in a prompt box using VBA code to set a drop down menu instead of a string field input?

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

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

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

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

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

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

Ok so this is a rather simple question. Im somewhat new to VB but Im creating a button to check if something is in the table with a Dlookup but I dont know what the command is for save. My code looks like this If =Dlookup("Emp_ID","tblEmployeeDaily","Emp_ID=" & Emp_ID AND "DailyDate=" &...

Ok so I am kinda new to Access I have managed to create a database and have a form that updates the password into a table after they click a button in the password field. Now what i want it to do is to create a Msg box on my other forms prompting a user for a password then checking it against...