More help needed

[accessdummy]

In conjunction with the earlier post,
http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=214253#post214253

I will like to make some clarification. Perhaps, I have misword-ed my problem and would genuinely like to rephrase my problem again.

I have 5 options in an option group, with the accompaniment of 5 textbox-es.

Each time I select an option, I will enable a disabled accompanying textbox.

This problem has been solved.

For each accompanying textbox, I have a field in the table to collect the data. The default value for each textbox is set to "NIL" so which means to say, no matter what, there will be data in the field(s) in the table.

Next problem is if user select the first option and key in some values in the accompanying enabled textbox and he/she changes his/her mind which he/she selects the second option and key in some values in the accompanying enabled textbox.

Now, if user 'saves' the form, logically, the form will capture two entered datas from the two enabled textbox. This SHOULD NOT be the case. I only want the data (which the user selected the option and enable the accompanying data) to be captured into the table while the rest to be remained as "NIL"

The code which was given to me does not solve that problem.
Can someone help me?

Thanks.
++++++++++

Next issue is about access level. I have created a 'content page' with 6 buttons for the database and I intend to have 3 level of security.

The 6 buttons are mainly add record for incoming mail, add record for outgoing mail, search form, preview report, *add appointments, *add file references. * denotes the second level of security

The lowest level is only allow to add records of incoming/outoing mail, search and print/preview report.

The second level have all 6 buttons functions.

The highest level can edit the internal schema of the database.

Question 1: can I use MS Access 97 built in security functions? If yes, how?

Or should I create a login form and disable/enable the buttons according to the access level granted? For example, if I enter the password for the lowest security level, I can only use 4 functions out of 6 and if I enter the password for the second security level, I can use all 6 functions etc...

Thanks.

+++++++++++

Lastly, how to use the concatenate function? I'm trying to create a unique ID (with alphabets and numbers with running series number). Any suggestions about doing that?

E.g: ABCDE-0308-001 whereby ABCDE is the company initals, 03 is the year and 08 is the month and 001 is the running series. I need the year because I will have to generate an annual cum monthly report based on that.

Is there a better and safer algorithm which can allow me to achieve the same thing?

 

[Mile-O]

If you have five fields in your table where one can have data then your data is not normalised.

You can easily get round this by having two fields: one which stores the value of the option group and one which stores the value of the textbox with a value entered.

Have a hidden textbox bound to the field and the other five textboxes can be unbound. On the form's BeforeUpdate event you would find which textbox has a value in it an copy that to the hidden textbox.

 

[Mile-O]

On disabling your textboxes in your option group, remember to set them to NULL to avoid the wrong value finding its way into your table.

 

[Mile-O]

You PM'd me asking me to clarify further what I meant but I don't see why you just couldn't have asked on this thread.

The enclosed example demonstrates.