Recent content by kellan4459

I appreciate the help! It worked that way.

I have a form that will not load the records on open. I have an on open command that points it to a new record but I would like the user to be able to go back through the list to edit prior entries if need be. Why will it not load all records. The control source is a query and when the query...

I need to develop a report that will check the database for all names who have not had an evaluation in the past 30 days. The tables are linked by Social Security Number. They have multiple evaluations per person.

Thanks ya'll that should take care of it. Makes perfect since! Landon

If I have a table Called Submittal ID which consists of ID, Component, Award Date and a second Table which consists of Area, Area Description and I want to have two combo boxes one to select submittal ID and with that selection update the second to choose area associated with the submittal...

that did it thanks

Does anyone have a clue??? Please Help!

What Reference has to be turned on in order to get the third option of get data based on selection? I can't seem to find the correct Reference! Thanks Landon

I figured it out after I posted and when I came back to post I found the answer you had already posted. I was letting you know what I did to fix it.

I set it up to where I ran a query to set Current Pay = Original Pay, which clears out any earlier data calculations. I then run a second query that sets Current Pay = Current Pay + Pay Change. When it cycles through it then updates accordingly. It works for what I need it to do. Thanks for...

Please help with the following problem http://www.access-programmers.co.uk/ubb/Forum7/HTML/002491.html thanks [This message has been edited by kellan4459 (edited 12-03-2001).]

I have developed an update query that is set to update all pay evaluations to give a current pay. It needs to go through and calculate Original pay + all pay changes(multiple) Basically you will have 1 original pay and multiple pay changes. I need it to loop through and update current pay base...

Solved!!! With no further help WooooHoooo!

The SSN is indexed so it won't give duplicate entries. I am unable to add new records because it keeps saving the Combo Box Value at 0? When I place in the code that I was given by others to look up values, which was the Find method with the bookmark method the code will not work. If you...

I have asked before but I didn't get the solution. What I am looking at is a Table Named EmployeeData. This table contains the fields {SSN, LastName, FirstName, MiddleInitial, OriginalHireDate, OriginalPayRate, Discipline, Level} I want the combo box to check if SSN(combo box field) has been...