Search results

What syntax do I type in a report to add up the number of names I have on the report. For example: Joe Smith Billy King Total = 2 <--This is the number I want

Is there a way to change the color of a tab form from its default grey color to something else, like white? I need to change the actual color of the tab control. Thanks for any help.

This might help, it helped me. It was a reply posted my someone named musicmaker: Put in VB code Private Sub Inv__AfterUpdate() Me.Description = Me.Inv_.Column(1) Me.Brand = Me.Inv_.Column(2) Me.Model = Me.Inv_.Column(3) End Sub But you must first create a combo box that contains the...

This worked out great, but when column(3) is blank I get some sort of error. What code can I add that will skip that field if it is blank. Thank in advance.

Thanks for your respons Karl. Let me know if I'm reading this right. From your example above, does: 1. Name = the name of the field listing the names. 2. Other Table = Subsitute the name of the other table in place of this. 3. Phone number = Subsitute the name of the phone number field. I...

I want to be able to use VBA to updated a table using another table. For example I type in the phone number and it automatically populates the persons name, address, etc. (gets the information from another table). The form will have other fields as well. Thanks in advance for any help.