Search results

I like the logic in that. So ideally then if the variable is true then it restricts any saves, but if it were false then the user could edit. How does the outline of the code look to create a new variable? (I can figure the logic out on my own just need the syntax really)

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

Thanks. Took your suggestions into account and changed some of the formatting stuff of my code. I also managed to get the append working on my form so it now adds a new row in. Thank you for your help!

Im looking for whatever will add a new row i.e. record or whatever you want to call it to the table tblEmployeeId (holding all information on the employee). The current code does not work as it will not run anything. If i do a breakpoint in the code i found that it gets through all of the...

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

Nevermind i seem to have fixed the problem looking through my database. Somehow I managed to set a number autolookup to a text field in another table so while it showed text in one table it stored it as a number? Anyway thats what created the data mismatch :-) thanks for the help though!

Yea both are actual names ... i.e. Julia Roberts or John Wayne. Something to that effect. And i also tried it the way you had it written and it gave me an error for a missing operator

Yep everything works right for each individual user it calls the report fine except for when its a team manager logging in. the information is getting input into that "hidden form" correctly the problem is that when i try to compare it to the information in the report its getting a data...

Nope, the formUserLoginAccess is the actual name of the form (just my naming convention) forms = form... tables = tbl... reports = rpt... anyway still a type mismatch

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

Thanks that works perfectly.

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

Oh haha. Thanks works perfectly now :D. I really appreciate you stickin with me on this one!

Still not working... now its giving me a syntax error... I've tried Me.Recordset.FindFirst "Emp_ID = " & Me.Emp_ID & " And "DailyDate = #" & Me.DailyDate & "#" and Me.Recordset.FindFirst ("Emp_ID = " & Me.Emp_ID & " And "DailyDate = #" & Me.DailyDate & "#")

Ah thank you for clearing that up. I had no idea :-( alright i'll try what you suggested.

Not particularly. My problem is that its a bound form and if i attempt to go to a new record before preventing the Update then it will automatically save. And if i restrict the update in some way it will mess with the rest of the save things. Currently im attempting to work on an algorithm...

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 it appears that they both work seperately but when i try to throw them together its giving me an error that there is a type mismatch. So Me.Recordset.FindFirst ("Emp_ID = " & Me.Emp_ID And "DailyDate = #" & Me.DailyDate & "#") [with or without parenthesis] Doesnt work...

I tried this with changing the empid to be the field in my table and the iemp id to be the field in the form but im not sure if it works that way. Either way it gets the information from the table tblEmployeeDaily. But i get the error message type mismatch with this code...

Here is the code... where i put the astrix is where i want the other code to go to open up the duplicated record instead... Private Sub Command11_Click() Dim iEmpId As Long If IsNull(Me.Emp_ID) Then If (MsgBox("Not Enough Data!" & vbCrLf & _ vbCrLf & "Please enter a different ID.", _...