query about opening a database with security options

[sachinvh]

when a user opens a database he should be able to go to forms directly and he can edit info in the form but when he closes a form he should not be able to see the tables and other design of database.so how to do this?

 

[Robert Dunstan]

As a quick fix,

Go to the Tools menu and select Startup. Untick display database window and you can also set a default form to be displayed when the db is opened.

HTH
Rob

 

[sachinvh]

Thanks Robert Dunstan. Again one query!

If a field has 2 values separated by a delimiter such that a Blood pressure field has a value like 120/80 and i've to perform calculation by taking one value from the field like 120 and another value from other different field then how to do this in access?

 

[Robert Dunstan]

Hi,

I'm afarid I can't help you much on this one

By the sounds of it, I'm assuming that the blood pressure field is a text datatype? Maybe you might want to consider splitting this data into two number type fields. In the tables this would look meaningless but you could concatenate these 2 values into 1 text box on your form. Then you would be in easier position to perform your calculations.

Someone else might have a better suggestion.

Rob