Ribbon before AutoExec (1 Viewer)
- Thread starter smig
- Start date
isladogs
MVP / VIP
- Local time
- Today, 04:37
- Joined
- Jan 14, 2017
- Messages
- 18,218
2. Set the startup form in Access options!
Why do I need to load an image ?
I tried to put this, but it's not working
Code:
loadImage = "fnAutoExec">
Last edited:
isladogs
MVP / VIP
- Local time
- Today, 04:37
- Joined
- Jan 14, 2017
- Messages
- 18,218
Not working for me
will not load the ribbon if there is a MsgBox in code
I sense we're going round in circles....see post #15
Anything involving user interaction such as a message box will prevent the code completing
EDIT:
In addition, arnel seems to be suggesting a totally different approach.
Don't try & do both in the same app
Last edited:
isladogs
MVP / VIP
- Local time
- Today, 04:37
- Joined
- Jan 14, 2017
- Messages
- 18,218
Attached is a quick and simple example using your ribbon and the approach I suggested way back in post #15. I assume you didn't actually try that method!
I've used a new startup form frmStart with a timer event that triggers a message after 1 second.
I've renamed your autoexec macro to disable it.
I recommend you either run all your checks from the startup form or use an autoexec just for code which doesn't require user interaction. If you do decide to use autoexec, a submacro isn't necessary
The attached works. The modified ribbon appears before the form loads then the message shortly after. It can be improved further but hopefully you get the point
I've used a new startup form frmStart with a timer event that triggers a message after 1 second.
I've renamed your autoexec macro to disable it.
I recommend you either run all your checks from the startup form or use an autoexec just for code which doesn't require user interaction. If you do decide to use autoexec, a submacro isn't necessary
The attached works. The modified ribbon appears before the form loads then the message shortly after. It can be improved further but hopefully you get the point
Last edited:
I did try your suggestion.
Now I see you put the code into the Form_Timer() event and not into the OnLoad() event
This seems to work very well
Thanks a lot
isladogs
MVP / VIP
- Local time
- Today, 04:37
- Joined
- Jan 14, 2017
- Messages
- 18,218
I did try your suggestion.
Now I see you put the code into the Form_Timer() event and not into the OnLoad() event
This seems to work very well
Thanks a lot
Hooray. Glad you now see what I meant.
I've used that method for years and knew it worked.
I think you may have been getting too many different bits of advice at once
isladogs
MVP / VIP
- Local time
- Today, 04:37
- Joined
- Jan 14, 2017
- Messages
- 18,218
Without the BE file it doesn't load properly....
To me it does seem a bit like using a sledgehammer to crack a nut
I saw it load the FrontPage form and the Ribbon from the App Access' options
Where is the StartUp/AutoExec routines ?
Without the BE file it doesn't load properly....
To me it does seem a bit like using a sledgehammer to crack a nut
Is there any way to hide or minimize the form?
I tried using me.visible = false in the OnLoad and in the OnOpen event with no luck
isladogs
MVP / VIP
- Local time
- Today, 04:37
- Joined
- Jan 14, 2017
- Messages
- 18,218
Smig
You've quoted me but I was referring to arnel's uploaded file.
Which of us is this addressed to?
In case you meant my version, attached is a modified version where the start form is hidden.
You do this by opening the form hidden from an autoexec macro. Also remove it as the startup form in Access options.
Obviously you would need to add code to that form to then open the main form / login form when all your code checks have run
You've quoted me but I was referring to arnel's uploaded file.
Which of us is this addressed to?
In case you meant my version, attached is a modified version where the start form is hidden.
You do this by opening the form hidden from an autoexec macro. Also remove it as the startup form in Access options.
Obviously you would need to add code to that form to then open the main form / login form when all your code checks have run
Last edited:
Ooops, Sorry, it was addressed to you
Is there any way to hide or minimize the StartUp form?
I tried using me.visible = false both in the OnLoad and in the OnOpen event with no luck
What does it mean ?
