Search results

Try something like .... In the OnCurrent event of the form use ... Me.txtControlName.Locked = True In the AfterUpdate event of the combo box use ... If Me.cboComboName.Column(x) = "TDY" Then MsgBox .... Me.txtControlName.Locked = False Me.txtControlName.SetFocus End If In...

Understood on the stripped down portions. Which form are trying to embed the subform to? -dK

So you click the combo box ... then a message pops up, right? -dK

Here is a sample I just worked up for another user. As in Bob's post, I was helping the poster to hide subform from the user - but the implementation of the subform makes life much easier. Although I should note to not this type of structure because of the type of implementation is specific...

In the AfterUpdate event of the combo box you can use: Me.txtTDYstart.SetFocus. In the AfterUpdate event of this control you can use something like: If Me.txtTDYstart.Value < Date() Then ....... HTH, -dK

Search the Help in your code editor for 'GroupLevel'. That should lead you to the property 'SortOrder'. HTH, -dK

Is something like the attached what you are trying to do? -dK

Oops .. deleted my post. Is this assuming "AuditSummary" is another table or a value in a form control? -dK

Okay .. the second part of this is how you display the combo box. One aspect that makes combo boxes so great for data integrity is that even though you bound column n, you can have it display column m. Look one tab over (Format) in the combo box properties. There will be a property called...

Hahaha ... aye it is! Epsilon was stuck in my head from strain tolerance ... or was that Freudian slip? Apologies! -dK

Posting again for some good links for you since you are new to Access ... http://www.accessmvp.com/strive4peace/ http://www.vtc.com/products/Microsof...-tutorials.htm http://fisher.osu.edu/~muhanna_1/837/MSAccess/ http://www.functionx.com/...

Hello and welcome to the forums! What is stored is based on the "bound column" of the combo box. You can find this under the rowsource in the combo box properties. I would consider using a numeric based (autonumber) primary key for this table using an autonumber scheme and storing this in...

Just click on the the Totals (epsilon) in the QBE and in the Totals row use 'Average'. -dK

Good to go and good luck on your project. -dK

Awesome! Glad you got it to go. Good luck! -dK

Check into the Instr function, it might solve your problems. Here is is the idea except use your fields as the evaluation. Specific notes though: If substring is empty, it returns the start value. If substring is null, it returns null. If there is no match, it returns 0 to help you properly...

Stack the pictures on top of each other where you want them to appear and then use something like this in the Report Detail .... Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.txtEvalControl = CorrectValue Then Me.OLERedLight.Visible = True...

Pretty much when you click the comman button for the report - have it open a form. On that form you have your combo box and any other parameters you want to use. Change the query criteria to reference the form (Forms!frmFormName!ctlControl). Then use a command button to open the report...

So you have: - 3 tables and you want to search all of the tables at the same time. - Each table has a field (the one you want to search on). That field could have 1 of 4 possible combinations: -- 120V -- 129Vcc -- 12Vcc -- 120V, 129Vcc, 12Vcc - The tables can be linked...

Potentially. It is in accordance to the level of detail that you are wanting to record. Suppose, for instance some personnel were issued some M16s with scope and others not. I don't know if this could be a potential situation in your scenario but in some of the units I served with, this was...