Activity Stream

I will try using the Continuous form following your suggestion. Can you suggest the code of close button to close any form open on dashchild form...

That worked for me. Thank you @Matrix

I believe that I've answered this in post #11. I do not use split forms. If you are adamant about using them, then I am unable to offer any more...

Use: Private Sub Form_Current() 'Me.List132.Requery Me.List132.RowSource = "SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter...

Perhaps I can persuade you not to use Access Split Forms with the following YouTube link: https://www.youtube.com/watch?v=UloLIMhatSs Watch it all. ...

Your suggestion is good but I want to proceed as is.

Use: Private Sub Form_Current() 'Me.List132.Requery Me.List132.RowSource = "SELECT GREY_SHADE.OfferID, GREY_SHADE.Shade, GREY_SHADE.Meter...

No, there is no button to restore it. If it's saved, it will be restored automatically.

Don't know why but this method is not working. Would you also please suggest any solution to the two problems I have mentioned above. Thanks in...

I lost a post today (and many times before) in an existing thread. I don't see a button to "Restore Auto-Saved Content" How do we get it to appear?...

As noted, storing files in Access tables is not a good idea. If you did that, then opened the file (e.g. in image editing software) and rotated it,...

actually, this only needs 3 functions >=dateadd("yyyy",-1,date()-day(date-1)) and <(date-day(date)+1) I've also modified to allow for leap...

By "attaching" do you mean Attachment data type field? Open and rotate where? Exactly how are you displaying photo - with Image control? ...

Did you simply set SourceObject property? Parameter in List32 SQL will not work. So it will work when form is standalone or subform, modify to:...

Not sure why you want to do this but you can remove or replace the application title in Access Options . . . Current Database If you remove it...

Yeah, I was wondering about that. I'm going to give your suggestion a try later tonight or tomorrow sometime. Thanks!

I tend to avoid dateserial as it involves more function calls - 6 function calls instead of 4 in this case - plus more typing:)

no worries, I appreciate your input

Sorry, I missed that. I was concentrating on getting the last day of the previous month. :(

Hey Welshgasman, I tested your suggestion with "0" in the last (Day) argument for DateSerial, but the result excluded any of the records that...

Happy to help

Thanks Peter! Your suggestion didn't include the records from last October. However, adding "-1" after the first month parameter produces the...

Thank you..

Thank you. That was very helpful!

If it's working, then yes.

an alternative method >dateadd("yyyy",-1,date()-day(date)) and <=dateadd("d",-day(date),date)

Use DateSerial(Year(Date()),Month(Date()),0) as the last criteria?