Remove the box surrounding form

[GraemeG]

hello,

Please find attached.

This is a splashscreen which runs for 5 seconds before it opens the main navigation form within the main database.
Is there any way to get rid of the "windows box which surrounds it so it just looks like an image floating?

Any help much appreciated.

EDIT: p.s However I dont want access to completely dissappear, I think

 

[KingSassa]

Change your Border Style to 'None'

 

[GraemeG]

Change your Border Style to 'None'

Thanks. Super.

Another question - made new thread!

 

[KingSassa]

Sorry, not in Access. (Unless you want to do some very hefty windows subclassing, but I wouldn't recommend it.)

 

[missinglinq]

I agree with KingSassa. When I first started working in Access I attempted to do this, using a number of very, very code heavy hacks that were out on the web. They worked, sort of, but in my experience that were not reliable, had a number of drawbacks, such as all forms having to be popup, and not infrequently ended up crashing Access.

What I do now, if I need this effect, is to have an initial, borderless form that opens on opening of the app, and use it as a background for all forms. In Design View I manually size it to cover the entire screen, menus and all.

The other way to do this is to use something like a straight Visual Basic or C++ front end with Access as the back end. But if you're going to do this you'd better of not using Access at all, but rather using something like SQL Server or Oracle as a back end.

• You can create an EXE file which gives total protection to your code/design.
  
• You can distribute the db to PCs without a copy of Access being on board.
  
• Your data security is far, far better than anything you can do in Access.

Just my opinion, of course.

Linq ;0)>

 

[GraemeG]

Thanks for all your advice.

I am newbie and not sure I fully understand all this. So think I will leave it.

Ta all

 

[boblarson]

Sorry, not in Access. (Unless you want to do some very hefty windows subclassing, but I wouldn't recommend it.)

That's not true. All you have to do is to create an autoexec macro which uses this action

Action: RunCommand
Argument: AppMinimize

And then have it open your splash form. You need it to be set to POPUP.

And you have to, in the form's OPEN event put Me.SetFocus.

And you can use it like that but it gets to be a hassle with how and when you have to display the database window (like when running reports). I, personally gave up on that a long time ago because it wasn't worth the extra time.

 

[vbaInet]

Bob, we never got to see the question that prompted that response. Obviously it was editted by the OP.

 

[GraemeG]

Sorry the second question which I edited was can you make a form background colour transparent. Thanks anyhow

 

[vbaInet]

I think that was for a different question. The code Bob gave isn't to do with transparency.

I was just wondering what the question was anyway, it doesn't matter.

 

[missinglinq]

...And you have to, in the form's OPEN event put Me.SetFocus.

Interesting, Bob! Been playing with it and wonder why does the Me.SetFocus need to be used? Seems to work without it.

Linq ;0)>

 

[boblarson]

why does the Me.SetFocus need to be used? Seems to work without it.

It didn't work for me (Windows XP, Access 2003) when I didn't use it. It would open fine but it would not show it until I clicked on the Access app. Did you have more than just that application open? What OS are you using? I had a bunch of different apps open when I did this and the only way it would show without me clicking on the app was to include the Me.SetFocus.

 

[missinglinq]

I'm running 2003 under (sadly) Vista. Hadn't tried it with any other apps running, but having just done so, I find that

• It consistently acts as desired, with other app(s) open and minimized
• With other app(s) open but not minimized it sometimes acts correctly but sometimes doesn't

The hacks I mentioned in my original post as having tried had the same problem of not consistently working.

All in all, way more problem than it's probably worth, other than simply as an experimental exercise of the mind!

Linq ;0)>

 

[smig]

set your form's border to none as suggested by KingSassa.
still it will be a rectangle
as for transparency - no. not possible.
you can mimic a transparency by setting the form's background color to the same as the screen. but this will only work on clear dasktop with no bacground image. not worth it I think.