Search results

I never needed one, just did a Google search and posted some of the results...

http://cpap.com.br/orlando/AccessCalculatorMore.asp https://answers.microsoft.com/en-us/msoffice/forum/all/calculator-in-microsoft-access-form/9be22ea6-eea1-4040-993f-09dfd9dc7067 http://www.mvps.org/access/downloads/calc.zip

Actually even easier would be to add a composite unique index on EmployeeID and BoughtYear fields in the tbluBoughtPTO table so the unmatched query would not be needed.

I agree that the first step should be a SELECT from tblEmployee but at one point (either here on in the subsequent INSERT) you would need to bring in the tbluBoughtPTO with left outer joins pointing towards it and Is Null in the EmployeeID from it (and also criteria for the year) to eliminate...

In the first column of your query change the table name to tblEmployee (and you don't need the tbluBoughtPTO table in there). I suggest you do it in two steps; leave the current query as a Select one then create a new one in which you join this new query to the tbluBoughtPTO using outer joins...

Because you want an index or rank, not a total count; have you tried to use my link?

It would if you restrict it by record\order id as mentioned in the code comments, unless multiple users are working on the same order....

You could also consider having two multi-select listboxs side by side in the classical Available<->Selected setup and implement code in double-click event to move from one side to the other in conjunction with the four usual buttons (<-,->,->>,<<-). Cheers,

Add a line to the click event of the button to update the Purchase field to False: CurrentDb.Execute "UPDATE tblYourTable Set Purchase=False Where Purchase=True" 'might need to add extra criteria such as a reference to current record ID' And then refresh the subform. Cheers,

I think you need to use a ranking query grouped by student and sorted by the RecID to get what you need: http://allenbrowne.com/ranking.html Cheers,

That is exactly how my utility works... Cheers,

Have you looked in the double-click event of whatever you double-click on the form (in the VBA editor)? Cheers,

Have a look at my free custom chat utility: http://forestbyte.com/ms-access-utilities/fba-ms-access-custom-chat/ Cheers,

BoatCapn, I agree with others regarding the optimal design of a relational database; in your case to simply look over your EDP across 12 related fields in the same record using your old Excel table the answer is in post#7 and now we are at #26. Cheers,

So look again at my initial post (#7). Replace the textbox Input with a combo box as it easier to use because of the autocomplete feature and not prone to misspells like a textbox. Also you want the Input to be in the form header, not the detail. Once you set up the union query and use it for...

And I am not saying it should be used as the form recordsource but the search combo's row source.....

Steve, what exactly is the problem with your form? Are you trying to search\load a specific record by inputting an EDP # and look for it in one of the 10-12 competitor EDP? With your current model you can make the input a combo box with a union query as its row source: SELECT [Our EDP], [Comp 1...

If trying to save the current record in a form you should try to replace the existing Docmd.RunCommand with Me.Dirty=False Cheers,

That is my point, it is the report itself that is the problem. I shouldn't say the report only, it is probably what feeds the report. Without seeing the report we have no way of helping you, so if you can't provide a small db sample with the report at least show us the report's record source...

Then you need to inspect the report and specifically its record source, it seems like the parameter used in that is not being refreshed. Can you post a pic or the SQL of the recordsource? Cheers,