Hiding access 2007

[NigelShaw]

Hi,

just one post would suffice

my program will let you create a splash screen when your program starts and nothing more.

my program has a form that opens without the db window which is the example i was trying to get across to you.

my program will NOT make your form ( whichever it is ) appear without the db window unless the form you are talking about is going to be a splash screen.

if you require your whole program to be without the db window, then you need to use separate code for that and be very careful with what you do with it.

it does seem you are not that experienced in VBA which is ok as this is what the forum is about however, the advice however it is given should be considered even if it not what you wanted to hear. remember, a lot of people here are very experienced and probably found out the hard way of how not to do things......

if you are trying to create a splash screen after all, you can find relevant links on my site if you so wish.


Nidge

 

[thebigman]

Ok then
I was using a slow coumputer at work hence the three posts.

Its just that the form in my database is quite big and with access round it it fills the whole screen. If access could be minimised it would be better and the form left.
Thanks anyway.

 

[dbDamo]

The code I gave you should work. Start a new thread posting your Database and providing the link and ask someone who is running full Access 2007 to add it for you. It will only take a few mins so I'm sure someone will help.

 

[thebigman]

Ok thanks will give it a go.

PS
Whats File Maker like
Think i just swore.

 

[NigelShaw]

Ok thanks will give it a go.

PS
Whats File Maker like
Think i just swore.

Hi

i dont like FileMaker. i think its for those Mac converts who now use windows and VB is a bit strong for them

my wife is a mac user and once had a problem. while out, i went into a shop and was greeted by this "expert" who asked how he could help. i said-
" my wife has one of these pc's and it has this problem"

he said " which pc?"

i said " this one"

he said " which one?"

i walked over to it, put my hand on it and said " THIS ONE!"

he said " thats not a pc............ its a mac!"

this has no relevance to your problem, just highlights the limited brain capacity of the average mac user hence the reason for FileMaker ( in my humble opinion of course )


Nidge

 

[thebigman]

I am stuck in the middle. Got roaped into doing a site for the pre-school that my son goes too by my wife and oh yes i can get a database done for you no problem and hey presto here i am.

Its just that i know they havent used office before just open office and they would start poking around.

Ah well. Thats life.

 

[NigelShaw]

So why the need to suppress the db window? you can reduce the options available without the headache of add code. when making the accde, you can turn off most of the office button options to give them only an exit button and turn of the navigation window pane too along with locking out other options all found in the Current Database section of Access options.

to prevent tabs, set the form setting to overlapping windows instead of tabbed documents. you an untick the display document tabs

disable design view

choose a startup form

i think the suppression is a bit much unless specifically required.


Nidge

 

[thebigman]

Oh
Never new all that where can you set all that up then.
Sorry for the hastle.
Thanks

 

[NigelShaw]

OK

1. open database
2. press the big round office button ( top left )
3. click "Access Options" ( bottom right )
4. select "Current Database"
Here are all options for the currently opened database

select, turn on / off as required

nigel

 

[thebigman]

OK
That looks a lot better thanks.