Search results

I've made a mistake. The count is continuous. Example, 100 IN at 9am then another 100 IN at 10am, then another 100 IN at 11am.. then 100 OUT at 12pm .... such as the sum would be 200 minus the 100 amount of outs.

Hi. I hope someone can help. I have a main form that has a list of occupancies. In and Out. I'm trying to get a counter alert on the main form to display Maximun if the manually set maximum is reached based on the total of entries minus outs in one day. I'm not sure where to do this, on the...

Got it. Sub query is what it's called. Similarly sub macro to macro. Keyword ia probably nested. Thank you.

Your queries worked the same as arnelgp. One of the qry must be named qryLastMovements. This query I understand, you took the max. I have to study them because I don't understand the how the second qry works to display the latest check out that doesn't have a check in yet. Thank you. EDITED...

Your solution worked perfect. Only the records that were needed are pulled and added into a single line. 1. Can you help explain the sql statement that you used? 2. If I'm reading it right, you created the table T because you did not want to change the original records? 3. The latest check out...

Thank you.

Got it. I will test it.

I will try that.

It's from a combo box.

I've uploaded a sample db. I'm looking to not include records that the equipment have been returned. edited: Return a list of only equipments that are checked out and has not been checked in. I tried the max and last in a qry but can't seems to get it to work right.

That's a better idea. I will do that.

I have an inventory table that contains some inventories and a sub table that contains check in and check out records. I'm trying to create a qry that will open a form to show the latest inventories that have been checked out but not checked in. I do have the dates and time of check out with...

Thank you so much guys. I will try that.

I manually coded to lock the fields based on the id field. If it's a new record with no ID number then it enables the fields for inputs. I posted a sample db as well.

The form is to allow new entries only and no deletions or edits. Sorry my msgs are overlapping. Thanks guys for all your inputs.

It is weird. I've tried that already. When I try to force it, only the first record in the sub form allows new entry and any thing else in the sub form does not allow new entries.

This was the original problem. If I locked the main form, (set it to no edit) then the subform does not allow new entries. I've included a sample below. I get the same results as Gasman.

Gasman, yes edit must be set to yes. That was the original issue. If I set edit to no on the main form, then the subform won't allow new entries. I found this odd so I had to come up with another way.

I've included a sample db. You can see what I did. The main form will be the example. Ignore all the other junk reports and etc. Any feed back? Let me know. I did forget to lock one of the field though. Thanks for all the responses.