Search results

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

Any ideas as to how I might get this to finally work???

If you change the name of a query you will have to go back and change the query name in any field that points to or calls that query. As far as sorting the queries in the query window I'm not sure of any way to do that but one option you can use is creat a Form Called Queries and set up a bunch...

sent file

I have a sample similar to this I will e-mail you. I started with a form with a combo box to find the person I want. When you hit the open button it then pulls up a list of items related to that person(based on a query). When you select the recordset you want to edit it then opens that record...

First create a query that will pull all the information you want to be able to edit for the current PTAS. Once you get that query create a New Form based on this query. Once you have this form set up you should have all text boxes bound to these fields. Then go back to your query and set it...