Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-10-2018, 12:24 PM   #1
Hiba87
Newly Registered User
 
Join Date: Oct 2016
Posts: 12
Thanks: 2
Thanked 0 Times in 0 Posts
Hiba87 is on a distinguished road
Please help!

How could I hide the Access splash screen, so the database appears as finalized/executable?

Thanks in advance

Hiba87 is offline   Reply With Quote
Old 11-10-2018, 01:13 PM   #2
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 554
Thanks: 24
Thanked 5 Times in 5 Posts
MickJav is on a distinguished road
Re: Please help!

Think you have to create a stand alone product package but never done that myself
__________________
After 20 years working with access i have no more hair to give.
MickJav is offline   Reply With Quote
Old 11-10-2018, 01:25 PM   #3
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,980
Thanks: 92
Thanked 1,715 Times in 1,592 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Re: Please help!

Actually it's surprisingly easy to remove the Access splash screen.
Create a .bmp file with the same name as your database file and save it in the same folder.
The bmp file doesn't need to contain a picture - it can be an empty file.
Run your app as usual and the Access splash screen doesn't appear.

To compile your Access file so the code isn't available to end users, it must be saved as an ACCDE file.
This is sometimes wrongly referred to as an Access executable.
However, there is no such thing as a standalone Access app.
You can choose to hide the navigation pane, ribbon and the application window if you wish but Access will still be running in the background

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
The Following 2 Users Say Thank You to isladogs For This Useful Post:
Gasman (11-10-2018), MickJav (11-11-2018)
Old 11-10-2018, 09:44 PM   #4
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 12,472
Thanks: 62
Thanked 1,175 Times in 1,075 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Please help!

Colin is right. Creating a .BMP file allows you to build your own customized splash screen. I built a "corporate" logo to replace the Access splash and that worked really well.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 11-11-2018, 01:09 AM   #5
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 554
Thanks: 24
Thanked 5 Times in 5 Posts
MickJav is on a distinguished road
Re: Please help!

Quote:
Originally Posted by The_Doc_Man View Post
Colin is right. Creating a .BMP file allows you to build your own customized splash screen. I built a "corporate" logo to replace the Access splash and that worked really well.

Thats the best thing I've learnt since joining just got a new task to do lol thanks colin/doc_man
__________________
After 20 years working with access i have no more hair to give.
MickJav is offline   Reply With Quote
Old 11-11-2018, 01:31 AM   #6
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 554
Thanks: 24
Thanked 5 Times in 5 Posts
MickJav is on a distinguished road
Re: Please help!

I use office 365 and sorry to say didn't work addached pic just so you can see where I may have messed up
Attached Images
File Type: png 2018-11-11.png (7.8 KB, 10 views)
__________________
After 20 years working with access i have no more hair to give.
MickJav is offline   Reply With Quote
Old 11-11-2018, 01:45 AM   #7
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,980
Thanks: 92
Thanked 1,715 Times in 1,592 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Re: Please help!

The BMP file can indeed be used as a splash form in its own right as Doc suggests. If it's empty (or a 1x1 pixel image), it won't be seen so it just suppresses the Access splash screen and goes straight to the app itself.

I generally use the latter method, sometimes with a 'dynamic' splash form in the app itself. For example, see my Currency Exchange Rate Tracker

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 11-11-2018, 02:04 AM   #8
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 554
Thanks: 24
Thanked 5 Times in 5 Posts
MickJav is on a distinguished road
Re: Please help!

for some reason it's not working for me even with a aacdb
__________________
After 20 years working with access i have no more hair to give.
MickJav is offline   Reply With Quote
Old 11-11-2018, 03:57 AM   #9
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,980
Thanks: 92
Thanked 1,715 Times in 1,592 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
Re: Please help!

With modern processors the bmp file may open & close very fast.
Now that's fine if you use an empty BMP file as I do as it means the app opens directly with no splash screen

If however you use a 'real BMP image' as a splash form it may not stay open long enough to do what you expect.

BTW - my currency tracker doesn't include a BMP file after all - my mistake

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 08:07 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World