Recent content by KitaYama

No offence but it seems that it's you who don't understand. OP is not in the navy and his client is not the most strict organization in the world. So, the reply to his question SHOULD not be navy based, and I think few people care that how navy manage their computers. You have never purchased a...

We purchased an out of box accounting solution a while back. During install process, it installed sql server express, then the main application was installed. Sql server is locked and none of our admins are able to access the database or tables. We can install another instance of server if we...

Simply turned off the auto update option. Is this enough?

I haven't updated since 2304. I really hate the height of title bar in recent updates. It takes too much space for no special reason and I couldn't find a way to change its height. Thanks for reporting this to MS.

I don't have "Sql View" in my context menu from navigation pane, no matter the mentioned option is ticked or not. (Microsoft 365)

I'm at home. Tomorrow I'll try your registry workaround and will report back. thanks.

Found the problem. Seems that when "Allow Full Menu" in options is not ticked, "sql View" doesn't show in the context menu.

When I open one of my Accdb FEs, and open a query in design view, the context menu doesn't show "Sql View". If I shift double click the database, the "Sql View" is back again. I've removed all codes from Autoexec, OnLoad and OnOpen events of the first form that opens, still the moment that...

I love MZ-Tools because it sorts all my variables alphabetically. It makes it much easier to find what I need to check/change. It’s a relief to see them in the right order.

@MajP The not dialoge version works just fine. Simple and very easy to re-use. Seems that I was over-complicated my situation. Million thanks for your help.

I expected a technical reason. It seems that's a matter of personal preference. Will I be faced problems if I use the add-in located in a server, where all FEs can use it? If there's any problem in this, I can save the add-in with FE, then change FE's update procedure to update the add-in for...

Thanks for your solution. I'm at home and don't have Access here. I'll take a look tomorrow morning when I'm back to work. But from your code above, as I explained, I can not use acDialog to open the form. thanks for your time.

That was my first impression, but later it appeared to be not possible. (or at least with my knowledge.) As I said, the form can not be opened as AcDialogue to pause the code. So the function is called, the form opens, and the function runs to the end, and the form stays open. At this step...

Yes, that's the main key to success.

While I understand your concern, but imagine you have an utility that you use in all your applications across the organization. Let's say a Calendar. With every development of this utility, you have to copy the necessary form and modules to all your databases. If you can add it to a lib, you...