Re: How to Find the Date of Last Change in Inventory

Matt,

I think the best solution for you is to find someone local who can look over
your shoulder and give you a hand. I really believe this one is too complex
to work out via these posts. If I had your database in front of me, I could
certainly solve this problem, but please understand I am like a blind NASCAR
driver trying to make it around the track with instructions through a radio.

You information has been complete and clear, it is just the complexity of
the situations.

Maybe at this point, your VBA is limited, but none of us were born knowing
it. This may be a good opportunity for you to enjoy a learning experience.

Best of Luck to you.

"doyle60@xxxxxxx" wrote:

> I should explain that I put the code on the double click event of a
> command button and when I double click it, it gives me the compile
> error, variable not defined, on the line:
>
> rst.MoveLast
>
> That is to say, I do not get the compile error when viewing the code
> and pressing the compile button.
>
> I should tell you that the only VBA code I know how to write is your
> basic If--Else Statements to make things visible or not, draw lines,
> etc. I also do ones that requery, and fill in data given certain
> criteria. But some are a bit more compicated than that. At times, I
> can tweek complicated code I don't fully understand. But other than
> that, I'm at your mercy on this one. I have no idea how to complete
> this code or implement it.
>
> I hope we can get it into some table.
>
> Thanks,
>
> Matt
>
>
.