i used this sample on access 2010 and two mode viewed full screen mod.

main access windows code dosn’t run.

please correct!

]]>By: Stephen Poynterhttp://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/comment-page-1/#comment-13736
Thu, 25 Aug 2011 11:45:45 +0000http://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/#comment-13736Dude your work is amazing!!
I have been working as access developer for just short of three years now and i thought i has learnt everything possible but u have showed me other wise.
I have a question – will the transparent background work in runtime version? i am referring to run time 2007
]]>By: Justinhttp://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/comment-page-1/#comment-13725
Mon, 08 Aug 2011 08:31:36 +0000http://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/#comment-13725Hi, thanks for this great tip,
Have a question regards Form resize event.
Am trying to capture Access Main window resize event,
and move a custom command bar on statusbar.

I have done some work with API, but the event and
coordinates are difficult and get out of screen when
move my frmStatusBar accordingly.

Do You have a suggestion regarding this?!
Regards,
Justin

]]>By: BellsBellshttp://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/comment-page-1/#comment-11791
Thu, 26 Nov 2009 08:28:43 +0000http://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/#comment-11791me again,
sorry accidentally clicked to fast on the cmdbuttom submit..
well the function above is one way and needs to be placed in the “open event” … the code below is a nother way to hide and show the main window…. btw. be aware, that u need to place function to make the main window visible again… otherwise u wont have any main ACC window anymore…. here is another code to realize it …. based on the same API

the tool works fine… one thing is to remark… the obvious mistake mistake(error) of ACC on the command “hide” and “show” window….it will cause that the main window is getting wider then the actual screen…
obviously ACC is extent the screen to double the area and move the hidden MAIN window in this area…
my suggestion is :

a) did you saw lebans code for conditional formmating?
b) i love excel conditional formatting specially with the icons and all that stuff . . ., do you think we can use that in access 2007?

]]>By: Renaudhttp://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/comment-page-1/#comment-8441
Sun, 18 May 2008 11:08:36 +0000http://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/#comment-8441@Phil: I can’t replicate that behaviour on Vista and the main sample database included in this page seems to be working fine for me.
Did you try the sample databases or did you implement it yourself?
Have you found where the issue could come from?
I’d like to know if this is really a bug or something else.
]]>By: Philhttp://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/comment-page-1/#comment-8415
Thu, 15 May 2008 17:33:14 +0000http://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/#comment-8415Both options fade the whole screen on my Vista SP1 machine.

Nice Gentoo logo placement

]]>By: Renaudhttp://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/comment-page-1/#comment-8401
Tue, 13 May 2008 02:00:50 +0000http://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/#comment-8401Hi Edwin. Thanks for the vote of confidence :-)
I’ll look into Stephan Leban’s code and see if there is something to expand on there.
The issue with taking row highlighting and conditional formatting further is that Access doesn’t expose a lot of its internal functionalities. One of the problems is that controls like textboxes are not really normal windows controls (with a few exceptions).
These lightweight controls are rendered internally by Access as images on the form until the focus moves to them.
The OnPaint event is also fairly limited and only exists at the form section level and not the control level.
So extending Access’ behaviour in that regard is probably too hard to be worth the time, especially when you consider that whatever you do may be rendered useless or incompatible by the next version of Access.
Also to consider is that when more features are needed, it is probably better and easier to just include managed components in your forms: with the Form Interop Toolkit you can use .Net controls in Access. It requires some work and it’s not as tightly integrated or as easy as I’d want but it’s possible.
By doing that you could include just about anything in your forms, and you open your application to a world of more interesting controls than the limited ones provided in Access.
I plan to make a series of articles on that subject in the next few weeks.
]]>By: Edwin Blancovitchhttp://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/comment-page-1/#comment-8398
Mon, 12 May 2008 16:20:44 +0000http://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/#comment-8398Thanks for your answer, i was reading the comments on microsoft rss, and i think you are the appropiate guy so i can ask this question.

I used to have code from lebans.com to highlight the current row in datasheet or continuos form, also to highlight the row based on some conditions, (the access embeed conditional format only supports 3)

lebans created a solution for this, but now is outdated, i think you can revise the api’s and create a new solution(maybe give it to microsoft :-) )

The thing is that if you look into excel you have a great conditional formatting options even with icons and all that stuff, but that doesnt exist for excel.

What do you say, can you do it?

]]>By: Renaudhttp://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/comment-page-1/#comment-8378
Thu, 08 May 2008 23:47:09 +0000http://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/#comment-8378@Edwin: I agree that the version with the Class is actually a bit more complex but it’s still quite educational and it nicely encapsulate the functionality. You end-up using only one global property (LightboxForm) to manage all layer functions.
Whether you prefer one version or the other is up to you, that’s why I left both samples.

Regarding the colour formatting of the code, I’m afraid that it just looks that way because I use a code syntax highlighter in my web pages…