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?
query about opening a database with security options
- Thread starter sachinvh
- Start date
Robert Dunstan
Mr Data
- Local time
- Today, 00:14
- Joined
- Jun 22, 2000
- Messages
- 291
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
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
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?
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
Mr Data
- Local time
- Today, 00:14
- Joined
- Jun 22, 2000
- Messages
- 291
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
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
Similar threads
