Search results

Well BLOW ME DOWN!!!! 🤯🤯 Thanks mate.

DARN YES. it does... I never in my wildest dreams would have think about that. Thanks mate. Also, can you please share with me, how were you able to reduce the size of the file from 15 - 20 mb to barely 2mb ? Now that is awesome, and could help me make my original slimmer, which is already...

Hello gurus: I have been working on a program for my office for the last year, many of you have helped me to accomplish many of the tasks, and I am grateful. The application contains a few reports that are working perfectly fine, except for this one: "ReportForAuthorizationsR" Background: I...

Wow thanks doc, I really appreciate your knowledge, I had no idea, there are a few changes I need to make to my database better, and your tips are making it clear. Thank you so much.

The record source is filtered by the user, they need so many different reports, so I left those fields enabled but locked, so they can sort and filter as needed, once that is done, there is a Print Report Button and on the report I have the following code: Private Sub Report_Open(Cancel As...

After a little while of moving things around, I had to go back to the original code, I just made 1 simple STUPID change. Instead of using On Open Event, I moved the code to On Load event, that's it nothing else, for some weird and strange reason, the sizing works as expected, no matter how is...

Now it displays only 1 record:

Hello, Gurus. I have a very particular form, that I need to set SPECIFICALLY at Width 28440 and Height 11835, so that it fits in ALL my monitors across the board, my problem is that everytime I save the form at 5.5 inches, it keeps the size perfectly as I saved it: But when I made a change and...

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