Search results

As you see I'm using InStr. I can't use Left because txtColor can hold more than one color, and there is no telling what order they will be checked and/or unchecked in.

What I meant to ask is how can I loop thru all the client records printing the proper information.

Sure. These are the check boxes: chkRed, chkBlue, chkGreen, chkYellow, chkBlack, chkPurple This is the text box: txtColor What I want: Checking each check box will add the corresponding color to the text box. How I think to accomplish the above: In the after update event of each check box...

I'm looking for a way to add/remove text to a text box in the after update event of a check box based on its value.

I'm creating a db for a realtor. One table holds all the property information, another, the clients and what they are looking for. I'm looking for a way to create a dynamic report (using a template) to print a list of the properties that match the criteria of each client. Any ideas and/or...

See this, there you will find several methods of sending emails.

I haven't been able to reproduce the problem on my computers. I'll try again on the clients machine when I get a chance.

I don't see why that should make a difference. In any event I tried both with no change.

ctl+s or the save button.

All changes. Changes in layout, addition of access objects (tables, forms etc.), deletion of access objects...

Update: If I open the A2010 accdb in A2007 it will show all the changes only if the file is in the same location as when it was edited in A2007.

I created an accdb using Access 2010, it opens in both Access 2007 and 2010. The problem is that any changes made using one version are not shown in the other version. I spent all day yesterday changing and adding things, I saved all changes, opened the file in A2007 and everything was fine, I...

Ok, thank you.

I was under the impression that your were saying that the properties could be set if the special effect is set to shadowed.

No. But they do have the BorderColor property, which is what I'm trying to set.

This is my latest attempt but it ignores the check boxes and option buttons. ' Ensure all fields are filled For Each ctl In Me.Controls Select Case ctl.ControlType Case acTextBox, acComboBox, acListBox If Len(Nz(ctl.Value, vbNullString)) = 0 Then...

Even with the Special Effect set to Shadowed it doesn't' work.

Can't find it in Access 2007.

What are shadows?

HaHa. But they do have the properties I'm trying assign them.