Recent content by mloucel

Thanks Colin @isladogs The use of tempvars in this version is simply GENIOUS, I had no Idea you could do that also all the additions in V3 are so simple [When you know], but I didn't know they existed, I am learning so much. That simple line of code is really good for me as a newbie to see what...

Incredible .. I have questions since I am still learning, but I believe is time for me to dig deeper on your code and go back to your CAI page. I really hope someone else can use your code as well, it is really good specially in my report situation. Appreciate your mentorship Colin. Have a...

No I am sorry for my stupid explanation. Yes they do sort and filter and based on those filters/sorts, the report is generated, so when I tried the report option it doesn't work because the whole Table is dumped into the report, and it doesn't matter if I use the code on Open Report, it only...

@isladogs I tested the following: Once I changed the report to acViewReport , all hell is loose, the report does not print only the data I previously sorted/filtered using ReportFormForAuthorizationsF, and no matter what I lose control, I remove the Remarks of the code at the Open Report...

Colin I am simply blown away.. Every time I learn something new, and you simply are a great teacher. About the issues: -Yes, I am sorry I am still confusing the words and keep saying module instead of function, point noted and taken. -Thanks for the warning, I am trying to be more careful, but...

Thanks @The_Doc_Man . I Did the C&R, file remained at 60MB [The Original FE with all the bells and whistles], The backend it did went down, but it was expected, is not really a big deal, since I am going to compile anyway, it was just mere curiosity. I just create a brand new DB then I Import...

Thanks mate but @xavier.batlle fixed it, it was missing 1 instruction at the Open Report level, but thanks.

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