2 Remaining Issues (maybe 3)

[gary.newport]

I am finishing the last steps to a system and have I have two issues with this:

1. The splash screen has the rounded edge at the top that 2007 gives to forms when border style is set to None. Is there any way of either rounding the bottom of a form or squaring off the top?
2. I have switched off most menus but there is still the clipboard, font, etc menu. How can I disable this and restrict the system to only the forms, etc I have created?

I do have a third issue but a minor one. I have a label on the splash screen and a table with a single field and, in fact, a single record (this is essential for an update system I have installed). I would like the label to show the data in that single field but cannot think of the command needed to do so.

Thanks for any help given.

 

[vbaInet]

1. The splash screen has the rounded edge at the top that 2007 gives to forms when border style is set to None. Is there any way of either rounding the bottom of a form or squaring off the top?

Not sure if it gives rounded edges, hmm..., but if it does you could use a box control and expand it to the full area of the form, set the border thickness by 2 or something.

2. I have switched off most menus but there is still the clipboard, font, etc menu. How can I disable this and restrict the system to only the forms, etc I have created?

You wouldn't normally hide menus in Access 2007, you hide controls, groups or tabs. You are referring to the Ribbon aren't you?

I do have a third issue but a minor one. I have a label on the splash screen and a table with a single field and, in fact, a single record (this is essential for an update system I have installed). I would like the label to show the data in that single field but cannot think of the command needed to do so.

DLookup() function would do. Look it up.

 

[gary.newport]

Not sure if it gives rounded edges, hmm..., but if it does you could use a box control and expand it to the full area of the form, set the border thickness by 2 or something.

No, my eyes are going wonky. Of course it is rounding the top!

The box suggestion works aside from the top left corner but actually gives a nice look so I am staying with that one.

You wouldn't normally hide menus in Access 2007, you hide controls, groups or tabs. You are referring to the Ribbon aren't you?

Yes, I mean the ribbon. Sorry if the wording was incorrect. Now it is corrected; any ideas?

DLookup() function would do. Look it up.

I vill do, mein fuhrer!

 

[vbaInet]

No, my eyes are going wonky...

I understand gary, you should have gone to specsavers lol

Yes, I mean the ribbon. Sorry if the wording was incorrect. Now it is corrected; any ideas?

So this would depend on if you want to remove the ribbon completely? Customising the ribbon is another different kettle of fish, it's nothing like pre 2007 versions.

I vill do, mein fuhrer!

You better

 

[gary.newport]

So this would depend on if you want to remove the ribbon completely? Customising the ribbon is another different kettle of fish, it's nothing like pre 2007 versions.

Yes, I want to remove the whole ribbon. I want to reduce the options to the forms, etc that I have created when the system is opened normally.

 

[vbaInet]

Okay, here's a link:

http://msdn.microsoft.com/en-us/library/bb258192.aspx

 

[gary.newport]

Thanks my friend but already sorted with the following:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

 

[vbaInet]

Have you tested that on pop-up forms, reports and dialog forms?

 

[gary.newport]

Yep, I have tested the entire system and it works fine. There are no reports on this particular system but I may well use the same approach for the Admin system so should be able to confirm sometime later on.

 

[vbaInet]

I'm skeptical about that approach with regards ribbons. But if you say it works then great. I would be inclined to also test it on ACCDEs too.

Good luck

 

[gary.newport]

I just checked it as an ACCDE and it all worked fine!

 

[vbaInet]

That's good.