Removing all Tool bars on startup.

[johnwiseman]

Hello.

I have a FORM attached to a TABLE with several persons inputting fresh data. Each record has a AUTO NUMBER record.

I wish to restrict the users to only see the record they are entering and not to see any previouly entered records.

I have removed the RECORD SELECTORS but the records can still viewed by rolling the roller on the mouse. They can also be viewed via the tool bars, EDIT - SELECT RECORDS ect. Again I have removed all the tick boxes on the START UP options.

Any advice would be good.

Thanks

John

 

[danvlas]

Set the form as Data Entry?


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Pampers]

You could try:

1. Application.CommandBars("Menu bar").Enabled = False
2. or, Disable them in the startup setting (tools/startup...)

Pampers
Keeping it simple can be complicated

 

[missinglinq]

On the form's properties:

Data Entry YES
Pop Up YES
Modal YES

The form will load with a blank record. While the menu bar will be visible, the user cannot open them up.


The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[johnwiseman]

Hi All.

Your methods work a treat.

Thanks for your assistance