checkboxes with initials instead of yes/no

[biggie747]

I'm fairly new to access. What I've learned, I've done by playing with access. The only formulas I'm used to is with excel, I'm good with excel.

Anyway,
I have a checklist, basically, where I need the checked places to have the persons login initials instead of yes/no. Can this be done. If the answer has to do with the login screen, I need to learn how to do that as well. I will most likely have a few other questions later. Any help would be greatly appreciated.

Just adding as an after thought, I can use a combo box for the initials. I would prefer to have the combo box have their names and when they click on a check box it places their initials in the column instead.

 

[CEH]

To answer your question. No. A checkbox is a checkbox. Either Yes/No... True/False... 0 -1... boolean. Letters would require a textbox.

 

[StuR]

could you not have a check button where if pressed it allows access to an otherwise greyed out listbox from which you can select the initials?

I had a similar thing in mind which so far I've not managed to do

 

[CEH]

Yes. something like...
Private Sub CheckBox_AfterUpdate()
If Me.CheckBox = True Then
Me.FieldName.Enabled = False
Else
Me.FieldName.Enabled = True
End If

End Sub
You will also need to set the onCurrent event of the form.
If Me.CheckBox = True Then
Me.FieldName.Enabled = False
Else
Me.FieldName.Enabled = True
End If

 

[The_Doc_Man]

Let's get down to business here.

Biggie, you can have any kind of control you want. BUT... the kind of control governs what can be in it.

A checkbox usually corresponds to a Yes/No field in the record bound to the form.

A list of possible initials sounds like a combo box or list box. The data for the drop-down can come from an external table. The combo box and list box wizards can correctly handle setting these up for you.

A place where someone can just enter their initials is a text box.

So when you want something just remember that Access can probably do it - but not as an object with combined properties. You will probably need some combination of the above to reach your goal.

 

[biggie747]

I see. Well I'll do my best to work around it. Thank you for your help everyone

 

[WayneRyan]

Biggie,

Assume that you've somehow retrieved the user's initials from a login
form. They reside in --> Forms![frmLogin]![UserInitials]

Assume you have a column in your table --> QaCompleted, text 3 characters

On your form, put a textbox --> txtQaCompleted

Set its Locked property to Yes. You don't want anyone typing in it.

In its OnClick event, put:

If Len(Me.txtQaCompleted) = 0 Then
   Me.txtQaCompleted = Forms![frmLogin]![UserInitials]   <-- If empty, "check" it
Else
   Me.txtQaCompleted = ""                                <-- If not empty, "uncheck" it
End If

You can even use Conditional Formatting to alter its appearance
when "checked". (Length > 0)

Then in queries, a Null value or empty string means it hasn't had
QA completed. A non-empty value, means it was completed by the
person identified by the initials.

Now, all you need is a login form ...

hth,
Wayne