Search results

Hello All: I have a DB that has 2 different sides [now]. - 2 different Offices that must have their own data. - The BE is 100% similar to each other except for the data contained. - The FE is Exactly the same for Both, except for the BE FE for A or B are exactly the SAME except for the name...

" If so, its both a standard message and normally nothing you need to worry about. " Yes you hit the right spot, Thanks Colin, makes me feel better, I was a bit worried, but so far nobody has complained, so yes you are 100% right. Again Thank you so much.

Thank you so much @theDBguy and @isladogs You have opened my eyes, and yes Colin it worked perfectly. Thou now I have two more questions, 1 of them: I got a message saying something like" "Sharing won't work" or something like that, sorry I did not write the original message, but I am sure you...

Yes to both I am very careful

I'm going to do that with my test DB in my office friday after everyone is gone. [of course make backups of everything 3 times to avoid errors] Question: If I do all those changes, and password the BE and all the steps, [using my test DB], I should be able to simply go to the real one in my...

Thanks I am worried about the other half of the DB, the FE, that's where I was hoping the code will help me open the tables so my FE can work with them, I am sorry if it sounds incredible, but I have never done anything like it, I have no idea how it works to put a password on the BE and then be...

Hi Colin, During the weekend 1 of the workers somehow got to the BE folder in the server, and was able to double click the BE and open the files, She panic and called me, so it was fine, that got me thinking how can I put a password on my BE and be able to open the tables, but only while the FE...

Thanks, for the tip, but I believe his approach is way more that what I intend to do, mine is very simple password the BE and opening the BE using VBA.

Hello All: I decided to add a password to my database to avoid people getting their hands in my tables, I ask Google AI and Grok how to create code to open the database with that password and gave me this: GROK: Sub OpenProtectedDatabase() Dim appAccess As New Access.Application...

I'm grateful with your help. I have no idea that reports do their own thing, that's very new to me. Also I went to see your example as you told me, the way you handle the sort is simply really good, I am planning to make some strategic changes to the form (where the report is created) and apply...

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