Search results

Which is the same setup as Ken posted in thread 3, and I in thread 4.

See if this does what you want. Double click Val 1 to set the value with the calculator (what I had laying around). If the value is greater than 100 it is valid. I left Null as also valid If you use the pop up and it is less than 100 then you cannot exit the control because you can cancel the...

On controls you can make the borders transparent or visible. They can have different colors, thickness, etc I am not sure of the horizontal line, but you can put a line control below your textboxes creating a repeating horizontal line.

How about the AfterUpdate then If you set a value of a control neither the before or after update events fire. These only fire from a user action.

MakeFormPick Me.Parent.Name, "frmCrdVendor-Pick", "cboDefaultVendorNo", "cboDefaultVendorNo", True, "fsubChild" Your pick form knows where to push the selected data. Can you modify that form to also set focus the to the control that was passed to the pick form when it sets the value. Then in...

Ken's "Mariages table" or "tblUnions" as I called it would still be a clearner way to do that and still maintain a history of marriages. In mine --Spouse1 --Spouse2 --MarriageDate --Status (Current, Annulled, Deceased spouse) In fact you will have to put some code and or indices so that the...

Regardless if you have data validation at the control level, you still need a final trap at the form's before update event. You should always do this. Only way to ensure something does not sneak by. Additionally you can have validation on the controls so that you get immediate validation, but...

More interesting is I asked Chat when this was fixed and Chat says it was always available. So maybe it was one of those urban myths that I assumed was true for year and never bothered checking. Which is grate because this is exactly a case where an accessor is useful.

Interesting. I wonder when that was fixed. That used to be a problem. Glad to see it is no longer.

I would argue that if you are lazy (and have MZTools) then creating accessors (let, get, set) for all class variables save a lot of coding time. With MZTools it takes a second to create the accessors from a class variable, but now coding is much faster especially with larger classes. I do not...

So let me see if I understand this. You interpret the OP to be at some kind of Mormon compound where members are married to multiple people? I did not see that coming. Even if so why would you have a Partner table separate from the members table? Is your assumption Partners are not members...

A lot of this is subjective and deals with readability, maintainability, ease of use, and ability to debug. You can go to either extreme. I tend to have a lot of modules if they are a related group of methods (printUtilities, applicationUtilities, FormUtilities, ImageUtilities etc...) But I do...

Self Referencing Approach If you wanted to do a self referencing table then keep the yellow fields You create your query by dropping the member table twice. Again alias it for ease of use 2. Create Query. This is a little more involved so that you do not get 1,2 and 2,1 for the same...

I would go with Ken's approach it is far easier. You could do what duane suggests and make a self referencing table but that is confusing unless you have done this before. Both work. Here is a version of Ken's to show how to do it. Also I modified it to handle an inclusive church where you can...

OK, I thought about what you are probably trying to do and I get the problem. This is not a table or normalization issue, but likely a GUI issue. This is not the traditional Parent Child model where you create the parents and then create new child records. This is an assignment problem, where...

Why would you expect to see a private procedure available outside of the class? Maybe I do not understand, but that is as expected.

That is a little confusing because you are leaning towards B, but you think the solution is indexes in A. If you simply need to make a HR assignment without maintaining history then B is the simpler and more correct solution. Unless there is more to it in the real problem. If you go with B you...

Sure I am all for creating efficient code, but when we need to start putting reality to things. It is not 1980. 1000 iterations is a fraction of a second. :rolleyes: When start worrying about fractions of seconds as being "Grim" that is a kind of silly. Moreover, I would think it is highly...

@MattBaldry, Trying to figure out why that did not work and I must have copied something wrong. Sorry about that I copied this and did not enclose the If For i = 0 To UBound(aItems) If Trim(aItems(i)) = Trim(newItem) Then found = True Exit For Next i Which does not make sense...

If you are keeping a historical record of each year in A approach then you can do something like Students-Homerooms --- StudentHomeroomID - (autonumber) --- StudentID_FK (foreign key to student table) --- HomeRoomID_FK (foreign key to homeroom table) --- CalendarYear Now you create a composite...