Login Form

Hi guys,

I've seen this login form (picture on the right) that I would like to use, so I searched google for the image and build my login form..... what i get is as per (picture on the left)

What I would like to do is trim the boxed window look and just show the image "picture on the right"

How would we go about doing this? VBA???

Many thanks

.
Paste this code into your Login Form to hide the RED X in the upper right hand corner of the form :

Please Login or Register  to view this content.

The word "Login" shown in the upper left hand corner can be deleted by going to the login form's properties window. Look for CAPTION .... then remove the word LOGIN.

Thanks for your kind help Logit

However the code does not do exactly what I am after.

As you said it takes the x from the top right corner of the window and the word Login I can remove without a problem, but the form still loads with the popup rectangle window look.

What I was hoping to achieve is as per attached picture, as you can see only the image is visible, the popup window seams to be transparent....! see picture

Also attached the excel workbook with the form I am trying to do.

Best
Tony

.
The only thing you are missing on the form at this point are the two labels: "Change Password" & "Help".

Those can be created by inserting a label on the form and editing the caption to match. Then you can right click each label and assign a macro to it.

The is nothing more you can do to the image - the 'squareness' of the form will always show through.

Ok Thanks....!

I don't really want to add "Change password" or "Help"...! Only really want is to remove the squareness!

The image on my post above is a screen print from another VBA project which is PW protected but it def can be done somehow

Thank you for your help anyways

Cheers
Tony

Tony:

Is there a website where you have seen this done ? Please provide the URL.

Thanks

Sent you a PM

@Logit

File attached, had to zip cause of size restrictions

Cheers

.
When you open the attached example, click on Form 1 button. Form 1 will be displayed in the middle.

Then click on Form 2 button and move it to the left of Form 1.

Then click on Form 3 button and move it to the right of Form 1.

Now the three forms are displayed so you can compare them, with and without edits.

The three forms were taken directly from the project you sent me. FORM #1 is the closest you will get to achieving what you see in the project. It was taken directly from the project and not altered at all.

Forms #2 and #3 were edited slightly to demonstrate the differences of editing levels.

Thanks Logit,

Very well explained,

I get Compile error when clicking the buttons, see pic

cheers

.
What version of Windows are you using ?

.
See if this version will run for you :

the new file worked, thank you

btw I am running windows 10, version 1709

Back to the project...! did you see the login form pop up on the file I sent you? only the image is visible no box...! how did they do it

.
I presume there is another API call that would remove the User Form "drop shadow". The thin dark line seen on the right and bottom sides.

I'll continue to search for it.

Thanks a lot Logit, your assistance as been awesome Thank you.

If you do find it, please do post it up


Cheers

Will do.

I tried to locate a means of using only the image as a replacement for the User Form .... no luck.
The image can be inserted into an Image Control but the result is the same .... a little bit of the image control around the edges is viewed as well.

Thanks again Logit,

I am confident you can find the solution

You´re a legend Logit!

Thank you again

Need your assistance again please

Getting compile error!!!! see pic

.
That macro refers to another macro left over from an earlier project.

You should be able to completely remove this entire block of code :

Please Login or Register  to view this content.

Thank you again,

In the mean time I had decided to make that sub inactive just to see and it worked.

many thanks for your kind assistance with this project.

Cheers

.
You are welcome.