Home > IT, Solved problems > Cool modern DialogBox for MS Access / VBA applications.

Cool modern DialogBox for MS Access / VBA applications.


Hello there, again it’s about VBA and dll Smile

 

This idea just popped out after someone asked a question regarding my previous non-blocking notification. This time why not use a blocking notification?. Or do we say a dialog box?

So what’s special? Well, standard message boxes are great but sometimes you want little more than “just plain” standard. I.e

  • Be able to have some colours
  • Be able to have more than 3 buttons “i guess i always wanted this”
  • Be able auto-close
  • Be able to use HTML tags
  • not stressing your vba app with a loop?

Meet the new simplified DialogBox for VBA users. This dialogbox will allow above listed features and should help you to keep your application colourful. 🙂 This feature is still under development and could some feedback from testers.

check out my Github for samples. There is a sample ACCDB file with some custom class and a vba wrapper around the DLL.  Let me know what you think.

some screenshots

4Buttons

Modern DialogBox Red

DialogboxGreen

Modern DialogBox Green

Download the free dll from my GitHub page. A beautiful dialogbox can be created with simple as this code.

'usign the wrapper it would be as simple as 
  Debug.Print gDll.DialogRich("This is a title", "Some content", (vbExclamation + vbYesNo))
Advertisements
  1. July 27, 2018 at 10:29 am

    Hello Krish and thanks for providing such great utility. I tried to adopt this dialog box in a small Access file and it works well.

    I noticed however that there is no option to change the colour theme for both gDll.ShowDialog(Me.Text2.value, “confirm”) and gDll.AreYouSure. Is it something that can be done? Also is there any plan for a Message Box too?

    Thanks again for doing a very beautiful job and a great VBA utility.

    Liked by 1 person

    • July 27, 2018 at 3:54 pm

      What you mean by MessageBox? Yes, you can now theme format “are you sure” and “simple dialogbox” checkout the latest dll_test.accdb for the changes.

      Liked by 1 person

      • July 27, 2018 at 4:12 pm

        Thank you for your response Krish and for the updates. I will check it out and revert.

        You know GetDll.ShowDialog will pop up a dialog box for a YES and NO option. But there should be a way for a regular MessageBox
        as well that should only give an OK option (ie, the regular vbOK button) instead of both YES and NO option. I hope I am able to explain my request?

        Thank you again.

        Like

  2. August 10, 2018 at 6:23 pm

    A second look at the code again shows that this is actually available on what you already have.

    Like

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: