Search results

Well .. there were a couple of mistakes .. mine and yours. Make it look like ... If Me.arrival_data.Value > Date Then MsgBox "No" Me.arrival_data = Me.arrival_data.OldValue Me.arrival_data.SetFocus End If -dK

What is the M4 table? I understand what the 1297 is but not clear on what the M4 record is. Thanks! -dK

I guess my questions is ... are you more interested in managing just the equipment and where it is? Or the people, who they are, the equipment they have, and where they are? I ask this to determine to do one side of this - once you see it, you should be able to work it from the other side so...

Okay ... here is what I see. Trying to think of the best way to explain this. You are linking the subform by serial number. Thus in the query you are displaying two serial numbers but the form is only for one serial number so the subform only displays one item. You could link it by the...

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

This wouldn't be true if the federales hadn't of instituted boundaries for the insurance companies that we lowly serfs use. The ironic bit is that the federaly royalty is excluded from these boundaries so the cost is the same no matter where they use health services. I am sure if you traced...

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

Well said. Hence there is not a "one size fits all" thus protect the individual (and only the individual) and codefy laws so that one individual or group cannot infringe on another. This is why we were founded on a republic and not a democracy because a democracy creates a one-gang rule. In...

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