Recent content by tvanstiphout

Do you also use /decompile? I would definitely do that if minimum size is your goal. I would assume the compiled state in 64-bit is a bit larger (maybe 20% or so) than the 32-bit one.

I hope you'll clue us in with a screenshot.

@eric: in your Frameworks article you write: "A form wrapper created in Form_Open() cannot sink that event because it already will have occurred. The form wrapper’s Class_Initialize() can be a viable proxy, however." True, and yours is a fine implementation (although you're not showing it in...

@eric: in your Frameworks article I see a tradeoff: you make owecFrm Public, so you can later destroy it. I'm sure you entertained the thought that it should really be a Private variable. What are the pros and cons you see? I am keeping mine Private, but that requires me (or my code generator)...

@eric: As a side show, I've learned that the Implements keyword only implements an interface for methods and properties, NOT for events. Sometimes a class object may want to inform its "subscribers" that some custom event has happened. Along the same way as "observable collections" in C#. Have...

> clipboard i guess That is one way, but another elegant way is to use COM Automation with Outlook. Note that ONLY works with what's now called Classic Outlook, not with New Outlook (which does not support COM Automation at all). If you want to go down this road, I would use these search terms...

It is a best practice to close applications when you're not using them anymore. You can even write code to do this automatically for you after a certain amount of idle time.

His framework has very little if anything to do with "data-driven applications".

If you are on a Domain network, this blog post of mine may be of interest to you.

Look at the comments at the top of the module. It is a "default instance" class that gets initialized by Access/VBA at startup time. This is also why we don't "New" it, and call its methods using "clsErrorHandler".

> I have Office 2016 and cannot also install Visio 2016 without uninstalling Office The typical workaround is to install a VM on your computer, and run the other software in it. Hyper-V comes with Windows, but you have to install it using Control Panel > Programs and Features > Turn Windows...

I am a user of your MCP, and I am impressed with it, and your quick response if I find a bug. Great to see you here!

> Why the CInt function should return a different value from the Int function I've no idea But the documentation does. Check it out. https://learn.microsoft.com/en-us/office/vba/language/concepts/getting-started/type-conversion-functions...

I set a breakpoint on the last line, and then ran Roundup(1.87, 2) Using the Immediate window (Ctrl+G) I test the intermediate calculations: ?Num, Decimals, Factor 1.87 2 100 ?-Num * Factor -187 ?-Int(-Num * Factor) 188 That should give you enough information to debug and...

Remember that Access is created by Microsoft, a US company. So you must use the US date format (or ISO) when using literal dates. But in your case you can use the DateAdd function to add 1 day or 7 days to today. Something like: select * from myTable where ApptStart > DateAdd('d', 1, Date())