Recent content by csdrex87

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.