Recent content by Instance

I think you're shooting yourself in the foot with your table design. Players can only be on a single team, so I'd do something like; tPlayers ..PlayerID ..FirstName ..LastName ..TeamID ..Whatever tTeams ..TeamID ..Name ..Whatever is team-specific. Perhaps mascot. Perhaps venue of choice...

Excellent info from Banana, many thanks. Hadn't thought of some of that. I'll have to play with it some to get it straight in my mind, but very good information. Glad to help how I could. Welcome to Access World (though I'm new, too, hah!). Best of luck with your application-building. :)

I think the best way would be to link the tables in the Form's data source so you have the field available on the form. If you don't understand Left/Right/Inner joins, you should definitely look them up. Not terribly complex, but super powerful. Alternatively, you could do it with a little VBA...

Well, you can call VBA functions in your queries, ala: MyField: IIF(Isnull([Table2].[PK],ChildFound(),"") But you're going to be running it on any record the query finds, I believe. Certainly on any record where you run a condition on that calculated field. This whole discussion is...

In my opinion, it kind of depends, but you don't need to use bound fields for query-calculated values, anway. If you have SomeValue and SomePct, you can set a field's data source to "=[SomeValue] * [SomePct]" and it will show you the calculated value. Or you can do it in a query and use the...

One other quick note: For a professional look, I removed the borders and labels on my subforms and put them on tabs, and leave them 'enabled' all the time. This way, the controls on them are disabled, but you can scroll through the Continuous Forms and see all the data. You also have more room...

It works great to set that property. It's a read/write string property, so you use something like: 'Enable or Disable controls related to 'Resolved' checkbox Private Sub EnableDisableControls() Dim blShow As Boolean 'We're counting on the checkbox not being null, which it should never...

Each form has a focus item on it. When you change forms, you type on that form's control with focus. So on a subform, something must always have focus. This is also causing me fits. I'm working on a solution that isn't exceptionally hokey. My current theory (untested, follow-up coming soon) is...