Search results

Thanks for the suggestion I will try the dynaset setting. I figured if the query results were not update-able due to the sub-query then then the records on form would not be either. The inner -join in the sql was just part of an attempt to get at the last inventory on hand date. My form is set...

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

Thank you for posting this code it is exactly what I was looking for. However I am still struggling with implementing it properly. Everything looks great on start-up the main access window is hidden and my form is popped up but when you click on the icon in the task bar the main access window...

this issue is the same on every computer laptop/workstation/server new old etc... we tested on 7 different platforms all with access 2010 with the same results.

Version 2010

Thanks for the reply but unfortunately that didn't help. Anything else I could try?

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

Thanks Bob, I was really hoping to have the pgup and pgdn work like it does in datasheet view as my users stretch the form to fit their screen. In datasheet view it appears to calculate that change in size of the form. I am going to try to convert the form to datasheet view and write code get it...

The code Bob posted works well but only moves up or down one record. Is there any way to mimic a full page up or down function in a continuous view form? I tried using move + a number of records but this doesn’t work like the real page up and down. When my form is in datasheet view pgup and pgdn...

Thanks for the rapid reply Bob I really appreciate it. I happened to be reading one of your other great posts just now. That code is great I currently use an almost identical code for my up and down arrows (I had to add a check for last record). I need to do exactly what your code does except...

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

You are brilliant mssql thank you again. It worked like a charm.

I tried it and unfortunately the results did not match the needed results as shown above. The second query2 returned: ItemNo. countofItemNo 2 -------------2

Thank you for the advice I will give it a try!

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

Thank you very much for the reply. I really appreciate you pasting the code you used as I am sure that will help me out a lot. I will give it a try.

I am having the same problem. Were you able to solve this and if so how did you do it. There must be an easier way other than using the code linked to above. Thank you, RFig