Search results

I have a daily inventory on hand entry form. I want to get the last inventory on hand for each item to use as the opening inventory. In my query for the record source of the form I used a subquery with select max:SELECT tblInventoryLineItems.ItemID, tblInventoryLineItems.ItemSales...

I have a pop up form with a datasheet as a sub form. We use the up and down arrows to move between records. The problem is using the down arrow is 4 to 5 times slower than using the up arrow. This becomes a big problem when we hold down the arrow to move down 50 or more records. I believe it has...

How can I make the pgup and pgdn keys behave like an excel spreadsheet where the focus stays in the same field that the pgup or pgdn keys were pressed? Now when I press the page down or up in my subform the focus shifts to the first tab stop of the new paged down or up record. Any code to help...

In VBA I need to check the value of a field on a subform where the control source is =count([quantity sold]) to see if it is greater than 0. There is no problem as long as the subform is not dirty. If it is dirty and I set Me.Dirty = False the value of the count is not updated in vba unless I...

Group Pricing Problem I am trying to create a query that will find all the records where the mark-up field is different than the rest per item. For example: Item# Customer Mark-Up lineitemID 1-----------1---------1-------1 2-----------1---------1-------2 2-----------2---------2-------3...