Recent content by mloucel

Clever and very interesting, I'm gonna dig in, in the meantime your suggestion works fine, with the Conditional. Thank you Sir.

Yep I was able to do it with Conditional, thou I am curious with the On Paint event, I want to try. Question, on the On Paint Event then the If Then Scenario will work or dio you suggest something else?

Hello Gurus... I have the following form: My boss has asked me to do the following: Create 4 boxes Stat / Approval Date / Appointment Date / Notify Date I did each one as a text box, thinking I could have done something like this on the On Load Event: If Stat then StatColor.BackColor =...

By the way this was the solution: in the ApprovedDate column under Criteria: (ReferDate >= Date() - 21 And ApprovedDate Is Not Null) Or ReferDate < Date() - 21 I decided to expand the criteria to 21 days. Thank you ALL.

Thanks but @arnelgp gave me the path to the solution, check #11, I was making things more complicated, and the solution was there all the time, I really don't need to care for the first 15 days, those have to be just the way they are, I only need to concentrate in any data form day 16 to 90...

Bingo... You gave me the solution, not exactly like that, but you gave me the path. I don't have to account for the very first 15 days, WHO CARES, those are already there in my 90 day query, exactly as I want them, I just need to account for the last days 16-90 those are the ones that will have...

Hello Gurus. I have a very interesting problem on a query I can't solve. For time purposes, and to make it easy, I'll use 4 fields as Example: InitialDate FN LN ApprovedD Now this query already displays the first 90 days of InitialDate. The Issue: I need: based on those 90 days, limit more...

Sorry I want to find out if anyone else has the same error I got running in Access 365 64 bit?

This has saved me a lot of headaches, thanks a lot, makes the understanding on how this D functions work, so much easy.

Just what I needed Thanks @arnelgp

You make me feel I am not alone in this world. A splash form... Incredible, like Popeye said.. Well blow me down!!! Tried removing the dialog argument, didn't go well, so is back again, hey.. "IF IT'S WORKING DON'T FIX IT" ;):):):):) I even found another glitch with 2 errors 2501 and another...

@isladogs I did not have to go that deep Colin, I see the changes you made literally GENIUS Simple yet work like a charm, At the MENU level at click: Me.Visible = False then when opening the report: DoCmd.OpenReport "AuthByUserR", acViewReport, , , acDialog then at the Report level, On...

I'm going to check your version against mine here, for the love of my mother I cannot figure out, BEFORE your post I did change the code at the Menu level MsgBox "Opening the Access Window" SetAccessWindow (SW_SHOW) MsgBox "Open the Report" DoCmd.OpenReport...

Yes Colin I have all forms and report as well as pop-up, I just followed what @theDBguy found and is working, but for the life of my body I can't figure out how to fix it. IF you happen to have a minute or 2 maybe you can, in the meantime I will just hide some essentials nav pane/ribbon I...

Krap... I can see clearly now... the rain is gone.... I went back to the post where @isladogs talks about it, and you are right Colin's 2 Cents So to be honest the idea of having a clean version to work is simply amazing and I love it, but creates a struggle at print time, since the printing...