Search results

Not fully sure what your looking for as far as help goes but a couple of suggestions: trying using cmd buttons for record navigation, form navigation and reports and quieries this makes it easier to navigate through your database. You also want to try and make your information easier to...

The whole god of war series. Really awesome game, graphics and story mode are really well designed. The thing that makes me hate it however are some of the puzzles. If you dont go online and cheat a little on some of the puzzles a person could get stuck for hours. The very first God of war...

Just wanted to say Thank you to everyone that has offered their help and guidance over the past few months. I present my DB next Thursday to determine whether or not I graduate and because of the functionality of my DB I know I am going to pass with flying colors. There is no way that it would...

Bob, Thank you so much. It works perfect. I cant believe you did that so quick. I have been working on that for over 2wks now and you managed to do it in only a couple of hours. I cant thank you enough, my stress levels are going to drop significantly now. Again thank you for all your patients...

Bob if you send me your email address I can send you my updated DB. the zip file is to big to repost Ive been entering in a lot of data to test it out. I made some really nice updates today to it. I want you to know how thankful I am to you, for taking your personal time to give assistance to a...

I have created a new form that is just logout, the other one is just login. Sorry it took so long to get back to you I was watching the MN Twins throw a no hitter.

I am so sorry to hear. Thank you for informing me.

Dcrake, I am curious on how I can store the logout time onclick_Logout. I have managed to create the login but when I try to log out it tells me I have a data mismatch. This is where the debug tells me that I have that mismatch. Set Rs = CurrentDb.OpenRecordset("SELECT * FROM [StoredLogins]...

Yes, multiply people will be able log on to the same computer as one user and start working on trouble tickets. So running things in the background would not work unfortunately. If a user forgets to log out for the day then when the DB closes to logout all users, and then an administrator would...

The reason I am tracking the agents login and logout times is because every week the agent will be required to volunteer two hours of their time working on various help desk issues. It is part of the requirement for the class. Its the equivalent of when a person is logging in and out for work. I...

Bob, Great news I can store my login right now, however I cannot logout. Its telling me a data mismatch Function CloseSession() 'This closes the open session Dim Rs As DAO.Recordset Set Rs = CurrentDb.OpenRecordset("SELECT * FROM [StoredLogins] WHERE SessionID ='" & LngLoginId & "'") If...

Thanks a lot I appreciate you taking your time to have a look at.

Thank you for taking time to have a look at this. Much appreciated. None of the information in here is valid. All bogus data to make sure things were working correct most of the passwords for the logins are passw0rd with a zero.

Ok so the red is where I am running into issues now. I am trying to take the agentID from the cboAgentID and have the module store it in the my storedlogins tbl. First thing: I am not sure where I declare that LngLoginID = Me.cboAgentLoginID 2nd: It keeps telling me that I cannot add or change...

Ok this is where I was getting confused and is starting to make sense now that you mention that. My AgentLoginID can either be a length of numbers if you are a student agent and if you are an instructor agent more than likely your loginID is going to be letters. I have AgentLoginID saved in...

Hey Im curious where I am going wrong with this. I currently have it in a model labeled sessions and it is not saving anything. Am I supposed to call the session with cmd_Login_Click? I am not sure how to do this if I do have to. Where else might I be going wrong? Option Compare Database...

Thank you bob that is twice you have saved me from throwing my computer out a window today. if you have any examples of how I could create a Login session for my agents that would be extremely helpful thats about all I have left to create and I have no idea of how to create the login session. I...

This is my code to authenticate my log ins where the code is red is where it is telling me my first error is any suggestions on how to make this work? it says its a run error 3464 data mismatch Option Compare Database Private Sub cmd_Login_Click() 'Check to see if data is entered into the...

Bob, Thank you so much that does exactly what I wanted it to do.

I do have access 2010. I agree that it is a little backwards but the reason is that I am using the reports to generate what Trouble tickets I have that are Not Started..and so far and then by double clicking on their name or id it will populate in a form for me.